Spring事务管理JDBC连接详细日志 Spring 事务

Root WebApplicationContext: startup date [Sat Apr 13 19:29:05 CST 2013]; root of context hierarchy

727844 DEBUG [http-8080-1] org.springframework.beans.factory.support.DefaultListableBeanFactory     - Returning cached instance of singleton bean 'fooService'

727844 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Creating new transaction with name [x.y.service.FooService.getFoo]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly

727844 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Acquired Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] for JDBC transaction

727844 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceUtils     - Setting JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] read-only

727844 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Switching JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] to manual commit

727844 DEBUG [http-8080-1] org.springframework.beans.factory.support.DefaultListableBeanFactory     - Returning cached instance of singleton bean 'dataSource'

727844 DEBUG [http-8080-1] org.springframework.jdbc.core.JdbcTemplate     - Executing SQL query [select count(*) from emp]

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Initiating transaction commit

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Committing JDBC transaction on Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver]

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceUtils     - Resetting read-only flag of JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver]

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Releasing JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] after transaction

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceUtils     - Returning JDBC Connection to DataSource

 

 

 

 

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Creating new transaction with name [x.y.service.FooService.insertFoo]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Acquired Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] for JDBC transaction

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Switching JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] to manual commit

727937 DEBUG [http-8080-1] org.springframework.beans.factory.support.DefaultListableBeanFactory     - Returning cached instance of singleton bean 'dataSource'

727937 DEBUG [http-8080-1] org.springframework.jdbc.core.JdbcTemplate     - Executing SQL statement [insert into emp values(1000, 'awp', 'CLERK', 8200, to_date('2013-04-13', 'yyyy-mm-dd'), 8000, 0, 10)]

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Initiating transaction commit

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Committing JDBC transaction on Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver]

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager     - Releasing JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] after transaction

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceUtils     - Returning JDBC Connection to DataSource