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

Unable to create blog post - bad sql grammar exception (DB2)

    XMLWordPrintable

Details

    Description

      i am unable to create a blog post in confluence, below you will find the stacktrace generated by the system.

      yes i know db2 isn't officially supported, but if anyone could shed some insight on this, it would be helpful. everything else in the system works without issue.

      thx!


      org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -301, SQLSTATE: 07006, SQLERRMC: 3
      com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -301, SQLSTATE: 07006, SQLERRMC: 3
      at com.ibm.db2.jcc.c.cf.e(cf.java(Compiled Code))
      at com.ibm.db2.jcc.c.cf.a(cf.java(Compiled Code))
      at com.ibm.db2.jcc.a.be.n(be.java(Inlined Compiled Code))
      at com.ibm.db2.jcc.a.be.i(be.java(Compiled Code))
      at com.ibm.db2.jcc.a.be.c(be.java(Compiled Code))
      at com.ibm.db2.jcc.a.s.c(s.java(Inlined Compiled Code))
      at com.ibm.db2.jcc.a.bq.h(bq.java(Compiled Code))
      at com.ibm.db2.jcc.c.cf.i(cf.java(Inlined Compiled Code))
      at com.ibm.db2.jcc.c.cg.a(cg.java(Compiled Code))
      at com.ibm.db2.jcc.c.cg.executeQuery(cg.java(Compiled Code))
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java(Compiled Code))
      at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java(Compiled Code))
      at net.sf.hibernate.loader.Loader.getResultSet(Loader.java(Compiled Code))
      at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
      at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code))
      at net.sf.hibernate.loader.Loader.doList(Loader.java(Inlined Compiled Code))
      at net.sf.hibernate.loader.Loader.list(Loader.java(Compiled Code))
      at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java(Inlined Compiled Code))
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java(Compiled Code))
      at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java(Compiled Code))
      at bucket.core.persistence.hibernate.HibernateObjectDao$4.doInHibernate(HibernateObjectDao.java(Compiled Code))
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java(Compiled Code))
      at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java(Inlined Compiled Code))
      at bucket.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java(Compiled Code))
      at bucket.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:307)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao.getBlogPost(HibernateBlogPostDao.java:50)
      at com.atlassian.confluence.pages.DefaultPageManager.getBlogPost(DefaultPageManager.java:66)
      at sun.reflect.GeneratedMethodAccessor834.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
      at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
      at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java(Inlined Compiled Code))
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java(Inlined Compiled Code))
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code))
      at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java(Compiled Code))
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code))
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java(Compiled Code))
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code))
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java(Compiled Code))
      at $Proxy9.getBlogPost(Unknown Source)
      at com.atlassian.confluence.pages.actions.CreateBlogPostAction.validate(CreateBlogPostAction.java:34)
      at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:44)
      at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java(Compiled Code))
      at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.atlassian.confluence.user.actions.AuthenticatedUserInterceptor.intercept(AuthenticatedUserInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java(Compiled Code))
      at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java(Compiled Code))
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java(Compiled Code))
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java(Compiled Code))
      at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java(Compiled Code))
      at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java(Compiled Code))
      at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java(Compiled Code))
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java(Compiled Code))
      at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java(Compiled Code))
      at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java(Compiled Code))
      at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java(Compiled Code))
      at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java(Compiled Code))
      at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java(Compiled Code))
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java(Compiled Code))
      at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java(Compiled Code))
      at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java(Compiled Code))
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java(Compiled Code))
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java(Compiled Code))
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled Code))
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Inlined Compiled Code))
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java(Compiled Code))
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled Code))
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compiled Code))
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled Code))
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java(Compiled Code))
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java(Compiled Code))
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java(Compiled Code))
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java(Compiled Code))
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
      at java.lang.Thread.run(Thread.java:567)

      Referer URL: http://192.168.2.1:9980/confluence/pages/createblogpost.action?spaceKey=Test

      Build Information:
      Uptime: 1 day, 1 hour, 43 minutes, 50 seconds
      Version: 1.3
      Build Number: 112

      Server Information:
      Application Server: Apache Tomcat/4.1.29
      Servlet Version: 2.3
      Database Dialect: N/A

      Memory Information:
      Total Memory: 255 MB
      Free Memory: 91 MB
      Used Memory: 164 MB

      System Information:
      System Date: Thursday, 13 Jan 2005
      System Time: 12:48:41
      System Favourite Colour: Lime
      Java Version: 1.4.2
      Java Vendor: IBM Corporation
      JVM Version: 1.0
      JVM Vendor: Sun Microsystems Inc.
      JVM Implementation Version: 1.4.2
      Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
      Java VM: Classic VM
      User Name: jira
      User Timezone: US/Eastern
      Operating System: Linux 2.6.7
      OS Architecture: ppc64
      Request

      Information:
      URL: http://192.168.2.1:9980/confluence/pages/docreateblogpost.action

      • Scheme: http
      • Server: 192.168.2.1
      • Port: 9980
      • URI: /confluence/500page.jsp
      • - Context Path: /confluence
      • - Servlet Path: /500page.jsp
      • - Path Info: null
      • - Query String: spaceKey=Test

      Attributes:

      • javax.servlet.error.message :
      • javax.servlet.error.exception : org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -301, SQLSTATE: 07006, SQLERRMC: 3
      • os_securityfilter_already_filtered : true
      • _sitemesh_using_stream : false
      • com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
      • javax.servlet.error.request_uri : /confluence/pages/docreateblogpost.action
      • javax.servlet.error.status_code : 500
      • _sitemesh_filterapplied : true
      • javax.servlet.error.servlet_name : action
      • webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@2d181f0a
      • atlassian.core.seraph.original.url : /pages/docreateblogpost.action?spaceKey=Test
      • loginfilter.already.filtered : true
      • javax.servlet.jsp.jspException : org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -301, SQLSTATE: 07006, SQLERRMC: 3
      • sessioninview.FILTERED : true

      Parameters:

      • selectedText =
      • title = Test
      • confirm = Add
      • content = Test
      • spaceKey = Test
      • sel1 =
      • sel2 =

      Logging:
      0 log statements generated by this request.

      Attachments

        Issue Links

          Activity

            People

              jens@atlassian.com jens
              a2d78abb2b37 Jae Gangemi
              Votes:
              3 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: