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

BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Highest
    • None
    • 1.2.3
    • None
    • BEA WLS 8.1 SP3, Oracle9

    Description

      After installing Confluence 1.2.3 I'm getting a BadSqlGrammarException.
      The Oracle datasource is setup correctly within BEA WLS !!

      Cause:
      org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist

      Stack Trace: [hide]
      org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist

      java.sql.SQLException: ORA-00942: table or view does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:894)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:984)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2885)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2926)
      at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:92)
      at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
      at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:800)
      at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:860)
      at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1608)
      at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27)
      at bucket.user.persistence.dao.hibernate.BucketUserDAO$1.doInHibernate(BucketUserDAO.java:84)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150)
      at bucket.user.persistence.dao.hibernate.BucketUserDAO.findUserByUsername(BucketUserDAO.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:59)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:118)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:191)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148)
      at $Proxy64.findUserByUsername(Unknown Source)
      at com.opensymphony.user.provider.hibernate.HibernateCredentialsProvider.handles(HibernateCredentialsProvider.java:83)
      at bucket.user.providers.ChainedUserProvider.handles(ChainedUserProvider.java:125)
      at bucket.user.providers.CachingCredentialsProvider.handles(CachingCredentialsProvider.java:49)
      at com.opensymphony.user.UserManager.getProvider(UserManager.java:310)
      at com.opensymphony.user.UserManager.getEntity(UserManager.java:296)
      at com.opensymphony.user.UserManager.getUser(UserManager.java:190)
      at bucket.user.DefaultUserAccessor.getUser(DefaultUserAccessor.java:64)
      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:59)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:118)
      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:191)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148)
      at $Proxy71.getUser(Unknown Source)
      at com.atlassian.confluence.setup.actions.SetupAdministrator.execute(SetupAdministrator.java:38)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:166)
      at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55)
      at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:72)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.atlassian.confluence.user.actions.AuthenticatedUserInterceptor.intercept(AuthenticatedUserInterceptor.java:51)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:89)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278)
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996)
      at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145)
      at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:157)
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:82)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117)
      at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:26)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6458)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
      at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661)
      at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630)
      at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
      at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)

      Referer URL: http://www.javapolis.com:90/confluence/setup/setupadministrator-start.action

      Build Information:
      Uptime: 2 minutes, 30 seconds
      Version: 1.2.3
      Build Number: 60

      Server Information:
      Application Server: WebLogic Server 8.1 SP3 Tue Jun 29 23:11:19 PDT 2004 404973 WebLogic Server 8.1 SP3 Tue Jun 29 23:11:19 PDT 2004 404973 WebLogic Server 8.1 SP3 Tue Jun 29 23:11:19 PDT 2004 404973
      Servlet Version: 2.3
      Database Dialect: net.sf.hibernate.dialect.Oracle9Dialect

      Memory Information:
      Total Memory: 1014 MB
      Free Memory: 637 MB
      Used Memory: 377 MB

      System Information:
      System Date: Saturday, 09 Oct 2004
      System Time: 14:04:32
      System Favourite Colour: Jet Black
      Java Version: 1.4.2_05
      Java Vendor: Sun Microsystems Inc.
      JVM Version: 1.0
      JVM Vendor: Sun Microsystems Inc.
      JVM Implementation Version: 1.4.2_05-b04
      Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
      Java VM: Java HotSpot(TM) Server VM
      User Name: root
      User Timezone: MET
      Operating System: SunOS 5.9
      OS Architecture: sparc

      Attachments

        Issue Links

          Activity

            People

              dave@atlassian.com dave (Inactive)
              3b8d8f618d5f Stephan Janssen
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: