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

Oracle Community | 3004 | 1 decade ago
  1. 0

    setting isolation level fails

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
  2. 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
  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:1028)
      8. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1516)
      9. oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1412)
      9 frames
    3. com.solarmetric.jdbc
      DelegatingDataSource.getConnection
      1. com.solarmetric.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:266)
      2. com.solarmetric.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:266)
      3. com.solarmetric.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:266)
      4. com.solarmetric.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:266)
      5. com.solarmetric.jdbc.ConfiguringConnectionDecorator.decorate(ConfiguringConnectionDecorator.java:93)
      6. com.solarmetric.jdbc.DecoratingDataSource.decorate(DecoratingDataSource.java:90)
      7. com.solarmetric.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:82)
      8. com.solarmetric.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:131)
      8 frames
    4. kodo.jdbc.schema
      DataSourceFactory$DefaultsDataSource.getConnection
      1. kodo.jdbc.schema.DataSourceFactory$DefaultsDataSource.getConnection(DataSourceFactory.java:305)
      1 frame
    5. kodo.jdbc.runtime
      JDBCStoreManager.begin
      1. kodo.jdbc.runtime.JDBCStoreManager.connectInternal(JDBCStoreManager.java:887)
      2. kodo.jdbc.runtime.JDBCStoreManager.connect(JDBCStoreManager.java:865)
      3. kodo.jdbc.runtime.JDBCStoreManager.retainConnection(JDBCStoreManager.java:189)
      4. kodo.jdbc.runtime.JDBCStoreManager.begin(JDBCStoreManager.java:114)
      4 frames
    6. kodo.runtime
      PersistenceManagerImpl.commit
      1. kodo.runtime.DelegatingStoreManager.begin(DelegatingStoreManager.java:95)
      2. kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:1004)
      3. kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:885)
      4. kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:69)
      5. kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:566)
      5 frames
    7. edu.sjsu.recon
      RequestProcessor.run
      1. edu.sjsu.recon.contribution.action.jdo.v10.kodo.v32.oracle.v101.simple.concurrency.AbstractConcurrentAction.initTestModel(AbstractConcurrentAction.java:290)
      2. edu.sjsu.recon.contribution.action.jdo.v10.kodo.v32.oracle.v101.simple.concurrency.AbstractConcurrentAction$InitRunnable.run(AbstractConcurrentAction.java:212)
      3. edu.sjsu.recon.util.ConcurrencyUtilities.executeSynchronized(ConcurrencyUtilities.java:20)
      4. edu.sjsu.recon.contribution.action.jdo.v10.kodo.v32.oracle.v101.simple.concurrency.AbstractConcurrentAction.setup(AbstractConcurrentAction.java:75)
      5. edu.sjsu.recon.execution.ServerExecutor.beforeExecute(ServerExecutor.java:27)
      6. edu.sjsu.recon.execution.AbstractExecutor.execute(AbstractExecutor.java:43)
      7. edu.sjsu.recon.execution.DefaultExecutionCoordinator.executeAction(DefaultExecutionCoordinator.java:25)
      8. edu.sjsu.recon.server.handler.ExecutionRequestHandler.handleRequest(ExecutionRequestHandler.java:63)
      9. edu.sjsu.recon.server.RequestProcessor.run(RequestProcessor.java:90)
      9 frames