1 Reply Latest reply on May 22, 2012 2:53 AM by Wolf-Dieter Fink

    SQL stmts Commit or Rollback confirmation

    Sharad Jhingran Newbie

      Hello All,

       

      Is there a way to understand if the sql statements have committed or rolled back in the server log file? I could trace the statements as follows:

       

      2012-05-21 05:58:44,769 -0700 level=DEBUG class=org.springframework.jdbc.core.JdbcTemplate              [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:569)  Executing prepared SQL statement [

      SELECT ACCOUNTNUMBER FROM MERCHANTACCOUNT_VW WHERE EID = ?

                              ]

      2012-05-21 05:58:44,769 -0700 level=DEBUG class=org.springframework.jdbc.datasource.DataSourceUtils              [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110) Fetching JDBC Connection from DataSource

      2012-05-21 05:58:44,776 -0700 level=DEBUG class=org.springframework.jdbc.core.StatementCreatorUtils              [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:206)  Setting SQL statement parameter value: column index 1, parameter value [3439957], value class [java.lang.Long], SQL type unknown

      2012-05-21 05:58:44,781 -0700 level=DEBUG class=org.springframework.jdbc.datasource.DataSourceUtils              [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:332) Returning JDBC Connection to DataSource

      2012-05-21 05:58:44,781 -0700 level=DEBUG class=org.springframework.jdbc.core.JdbcTemplate              [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:434) Executing SQL query [

      SELECT MEMOID_SEQ.NEXTVAL AS VALUE FROM DUAL

                              ]

       

      I want to find where the statements get committed or rolled back during the load test?

       

      Thanks for noticing!!

       

      Regards,
      Xhings