java.sql.SQLException

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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web10073

  • via Atlassian JIRA by Irakli Nadareishvili, 1 year ago
    ORA-01453: SET TRANSACTION must be first statement of transaction
  • ORA-01453: SET TRANSACTION must be first statement of transaction
  • via Google Groups by Nathan Keiter, 5 days ago
    ORA-01453: SET TRANSACTION must be first statement of transaction
  • Stack trace

    • java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736) at oracle.jdbc.driver.OracleConnection.setReadOnly(OracleConnection.java:1631) at com.stanchart.common.connectionpool.adapter.ConnectionImpl.setReadOnly(Unknown Source) at com.stanchart.common.connectionpool.newp.Jdbc2PoolDataSource.getConnection(Unknown Source) at com.stanchart.common.connectionpool.newp.Jdbc2PoolDataSource.getConnection(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    2 times, 2 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    2 times, 1 year ago
    28 more bugmates