java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction

Oracle Community | 3004 | 1 decade ago
  1. 0

    SET TRANSACTION must be first statement of transaction

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
  2. 0

    setting isolation level fails

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
  3. 0

    OpenXava / Discussion / Help (English):jasper Reports

    sourceforge.net | 1 year ago
    java.sql.SQLException: READ_COMMITTED y SERIALIZABLE son los únicos niveles de transacción válidos
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Could not open JDBC Connection for transaction java.sql.SQLException: ORA-00923: - Spring Forum

    spring.io | 5 months ago
    org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-01453: SET TRANSACTION must be first statement of transaction

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      PhysicalConnection.setTransactionIsolation
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
      6. oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1027)
      8. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1515)
      9. oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1406)
      9 frames
    3. weblogic.jdbc.wrapper
      PoolConnection.setTransactionIsolation
      1. weblogic.jdbc.wrapper.PoolConnection.setTransactionIsolation(PoolConnection.java:146)
      1 frame
    4. com.solarmetric.jdbc
      DecoratingDataSource.getConnection
      1. com.solarmetric.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:266)
      2. com.solarmetric.jdbc.ConfiguringConnectionDecorator.decorate(ConfiguringConnectionDecorator.java:93)
      3. com.solarmetric.jdbc.DecoratingDataSource.decorate(DecoratingDataSource.java:90)
      4. com.solarmetric.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:74)
      4 frames
    5. kodo.jdbc.runtime
      JDBCStoreManager.begin
      1. kodo.jdbc.runtime.JDBCStoreManager.connectInternal(JDBCStoreManager.java:906)
      2. kodo.jdbc.runtime.JDBCStoreManager.connect(JDBCStoreManager.java:884)
      3. kodo.jdbc.runtime.JDBCStoreManager.retainConnection(JDBCStoreManager.java:189)
      4. kodo.jdbc.runtime.JDBCStoreManager.begin(JDBCStoreManager.java:114)
      4 frames
    6. kodo.runtime
      PersistenceManagerImpl.begin
      1. kodo.runtime.DelegatingStoreManager.begin(DelegatingStoreManager.java:95)
      2. kodo.runtime.PersistenceManagerImpl.beginStoreManagerTransaction(PersistenceManagerImpl.java:531)
      3. kodo.runtime.PersistenceManagerImpl.begin(PersistenceManagerImpl.java:501)
      3 frames
    7. com.tti.act
      MethodTask.run
      1. com.tti.act.flow.methods.impl.MethodEntity.openTransaction(MethodEntity.java:1843)
      2. com.tti.act.flow.TransactionAtomicCommandManager.executeAtomicCommandWithAutoCommitOnJob(TransactionAtomicCommandManager.java:52)
      3. com.tti.act.flow.JobFlow.innerInvokeMethod(JobFlow.java:955)
      4. com.tti.act.flow.FlowManager.innerInvokeMethod(FlowManager.java:1421)
      5. com.tti.act.flow.methods.impl.MethodTask.run(MethodTask.java:147)
      5 frames
    8. tti.jcore.mt
      QuartzJob.execute
      1. tti.jcore.mt.scheduler.ejb.JobExecutorBean.executeJob(JobExecutorBean.java:121)
      2. tti.jcore.mt.scheduler.ejb.JobExecutor_u19lg0_EOImpl.executeJob(JobExecutor_u19lg0_EOImpl.java:46)
      3. tti.jcore.mt.scheduler.impl.QuartzJob.execute(QuartzJob.java:101)
      3 frames
    9. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:178)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:487)
      2 frames