org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dept' in 'where clause'

Kuali JIRA | Mindi Balmer | 5 years ago
  1. 0

    Try to search by Department Name doesn't have a "Search" spy glass icon like other lookup pages and search on a departments gets following error... org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dept' in 'where clause' at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCount(PersistenceBrokerTemplate.java:217) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.executeSearch(LookupDaoOjb.java:158) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:77) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:63) at org.kuali.rice.kns.dao.proxy.LookupDaoProxy.findCollectionBySearchHelper(LookupDaoProxy.java:117) at sun.reflect.GeneratedMethodAccessor628.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) ....

    Kuali JIRA | 5 years ago | Mindi Balmer
    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dept' in 'where clause'
  2. 0

    Try to search by Department Name doesn't have a "Search" spy glass icon like other lookup pages and search on a departments gets following error... org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dept' in 'where clause' at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCount(PersistenceBrokerTemplate.java:217) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.executeSearch(LookupDaoOjb.java:158) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:77) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:63) at org.kuali.rice.kns.dao.proxy.LookupDaoProxy.findCollectionBySearchHelper(LookupDaoProxy.java:117) at sun.reflect.GeneratedMethodAccessor628.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) ....

    Kuali JIRA | 5 years ago | Mindi Balmer
    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dept' in 'where clause'
  3. 0

    Inconstant number of parameters in stored-proc-outbound-gateway

    Stack Overflow | 2 years ago | Andrey Vlasenko
    org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call dbo.pnzLimitUtilization_Show()}]; nested exception is java.sql.SQLException: Procedure or function 'pnzLimitUtilization_Show' expects parameter '@BookDate', which was not supplied.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'A0.ALLOW_NEGATIVE_ACC_BALANCE' in 'field list' at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.executeSearch(LookupDaoOjb.java:164) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:77) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:63) at org.kuali.rice.kns.dao.proxy.LookupDaoProxy.findCollectionBySearchHelper(LookupDaoProxy.java:117) at sun.reflect.GeneratedMethodAccessor461.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) ...

    Kuali JIRA | 5 years ago | Mindi Balmer
    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'A0.ALLOW_NEGATIVE_ACC_BALANCE' in 'field list'
  6. 0

    Steps to reproduce: # Create a page that is publicly accessible in OnDemand. # Visit the page using a [supported mobile device|https://confluence.atlassian.com/display/DOC/Supported+Platforms] (without logging in). You will receive an error saying: {quote}Oops! Something went wrong. It's probably us, but it might be you. Check your network connection.{quote} The following error will be generated in the Confluence logs: {noformat} org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bytea Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 468 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:364) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:319) at com.atlassian.confluence.mail.notification.persistence.dao.hibernate.HibernateNotificationDao.findNotificationByUserAndPage(HibernateNotificationDao.java:80) at com.atlassian.confluence.mail.notification.DefaultNotificationManager.getNotificationByUserAndPage(DefaultNotificationManager.java:48) {noformat}

    Atlassian JIRA | 3 years ago | Mike Knight
    org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bytea Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 468

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.springframework.jdbc.BadSqlGrammarException

      OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dept' in 'where clause'

      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate()
    2. Spring Framework
      AbstractFallbackSQLExceptionTranslator.translate
      1. org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
      2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      2 frames
    3. org.springmodules.orm
      PersistenceBrokerTemplate.getCount
      1. org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107)
      2. org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89)
      3. org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144)
      4. org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCount(PersistenceBrokerTemplate.java:217)
      4 frames
    4. org.kuali.rice
      LookupDaoProxy.findCollectionBySearchHelper
      1. org.kuali.rice.kns.dao.impl.LookupDaoOjb.executeSearch(LookupDaoOjb.java:158)
      2. org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:77)
      3. org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:63)
      4. org.kuali.rice.kns.dao.proxy.LookupDaoProxy.findCollectionBySearchHelper(LookupDaoProxy.java:117)
      4 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor628.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    6. Spring AOP
      ReflectiveMethodInvocation.invokeJoinpoint
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      2 frames