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.