java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • SW: OracleAS 10.1.3.2 + OracleDB 10.2.0.? Steps: 1. deploy 1.1.2 war 2. import enterprise 1.1.2 xar (works so far) 3. deploy 1.2 RC2 war 4. exception while accessing first page java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager$1.doInHibernate(XWikiHibernateMigrationManager.java:64) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721) at com.xpn.xwiki.XWiki.<init>(XWiki.java:672) Steps 2: 1. deploy 1.1.2 war 2. import enterprise 1.1.2 xar (works so far) 3. import enterprise 1.2 RC2 xar (works so far) 4. deploy 1.2 RC2 war 5. same exception while accessing first page
    via by Martin Vanek,
  • Rebuild Indexes
    via j-trac by rileybolt
    ,
  • Under My Evaluations, clicking the title of the evaluation seems to work, but clicking the (link) next to the title I see HTTP 500 - The server encountered an internal error () that prevented it from fulfilling this request. Is (link) just for testing and can be removed now? <span style="font-size:0.9em;">(<a href="http://localhost:8080/direct/eval-evaluation/1815" title="direct url to the evaluation">link</a>)</span> INFO: No evalGroupId supplied, doing abbreviated check for evalId=1815, userId=f0f507c4-e32a-4a79-00da-3197fa64517e (2007-06-06 11:33:41,679 http-8080-Processor23_org.sakaiproject.evaluation.logic.impl.EvalEvaluationsLogicImpl) WARN: Empty list of groups for user:f0f507c4-e32a-4a79-00da-3197fa64517e, permission: eval.take.evaluation (2007-06-06 11:33:41,685 http-8080-Processor23_org.sakaiproject.evaluation.logic.impl.EvalExternalLogicImpl) WARN: SQL Error: 936, SQLState: 42000 (2007-06-06 11:33:41,691 http-8080-Processor23_org.hibernate.util.JDBCExceptionReporter) ERROR: ORA-00936: missing expression (2007-06-06 11:33:41,691 http-8080-Processor23_org.hibernate.util.JDBCExceptionReporter) 2007-06-06 11:33:41,769 ERROR (AccessRegistrar.java:82) - <Error handling access request> Target exception of class org.springframework.jdbc.BadSqlGrammarException Successive lines until stack trace show causes progressing to exception site: Error fetching factory bean errorStateManager to initialise bean targettedMessageList --> Error setting dependency requestRSVC of bean errorStateManager --> Error fetching factory bean postDecoder to initialise bean requestRSVC --> Error setting dependency renderSystemDecoder of bean postDecoder --> Error fetching bean renderSystem from factory method getRenderSystem of factory bean renderSystemResolver --> Error fetching bean contentTypeInfo from factory method getContentTypeInfo of factory bean contentTypeInfoFactory --> Error fetching bean viewParameters from factory method getViewParameters of factory bean viewParamsInterceptorManager --> Error fetching bean defaultViewParameters from factory method getViewParameters of factory bean defaultViewInferrerManager --> Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID23_0_, this_.LAST_MODIFIED as LAST2_23_0_, this_.OWNER as OWNER23_0_, this_.group_id as group4_23_0_, this_.group_type as group5_23_0_, this_.INSTRUCTOR_APPROVAL as INSTRUCTOR6_23_0_, this_.INSTRUCTORS_VIEW_RESULTS as INSTRUCT7_23_0_, this_.STUDENTS_VIEW_RESULTS as STUDENTS8_23_0_, this_.EVALUATION_FK as EVALUATION9_23_0_ from EVAL_ASSIGN_GROUP this_ where this_.EVALUATION_FK=? and this_.INSTRUCTOR_APPROVAL=? and this_.group_id in ()]; nested exception is java.sql.SQLException: ORA-00936: missing expression org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID23_0_, this_.LAST_MODIFIED as LAST2_23_0_, this_.OWNER as OWNER23_0_, this_.group_id as group4_23_0_, this_.group_type as group5_23_0_, this_.INSTRUCTOR_APPROVAL as INSTRUCTOR6_23_0_, this_.INSTRUCTORS_VIEW_RESULTS as INSTRUCT7_23_0_, this_.STUDENTS_VIEW_RESULTS as STUDENTS8_23_0_, this_.EVALUATION_FK as EVALUATION9_23_0_ from EVAL_ASSIGN_GROUP this_ where this_.EVALUATION_FK=? and this_.INSTRUCTOR_APPROVAL=? and this_.group_id in ()]; nested exception is java.sql.SQLException: ORA-00936: missing expression java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.springframework.orm.hibernate3.HibernateTemplate$37.doInHibernate(HibernateTemplate.java:988) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:978) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:119) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:109) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:83) at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy5.findByProperties(Unknown Source) at org.sakaiproject.evaluation.logic.impl.EvalEvaluationsLogicImpl.canTakeEvaluation(EvalEvaluationsLogicImpl.java:652) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.inferDefaultViewParametersImpl(EvaluationVPInferrer.java:170) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.access$000(EvaluationVPInferrer.java:49) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer$1.run(EvaluationVPInferrer.java:96) at org.sakaiproject.genericdao.hibernate.HibernateGenericDao.invokeTransactionalAccess(HibernateGenericDao.java:94) at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy5.invokeTransactionalAccess(Unknown Source) at org.sakaiproject.evaluation.tool.wrapper.ModelAccessWrapperInvoker.invokeRunnable(ModelAccessWrapperInvoker.java:39) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.inferDefaultViewParameters(EvaluationVPInferrer.java:94) at uk.ac.cam.caret.sakai.rsf.entitybroker.EVPIManager.getViewParameters(EVPIManager.java:57) at uk.org.ponder.rsf.viewstate.DefaultViewInferrerManager.getViewParameters(DefaultViewInferrerManager.java:21) 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:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$a25f3849.get(<generated>) at uk.org.ponder.rsf.viewstate.BasicViewParametersParser.parse(BasicViewParametersParser.java:62) at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:248) at org.springframework.beans.factory.config.MethodInvokingFactoryBean.doInvoke(MethodInvokingFactoryBean.java:124) at org.springframework.beans.factory.config.MethodInvokingFactoryBean.afterPropertiesSet(MethodInvokingFactoryBean.java:113) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:571) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$5ca323fe.get(<generated>) at uk.org.ponder.rsf.viewstate.ViewParamsInterceptorManager.getViewParameters(ViewParamsInterceptorManager.java:22) at sun.reflect.GeneratedMethodAccessor115.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$4dbcb9e3.get(<generated>) at uk.org.ponder.rsf.content.ContentTypeInfoFactory.getContentType(ContentTypeInfoFactory.java:46) at uk.org.ponder.rsf.content.ContentTypeInfoFactory.getContentTypeInfo(ContentTypeInfoFactory.java:60) at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.content.ContentTypeInfo$$EnhancerByCGLIB$$f63a8ba4.get(<generated>) at uk.org.ponder.rsf.renderer.RenderSystemResolver.getRenderSystem(RenderSystemResolver.java:33) at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.fetchDependent(RSACBeanLocator.java:626) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:513) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:456) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.fetchDependent(RSACBeanLocator.java:626) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:513) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:456) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACErrorBridge.invokeRunnable(RSACErrorBridge.java:32) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:436) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.ac.cam.caret.sakai.rsf.entitybroker.AccessRegistrar.handleAccess(AccessRegistrar.java:78) at org.sakaiproject.entitybroker.servlet.DirectServlet.dispatch(DirectServlet.java:180) at org.sakaiproject.entitybroker.servlet.DirectServlet.handleRequest(DirectServlet.java:138) at org.sakaiproject.entitybroker.servlet.DirectServlet.doGet(DirectServlet.java:101) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:532) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:613) WARN: dispatch(): exception: (2007-06-06 11:33:41,778 http-8080-Processor23_org.sakaiproject.entitybroker.servlet.DirectServlet) org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID23_0_, this_.LAST_MODIFIED as LAST2_23_0_, this_.OWNER as OWNER23_0_, this_.group_id as group4_23_0_, this_.group_type as group5_23_0_, this_.INSTRUCTOR_APPROVAL as INSTRUCTOR6_23_0_, this_.INSTRUCTORS_VIEW_RESULTS as INSTRUCT7_23_0_, this_.STUDENTS_VIEW_RESULTS as STUDENTS8_23_0_, this_.EVALUATION_FK as EVALUATION9_23_0_ from EVAL_ASSIGN_GROUP this_ where this_.EVALUATION_FK=? and this_.INSTRUCTOR_APPROVAL=? and this_.group_id in ()]; nested exception is java.sql.SQLException: ORA-00936: missing expression java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.springframework.orm.hibernate3.HibernateTemplate$37.doInHibernate(HibernateTemplate.java:988) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:978) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:119) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:109) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:83) at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy5.findByProperties(Unknown Source) at org.sakaiproject.evaluation.logic.impl.EvalEvaluationsLogicImpl.canTakeEvaluation(EvalEvaluationsLogicImpl.java:652) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.inferDefaultViewParametersImpl(EvaluationVPInferrer.java:170) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.access$000(EvaluationVPInferrer.java:49) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer$1.run(EvaluationVPInferrer.java:96) at org.sakaiproject.genericdao.hibernate.HibernateGenericDao.invokeTransactionalAccess(HibernateGenericDao.java:94) at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy5.invokeTransactionalAccess(Unknown Source) at org.sakaiproject.evaluation.tool.wrapper.ModelAccessWrapperInvoker.invokeRunnable(ModelAccessWrapperInvoker.java:39) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.inferDefaultViewParameters(EvaluationVPInferrer.java:94) at uk.ac.cam.caret.sakai.rsf.entitybroker.EVPIManager.getViewParameters(EVPIManager.java:57) at uk.org.ponder.rsf.viewstate.DefaultViewInferrerManager.getViewParameters(DefaultViewInferrerManager.java:21) 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:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$a25f3849.get(<generated>) at uk.org.ponder.rsf.viewstate.BasicViewParametersParser.parse(BasicViewParametersParser.java:62) at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:248) at org.springframework.beans.factory.config.MethodInvokingFactoryBean.doInvoke(MethodInvokingFactoryBean.java:124) at org.springframework.beans.factory.config.MethodInvokingFactoryBean.afterPropertiesSet(MethodInvokingFactoryBean.java:113) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:571) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$5ca323fe.get(<generated>) at uk.org.ponder.rsf.viewstate.ViewParamsInterceptorManager.getViewParameters(ViewParamsInterceptorManager.java:22) at sun.reflect.GeneratedMethodAccessor115.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$4dbcb9e3.get(<generated>) at uk.org.ponder.rsf.content.ContentTypeInfoFactory.getContentType(ContentTypeInfoFactory.java:46) at uk.org.ponder.rsf.content.ContentTypeInfoFactory.getContentTypeInfo(ContentTypeInfoFactory.java:60) at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.content.ContentTypeInfo$$EnhancerByCGLIB$$f63a8ba4.get(<generated>) at uk.org.ponder.rsf.renderer.RenderSystemResolver.getRenderSystem(RenderSystemResolver.java:33) at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.fetchDependent(RSACBeanLocator.java:626) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:513) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:456) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.fetchDependent(RSACBeanLocator.java:626) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:513) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:456) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACErrorBridge.invokeRunnable(RSACErrorBridge.java:32) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:436) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.ac.cam.caret.sakai.rsf.entitybroker.AccessRegistrar.handleAccess(AccessRegistrar.java:78) at org.sakaiproject.entitybroker.servlet.DirectServlet.dispatch(DirectServlet.java:180) at org.sakaiproject.entitybroker.servlet.DirectServlet.handleRequest(DirectServlet.java:138) at org.sakaiproject.entitybroker.servlet.DirectServlet.doGet(DirectServlet.java:101) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:532) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:613)
    via by Richard Ellis,
  • Error in the BI Publisher
    via by 653361,
  • Exception when having different class and table name
    via by Gurpreet Singh,
  • Hibernate mapping in Spring - Getting Exception
    via by Gurpreet Singh,
    • java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager$1.doInHibernate(XWikiHibernateMigrationManager.java:64) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721) at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    76 more bugmates