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.

  • setting isolation level fails
    via by 3004,
  • jasper Reports
    via openxava by snipex
    ,
  • I noticed this error during a large-sh test run. it appeared only twice in the log file, once early in the log file, and once during shut down. The shutdown failed, and I suspect that the error prevents the processing of any messages. First error message: 2014-11-14T16:20:24.905-0500 SEVERE IEPSEaaa03006: IEP service engine heart beat thread failed java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662) at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1661) 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:606) at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) at com.sun.proxy.$Proxy30.setTransactionIsolation(Unknown Source) at com.sun.jbi.engine.iep.core.runtime.util.Token.<init>(Token.java:60) at com.sun.jbi.engine.iep.core.runtime.DefaultIEPEngine.start(DefaultIEPEngine.java:138) at com.sun.jbi.engine.iep.IEPSEHeartBeatThread.run(IEPSEHeartBeatThread.java:148) Second error message: 2014-11-14T16:38:49.211-0500 INFO OESE-1504: HTTP Server stopped 2014-11-14T16:38:49.222-0500 SEVERE DBBC Binding component shutdown completed. 2014-11-14T16:38:49.284-0500 SEVERE IEPSEaaa08025: Failed to stop the service unit : SMABankLendingCA-SMAPoolManagerIEP java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662) at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1661) 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:606) at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) at com.sun.proxy.$Proxy30.setTransactionIsolation(Unknown Source) at com.sun.jbi.engine.iep.core.runtime.util.Token.<init>(Token.java:60) at com.sun.jbi.engine.iep.core.runtime.DefaultIEPEngine.stop(DefaultIEPEngine.java:204) at com.sun.jbi.engine.iep.IEPSEServiceUnitManager.stop(IEPSEServiceUnitManager.java:470) at com.sun.jbi.framework.ServiceUnitOperation.process(ServiceUnitOperation.java:188) at com.sun.jbi.framework.Operation.run(Operation.java:104) at java.lang.Thread.run(Thread.java:745) 2014-11-14T16:38:49.320-0500 INFO grizzlyHttpProtocol.stop 2014-11-14T16:38:49.324-0500 WARNING JBIFW2501: Error in ServiceUnitManager for Engine sun-iep-engine: <component-task-result> <component-name>sun-iep-engine</component-name> <component-task-result-details> <task-result-details> <task-id>stop</task-id> <task-result>FAILED</task-result> <message-type>ERROR</message-type> <exception-info> <nesting-level>0</nesting-level> <msg-loc-info> <loc-token>IepSeSum_Stop_1</loc-token> <loc-message>Service Unit stop error: ORA-01453: SET TRANSACTION must be first statement of transaction </loc-message> </msg-loc-info> <stack-trace> java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662) at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1661) 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:606) at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) at com.sun.proxy.$Proxy30.setTransactionIsolation(Unknown Source) at com.sun.jbi.engine.iep.core.runtime.util.Token.&lt;init&gt;(Token.java:60) at com.sun.jbi.engine.iep.core.runtime.DefaultIEPEngine.stop(DefaultIEPEngine.java:204) at com.sun.jbi.engine.iep.IEPSEServiceUnitManager.stop(IEPSEServiceUnitManager.java:470) at com.sun.jbi.framework.ServiceUnitOperation.process(ServiceUnitOperation.java:188) at com.sun.jbi.framework.Operation.run(Operation.java:104) at java.lang.Thread.run(Thread.java:745) </stack-trace> </exception-info> </task-result-details> </component-task-result-details> </component-task-result> 2014-11-14T16:38:49.327-0500 WARNING JBIFW2500: ServiceUnitManager stack trace follows: javax.jbi.management.DeploymentException: <component-task-result> <component-name>sun-iep-engine</component-name> <component-task-result-details> <task-result-details> <task-id>stop</task-id> <task-result>FAILED</task-result> <message-type>ERROR</message-type> <exception-info> <nesting-level>0</nesting-level> <msg-loc-info> <loc-token>IepSeSum_Stop_1</loc-token> <loc-message>Service Unit stop error: ORA-01453: SET TRANSACTION must be first statement of transaction </loc-message> </msg-loc-info> <stack-trace> java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662) at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1661) 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:606) at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) at com.sun.proxy.$Proxy30.setTransactionIsolation(Unknown Source) at com.sun.jbi.engine.iep.core.runtime.util.Token.&lt;init&gt;(Token.java:60) at com.sun.jbi.engine.iep.core.runtime.DefaultIEPEngine.stop(DefaultIEPEngine.java:204) at com.sun.jbi.engine.iep.IEPSEServiceUnitManager.stop(IEPSEServiceUnitManager.java:470) at com.sun.jbi.framework.ServiceUnitOperation.process(ServiceUnitOperation.java:188) at com.sun.jbi.framework.Operation.run(Operation.java:104) at java.lang.Thread.run(Thread.java:745) </stack-trace> </exception-info> </task-result-details> </component-task-result-details> </component-task-result> at com.sun.jbi.engine.iep.IEPSEServiceUnitManager.stop(IEPSEServiceUnitManager.java:477) at com.sun.jbi.framework.ServiceUnitOperation.process(ServiceUnitOperation.java:188) at com.sun.jbi.framework.Operation.run(Operation.java:104) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662) at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1661) 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:606) at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) at com.sun.proxy.$Proxy30.setTransactionIsolation(Unknown Source) at com.sun.jbi.engine.iep.core.runtime.util.Token.<init>(Token.java:60) at com.sun.jbi.engine.iep.core.runtime.DefaultIEPEngine.stop(DefaultIEPEngine.java:204) at com.sun.jbi.engine.iep.IEPSEServiceUnitManager.stop(IEPSEServiceUnitManager.java:470) ... 3 more 2014-11-14T16:38:49.406-0500 SEVERE POJOSE-7522: Exception while executing for ME null. java.lang.IllegalStateException: JBIMR0025: Unexpected illegal state change. Pattern (http://www.w3.org/2004/08/wsdl/in-out) TARGET-State (1) java.lang.IllegalStateException: JBIMR0025: Unexpected illegal state change. Pattern (http://www.w3.org/2004/08/wsdl/in-out) TARGET-State (1) at com.sun.jbi.messaging.MessageExchangeProxy.nextState(MessageExchangeProxy.java:716) at com.sun.jbi.messaging.MessageExchangeProxy.handleAccept(MessageExchangeProxy.java:776) at com.sun.jbi.messaging.DeliveryChannelImpl.acceptInternal(DeliveryChannelImpl.java:235) at com.sun.jbi.messaging.DeliveryChannelImpl.accept(DeliveryChannelImpl.java:202) at com.sun.jbi.common.qos.messaging.BaseMessagingChannel.accept(BaseMessagingChannel.java:249) at org.glassfish.openesb.pojose.jbi.thread.InboundProcessor.run(InboundProcessor.java:168) 2014-11-14T16:39:49.446-0500 WARNING MessagingException Id(105693257251934-35845-136352936043550068) : javax.jbi.messaging.MessagingException: JBIMR0022: Operation unavailable - DeliveryChannel has been closed. 2014-11-14T16:39:49.446-0500 WARNING MessagingException Id(105693257251934-35845-136352939035530040) : javax.jbi.messaging.MessagingException: JBIMR0022: Operation unavailable - DeliveryChannel has been closed. 2014-11-14T16:39:49.446-0500 WARNING MessagingException Id(105693257251934-35845-136352939006460210) : javax.jbi.messaging.MessagingException: JBIMR0022: Operation unavailable - DeliveryChannel has been closed.
    via by Ivan M,
  • Crazy Idea | Experiences of a geek-to-be
    via by Unknown author,
    • java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction 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.T4CStatement.doOall8(T4CStatement.java:112) at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1516) at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1412) at com.solarmetric.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:266) at com.solarmetric.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:266) at com.solarmetric.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:266) at com.solarmetric.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:266) at com.solarmetric.jdbc.ConfiguringConnectionDecorator.decorate(ConfiguringConnectionDecorator.java:93) at com.solarmetric.jdbc.DecoratingDataSource.decorate(DecoratingDataSource.java:90) at com.solarmetric.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:82) at com.solarmetric.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:131) at kodo.jdbc.schema.DataSourceFactory$DefaultsDataSource.getConnection(DataSourceFactory.java:305) at kodo.jdbc.runtime.JDBCStoreManager.connectInternal(JDBCStoreManager.java:887) at kodo.jdbc.runtime.JDBCStoreManager.connect(JDBCStoreManager.java:865) at kodo.jdbc.runtime.JDBCStoreManager.retainConnection(JDBCStoreManager.java:189) at kodo.jdbc.runtime.JDBCStoreManager.begin(JDBCStoreManager.java:114) at kodo.runtime.DelegatingStoreManager.begin(DelegatingStoreManager.java:95) at kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:1004) at kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:885) at kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:69) at kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:566) at edu.sjsu.recon.contribution.action.jdo.v10.kodo.v32.oracle.v101.simple.concurrency.AbstractConcurrentAction.initTestModel(AbstractConcurrentAction.java:290) at edu.sjsu.recon.contribution.action.jdo.v10.kodo.v32.oracle.v101.simple.concurrency.AbstractConcurrentAction$InitRunnable.run(AbstractConcurrentAction.java:212) at edu.sjsu.recon.util.ConcurrencyUtilities.executeSynchronized(ConcurrencyUtilities.java:20) at edu.sjsu.recon.contribution.action.jdo.v10.kodo.v32.oracle.v101.simple.concurrency.AbstractConcurrentAction.setup(AbstractConcurrentAction.java:75) at edu.sjsu.recon.execution.ServerExecutor.beforeExecute(ServerExecutor.java:27) at edu.sjsu.recon.execution.AbstractExecutor.execute(AbstractExecutor.java:43) at edu.sjsu.recon.execution.DefaultExecutionCoordinator.executeAction(DefaultExecutionCoordinator.java:25) at edu.sjsu.recon.server.handler.ExecutionRequestHandler.handleRequest(ExecutionRequestHandler.java:63) at edu.sjsu.recon.server.RequestProcessor.run(RequestProcessor.java:90)

    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,
    78 more bugmates