Saludos a todos.
Tengo el siguiente codigo en log4j.properties
# Global logging configurationlog4j.rootLogger=ERROR, stdout
log4j.logger.com.ibatis=DEBUG
# shows SQL of prepared statementslog4j.logger.java.sql.Connection=DEBUG
# shows parameters inserted into prepared statementslog4j.logger.java.sql.PreparedStatement=DEBUG
# shows query resultslog4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.Statement=DEBUG
# Console outputlog4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
y por consola me sale lo siguiente:[8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {conn-100195} Connection[8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {conn-100195} Preparing Statement: SELECT clt.COD_CEGWACLT as COD_CEGWACLT, clt.DES_NOMBCOLA as DES_NOMBCOLA FROM TEGWACLT clt INNER JOIN TEGWAato ato ON clt.COD_CEGWACLT = ato.COD_CEGWACLT WHERE ato.COD_CEGWAAVI = ? [8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {pstm-100196} Executing Statement: SELECT clt.COD_CEGWACLT as COD_CEGWACLT, clt.DES_NOMBCOLA as DES_NOMBCOLA FROM TEGWACLT clt INNER JOIN TEGWAato ato ON clt.COD_CEGWACLT = ato.COD_CEGWACLT WHERE ato.COD_CEGWAAVI = ? [8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {pstm-100196} Parameters: [570][8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {pstm-100196} Types: [java.lang.Long][8/03/12 16:01:03:509 CET] 00000027 SystemOut O 2012-03-08 16:01:03,509 DEBUG [WebContainer : 2] - {rset-100197} ResultSet[8/03/12 16:01:03:509 CET] 00000027 SystemOut O 2012-03-08 16:01:03,509 DEBUG [WebContainer : 2] - {rset-100017} Result: [570, 2011-12-27 09:18:54.0, XE25116, 2011-12-27 00:00:00.0, 27/12/11, 0, null, null, null, XE25116, 2011-12-27 09:18:54.0, null, 570]
Alguien sabe que parametros tengo que poner para que me indique que la conexion se ha cerrado.
gracias por adelantado.
Saludos a todos.
Tengo el siguiente codigo en log4j.properties
# Global logging configuration
log4j.rootLogger=ERROR, stdout
log4j.logger.com.ibatis=DEBUG
# shows SQL of prepared statements
log4j.logger.java.sql.Connection=DEBUG
# shows parameters inserted into prepared statements
log4j.logger.java.sql.PreparedStatement=DEBUG
# shows query results
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.Statement=DEBUG
# Console output
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
y por consola me sale lo siguiente:
[8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {conn-100195} Connection
[8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {conn-100195} Preparing Statement: SELECT clt.COD_CEGWACLT as COD_CEGWACLT, clt.DES_NOMBCOLA as DES_NOMBCOLA FROM TEGWACLT clt INNER JOIN TEGWAato ato ON clt.COD_CEGWACLT = ato.COD_CEGWACLT WHERE ato.COD_CEGWAAVI = ?
[8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {pstm-100196} Executing Statement: SELECT clt.COD_CEGWACLT as COD_CEGWACLT, clt.DES_NOMBCOLA as DES_NOMBCOLA FROM TEGWACLT clt INNER JOIN TEGWAato ato ON clt.COD_CEGWACLT = ato.COD_CEGWACLT WHERE ato.COD_CEGWAAVI = ?
[8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {pstm-100196} Parameters: [570]
[8/03/12 16:01:03:493 CET] 00000027 SystemOut O 2012-03-08 16:01:03,493 DEBUG [WebContainer : 2] - {pstm-100196} Types: [java.lang.Long]
[8/03/12 16:01:03:509 CET] 00000027 SystemOut O 2012-03-08 16:01:03,509 DEBUG [WebContainer : 2] - {rset-100197} ResultSet
[8/03/12 16:01:03:509 CET] 00000027 SystemOut O 2012-03-08 16:01:03,509 DEBUG [WebContainer : 2] - {rset-100017} Result: [570, 2011-12-27 09:18:54.0, XE25116, 2011-12-27 00:00:00.0, 27/12/11, 0, null, null, null, XE25116, 2011-12-27 09:18:54.0, null, 570]
Alguien sabe que parametros tengo que poner para que me indique que la conexion se ha cerrado.
gracias por adelantado.