org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.user_mapping' doesn't exist

Atlassian JIRA | Andre Bickford | 3 years ago
  1. 0

    This past weekend I attempted to upgrade from 5.1.3 to 5.2.5. This upgrade failed when it failed to find a table name user_mapping table. {noformat} 2013-09-28 16:00:33,300 ERROR [TP-Processor3] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.user_mapping' doesn't exist 2013-09-28 16:00:33,303 ERROR [TP-Processor3] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.user_mapping' doesn't exist 2013-09-28 16:00:33,307 ERROR [TP-Processor3] [[Catalina].[localhost].[/confluence].[noop]] log Servlet.service() for servlet noop threw exception org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.user_mapping' doesn't exist 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.execute(HibernateTemplate.java:337) at com.atlassian.confluence.user.persistence.dao.hibernate.HibernateConfluenceUserDao.findByUsername(HibernateConfluenceUserDao.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) {noformat} After a lot of banging my head on my desk I instead attempted to upgrade to 5.2.3 which succeeded. I infer from this that the 5.2.5 upgrade is missing the logic to create this necessary table, or that you can't upgrade to 5.2.5 directly and have to upgrade to 5.2.3 first. If it's the latter, this should be documented.

    Atlassian JIRA | 3 years ago | Andre Bickford
    org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.user_mapping' doesn't exist
  2. 0

    This past weekend I attempted to upgrade from 5.1.3 to 5.2.5. This upgrade failed when it failed to find a table name user_mapping table. {noformat} 2013-09-28 16:00:33,300 ERROR [TP-Processor3] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.user_mapping' doesn't exist 2013-09-28 16:00:33,303 ERROR [TP-Processor3] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.user_mapping' doesn't exist 2013-09-28 16:00:33,307 ERROR [TP-Processor3] [[Catalina].[localhost].[/confluence].[noop]] log Servlet.service() for servlet noop threw exception org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.user_mapping' doesn't exist 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.execute(HibernateTemplate.java:337) at com.atlassian.confluence.user.persistence.dao.hibernate.HibernateConfluenceUserDao.findByUsername(HibernateConfluenceUserDao.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) {noformat} After a lot of banging my head on my desk I instead attempted to upgrade to 5.2.3 which succeeded. I infer from this that the 5.2.5 upgrade is missing the logic to create this necessary table, or that you can't upgrade to 5.2.5 directly and have to upgrade to 5.2.3 first. If it's the latter, this should be documented.

    Atlassian JIRA | 3 years ago | Andre Bickford
    org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.user_mapping' doesn't exist
  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

    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'
  6. 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'

    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

      Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.user_mapping' doesn't exist

      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. Hibernate
      HibernateTemplate.execute
      1. org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364)
      2. org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351)
      3. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
      4. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
      4 frames
    4. com.atlassian.confluence
      HibernateConfluenceUserDao.findByUsername
      1. com.atlassian.confluence.user.persistence.dao.hibernate.HibernateConfluenceUserDao.findByUsername(HibernateConfluenceUserDao.java:79)
      1 frame
    5. Java RT
      NativeMethodAccessorImpl.invoke0
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      1 frame