Sharad Jhingran [https://community.jboss.org/people/xhings] created the discussion
"SQL stmts Commit or Rollback confirmation" To view the discussion, visit: https://community.jboss.org/message/736880#736880 -------------------------------------------------------------- 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 -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/736880#736880] Start a new discussion in Performance Tuning at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2078]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
