java.sql.SQLSyntaxErrorException

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.

  • Calling StoredProcedure from TopLink
    via by 649006,
  • Dodawanie wpisy do tabeli. :: 4programmers.net
    via by Unknown author,
  • Tests failing on oracle11gR1RAC: org.hibernate.envers.test.integration.onetoone.bidirectional.ids.MulIdBidirectional.initData org.hibernate.envers.test.integration.onetoone.bidirectional.ids.MulIdBidirectional.testHistoryOfEdId1 org.hibernate.envers.test.integration.onetoone.bidirectional.ids.MulIdBidirectional.testHistoryOfEdId2 org.hibernate.envers.test.integration.onetoone.bidirectional.ids.MulIdBidirectional.testHistoryOfIngId1 org.hibernate.envers.test.integration.onetoone.bidirectional.ids.MulIdBidirectional.testRevisionsCounts Stacktrace: {quote} javax.persistence.RollbackException: Error while committing the transaction at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:92) at org.hibernate.envers.test.integration.onetoone.bidirectional.ids.MulIdBidirectional.initData(MulIdBidirectional.java:74) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42) at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:63) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30) at org.hibernate.testing.junit4.FailureExpectedHandler.evaluate(FailureExpectedHandler.java:58) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222) at org.hibernate.testing.junit4.BeforeClassCallbackHandler.evaluate(BeforeClassCallbackHandler.java:43) at org.hibernate.testing.junit4.AfterClassCallbackHandler.evaluate(AfterClassCallbackHandler.java:42) at org.junit.runners.ParentRunner.run(ParentRunner.java:300) at org.junit.runners.Suite.runChild(Suite.java:128) at org.junit.runners.Suite.runChild(Suite.java:24) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222) at org.junit.runners.ParentRunner.run(ParentRunner.java:300) at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassExecuter.runTestClass(JUnitTestClassExecuter.java:55) at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassExecuter.execute(JUnitTestClassExecuter.java:42) at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassProcessor.processTestClass(JUnitTestClassProcessor.java:75) at org.gradle.api.internal.tasks.testing.SuiteTestClassProcessor.processTestClass(SuiteTestClassProcessor.java:49) at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.gradle.messaging.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:35) at org.gradle.messaging.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24) at org.gradle.messaging.dispatch.ContextClassLoaderDispatch.dispatch(ContextClassLoaderDispatch.java:32) at org.gradle.messaging.dispatch.ProxyDispatchAdapter$DispatchingInvocationHandler.invoke(ProxyDispatchAdapter.java:93) at com.sun.proxy.$Proxy2.processTestClass(Unknown Source) at org.gradle.api.internal.tasks.testing.worker.TestWorker.processTestClass(TestWorker.java:103) at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.gradle.messaging.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:35) at org.gradle.messaging.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24) at org.gradle.messaging.remote.internal.TypeCastDispatch.dispatch(TypeCastDispatch.java:30) at org.gradle.messaging.remote.internal.WorkerProtocol.handleIncoming(WorkerProtocol.java:53) at org.gradle.messaging.remote.internal.WorkerProtocol.handleIncoming(WorkerProtocol.java:31) at org.gradle.messaging.remote.internal.ProtocolStack$ProtocolStage.handleIncoming(ProtocolStack.java:167) at org.gradle.messaging.remote.internal.ProtocolStack$BottomStage.handleIncoming(ProtocolStack.java:277) at org.gradle.messaging.remote.internal.ProtocolStack$BottomConnection$1.run(ProtocolStack.java:299) at org.gradle.messaging.remote.internal.ProtocolStack$ExecuteRunnable.dispatch(ProtocolStack.java:120) at org.gradle.messaging.remote.internal.ProtocolStack$ExecuteRunnable.dispatch(ProtocolStack.java:116) at org.gradle.messaging.dispatch.AsyncDispatch.dispatchMessages(AsyncDispatch.java:132) at org.gradle.messaging.dispatch.AsyncDispatch.access$000(AsyncDispatch.java:33) at org.gradle.messaging.dispatch.AsyncDispatch$1.run(AsyncDispatch.java:72) at org.gradle.internal.concurrent.DefaultExecutorFactory$StoppableExecutorImpl$1.run(DefaultExecutorFactory.java:66) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:80) ... 64 more Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:128) at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3058) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3499) at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88) at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:275) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:328) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52) at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1212) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:400) at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175) at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:75) ... 64 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:125) ... 78 more {quote} Output: {quote} ... 09:36:33,992 DEBUG SQL:104 - create table BiMulIdRefEdEntity (id1 number(10,0) not null, id2 number(10,0) not null, data varchar2(255 char), primary key (id1, id2)) 09:36:34,410 ERROR SchemaExport:425 - HHH000389: Unsuccessful: create table BiMulIdRefEdEntity (id1 number(10,0) not null, id2 number(10,0) not null, data varchar2(255 char), primary key (id1, id2)) 09:36:34,411 ERROR SchemaExport:426 - ORA-00942: table or view does not exist ... {quote}
    via by Martin Šimka,
    • java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3674) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354) at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172) at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1367) at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1337) at COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1211) at COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:943) at COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1271) at COM.FutureTense.CatalogManager.CatalogEngine.addToTable_trans(CatalogEngine.java:820) at COM.FutureTense.CatalogManager.CatalogEngine.addToTable(CatalogEngine.java:705) at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:752) at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3338) at COM.FutureTense.Common.CS.CatalogManager(CS.java:1501) at COM.FutureTense.Common.CS.CatalogManager(CS.java:1456) at com.openmarket.visitor.data.AbstractPersistentObject.callCatalogManager(AbstractPersistentObject.java:156) at com.openmarket.visitor.data.AbstractPersistentObject.executeWrite(AbstractPersistentObject.java:1343) at com.openmarket.visitor.data.AbstractPersistentObject.writeObject(AbstractPersistentObject.java:856) at com.openmarket.visitor.data.PersistentVisitorDataConnection.createAccessMethod(PersistentVisitorDataConnection.java:315) at com.openmarket.visitor.seed.VisitorDataManager.worker(VisitorDataManager.java:334) at com.openmarket.basic.seed.BaseSeed.endTag(BaseSeed.java:263) at COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:218) at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144) at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120) at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365) at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331) at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186) at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447) at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895) at COM.FutureTense.XML.Template.CallElement.execute(CallTag.java:253) at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144) at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120) at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397) at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496) at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144) at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120) at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397) at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496) at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144) at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120) at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365) at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331) at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186) at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447) at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895) at COM.FutureTense.Common.CS.CallElement(CS.java:1599) at COM.FutureTense.Apps.Install.command.ReadURL.exec(ReadURL.java:169) at COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130) at COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479) at COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104) at COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123) at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:453) at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129) at COM.FutureTense.Servlet.FTServlet.doGet(FTServlet.java:53) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:557) at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Jeremy
    12 times, last one,
    Unknown visitor1 times, last one,
    89 more bugmates