session.commit() 적용 전
: sqlSession created
: Openning JDBC Connection
: Checked out connection 31516585 from pool.
: Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1e0e7a9]
: ooo Using Connection [com.mysql.jdbc.JDBC4Connection@1e0e7a9]
: ==> Preparing: INSERT INTO SDK_SMS_SEND(USER_ID, SUBJECT, SMS_MSG, NOW_DATE, SEND_DATE, CALLBACK, DEST_COUNT, DEST_INFO, RESERVED1, SEND_COUNT) VALUES('myshuttle', ?, ?, sysdate()+0, ?, ?, ?, ?, ?, '3')
: ==> Parameters: 고객 전송 문자(String), 안녕하세요.(String), 20120401010101(String), 020000000(String), 2(Integer), sklee^00010001000|iu^00010002000(String), admin(String)
: ooo Using Connection [com.mysql.jdbc.JDBC4Connection@1e0e7a9]
: ==> Preparing: SELECT LAST_INSERT_ID();
: ==> Parameters:
: <== Columns: LAST_INSERT_ID()
: <== Row: 21
: Rolling back JDBC Connection [com.mysql.jdbc.JDBC4Connection@1e0e7a9]
: Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1e0e7a9]
: Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@1e0e7a9]
: Returned connection 31516585 to pool.
: sqlSession closed
session.commit() 적용 후
: sqlSession created
: Openning JDBC Connection
: Checked out connection 6826369 from pool.
: Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@682981]
: ooo Using Connection [com.mysql.jdbc.JDBC4Connection@682981]
: ==> Preparing: INSERT INTO SDK_SMS_SEND(USER_ID, SUBJECT, SMS_MSG, NOW_DATE, SEND_DATE, CALLBACK, DEST_COUNT, DEST_INFO, RESERVED1, SEND_COUNT) VALUES('myshuttle', ?, ?, sysdate()+0, ?, ?, ?, ?, ?, '3')
: ==> Parameters: 고객 전송 문자(String), 안녕하세요.(String), 20120401010101(String), 020000000(String), 2(Integer), sklee^00010001000|iu^00010002000(String), admin(String)
: ooo Using Connection [com.mysql.jdbc.JDBC4Connection@682981]
: ==> Preparing: SELECT LAST_INSERT_ID();
: ==> Parameters:
: <== Columns: LAST_INSERT_ID()
: <== Row: 22
: Committing JDBC Connection [com.mysql.jdbc.JDBC4Connection@682981]
: Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@682981]
: Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@682981]
: Returned connection 6826369 to pool.
: sqlSession closed
'Framework & Platform > mybatis' 카테고리의 다른 글
iBatis - DBCP (0) | 2012.12.07 |
---|---|
Spring3 MVC에서 Mybatis 설정하기 (0) | 2012.05.09 |
useGenerateKeys 사용하기 예제 (0) | 2012.05.01 |
mybatis 3 settings 예제 (0) | 2012.04.30 |
mybatis password 암호화/복호화 (0) | 2012.04.28 |