Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-3377

Upgrade issue from 1.3 to 1.4.1 with DB2

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • High
    • 1.4.2
    • 1.4.1

    Description

      org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0418N A statement contains a use of a parameter marker that is not valid. SQLSTATE=42610
      COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0418N A statement contains a use of a parameter marker that is not valid. SQLSTATE=42610
      at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
      at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
      at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
      at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown Source)
      at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(Unknown Source)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75)
      at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
      at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
      at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:868)
      at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1619)
      at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:29)
      at com.atlassian.confluence.mail.persistence.dao.hibernate.HibernateMailDao$1.doInHibernate(HibernateMailDao.java:84)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
      at com.atlassian.confluence.mail.persistence.dao.hibernate.HibernateMailDao.getSpaceMailIterator(HibernateMailDao.java:75)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:142)
      at $Proxy12.getSpaceMailIterator(Unknown Source)
      at com.atlassian.confluence.mail.DefaultMailContentManager.getSpaceMailIterator(DefaultMailContentManager.java:40)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
      at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
      at $Proxy13.getSpaceMailIterator(Unknown Source)
      at com.atlassian.confluence.upgrade.MailCreationDateUpgradeTask.doUpgrade(MailCreationDateUpgradeTask.java:111)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
      at $Proxy24.doUpgrade(Unknown Source)
      at bucket.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:103)
      at bucket.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:63)
      at bucket.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:27)
      at com.atlassian.confluence.upgrade.ConfluenceUpgradeServletContextListener.contextInitialized(ConfluenceUpgradeServletContextListener.java:14)
      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3276)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:3618)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
      at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:307)
      at org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
      at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
      at org.apache.catalina.core.StandardService.start(StandardService.java:497)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
      at org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:273)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java:245)
      at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:307)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              a715b9cd8108 RefuX Zanzeebarr
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: