[IBATISNET-35] Improve logging of text sent to database and recieved from database to match Java version of IBatis

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: DataAccess 1.5, DataMapper 1.1
• Environment: Data Mapper - [assembly: AssemblyVersion("1.1.458")]; Data Access - [assembly: AssemblyVersion("1.5.458")]
• Assignee: Gilles Bayon
• Reporter: liu ron
• Created: 13/Apr/05 09:09
• Updated: 21/Mar/08 10:01
• Resolved: 21/Mar/08 10:01

Description

Here are some example logs from the Java version of IBatis. The examples show INSERT, SELECT, UPDATE, and DELETE statements:

DEBUG - Checked out connection 30332961 from pool.
DEBUG -

{conn-100003}

Connection
DEBUG -

{pstm-100004} PreparedStatement: INSERT INFO UserAudit (UserId, AuditEvent, DateOccurred) values (?,?,?)
DEBUG - {pstm-100004}

Parameters: [4, audit.login.success, 2004-08-25 09:15:22.809]
DEBUG -

{pstm-100004}

Types: [java.lang.Integer, java.lang.String, java.sql.Timestamp]
DEBUG -

{pstm-100005} PreparedStatement: SELECT LAST_INSERT_ID() AS id
DEBUG - {pstm-100005}

Parameters: []
DEBUG -

{pstm-100005}

Types: []
DEBUG -

{rset-100006} ResultSet
DEBUG - {rset-100006}

Header: [id]
DEBUG -

{rset-100006}

Result: [422]
DEBUG - Returned connection 30332961 to pool.

DEBUG - Checked out connection 30332961 from pool.
DEBUG -

{conn-100007}

Connection
DEBUG -

{pstm-100008} PreparedStatement: SELECT UserId, Login, Password FROM User WHERE Login = ? and Password = ?
DEBUG - {pstm-100008}

Parameters: [abc123, def456]
DEBUG -

{pstm-100008}

Types: [java.lang.String, java.lang.String]
DEBUG -

{rset-100009} ResultSet
DEBUG - {rset-100009}

Header: [UserId, Login, Password]
DEBUG -

{rset-100009}

Result: [4, abc1234, def456]
DEBUG - Returned connection 30332961 to pool.

DEBUG - Checked out connection 4548856 from pool.
DEBUG -

{conn-100045}

Connection
DEBUG -

{pstm-100046} PreparedStatement: SELECT UserId, Login FROM User
DEBUG - {pstm-100046}

Parameters: []
DEBUG -

{pstm-100046}

Types: []
DEBUG -

{rset-100047} ResultSet
DEBUG - {rset-100047}

Header: [UserId, Login]
DEBUG -

{rset-100047} Result: [1, abc123]
DEBUG - {rset-100047}

Result: [4, def456]
DEBUG -

{rset-100047}

Result: [6, aaaaa]
DEBUG - Returned connection 4548856 to pool.

DEBUG - Checked out connection 7125805 from pool.
DEBUG -

{conn-100043} Connection
DEBUG - {pstm-100044} PreparedStatement: UPDATE User SET Login = ? WHERE UserId = ?
DEBUG - {pstm-100044} Parameters: [aaaaa, 4]
DEBUG - {pstm-100044} Types: [java.lang.String, java.lang.Integer]
DEBUG - Returned connection 7125805 to pool.

DEBUG - Checked out connection 27062282 from pool.
DEBUG - {conn-100043}

Connection
DEBUG -

{pstm-100044} PreparedStatement: DELETE FROM User WHERE UserId = ?
DEBUG - {pstm-100044}

Parameters: [4]
DEBUG -

{pstm-100044}

Types: [java.lang.Integer]
DEBUG - Returned connection 27062282 to pool.

Sub-Tasks

• Store additional <statement> debug information in the MDC: Closed