Some password managers for my mobile phone:
Password managers for Nokia with Symbian/S60
7. October, 2010
Leave a Comment » | 
Software | Tagged: Nokia, Password, Password manager, S60, Symbian | 
Permalink
Posted by digulla
Wiki-like editors/notebooks
7. October, 2010A list of wiki-like editors/notebooks/etc:
Leave a Comment » | Software | Tagged: Editor, Notebook, wiki | Permalink
Posted by digulla
Logging JDBC with slf4j
7. October, 2010
Image via Wikipedia
If you use slf4j in your project and need to log JDBC events, then have a look at log4jdbc. It has all the usual features: Timing statements, showing all arguments, mapping SQL to connections. It can even log stack traces if you need to know where a JDBC call was made. Sample output:
16:32:56.162 [INFO ] jdbc.connection - 1. Connection opened java.sql.DriverManager.getConnection(DriverManager.java:525) 16:32:56.168 [DEBUG] jdbc.connection - open connections: 1 (1) 16:32:56.169 [DEBUG] jdbc.audit - 1. Connection.new Connection returned java.sql.DriverManager.getConnection(DriverManager.java:525) 16:32:56.284 [DEBUG] jdbc.audit - 1. PreparedStatement.new PreparedStatement returned com.avanon.basic.db.XPreparedStatement.prepare(XPreparedStatement.java:84) 16:32:56.292 [DEBUG] jdbc.audit - 1. Connection.prepareStatement(SELECT * FROM V_RCSA_40_4_CTRL_RATING) returned net.sf.log4jdbc.PreparedStatementSpy@423606 com.avanon.basic.db.XPreparedStatement.prepare(XPreparedStatement.java:84) 16:32:56.162 [INFO ] jdbc.connection - 1. Connection opened java.sql.DriverManager.getConnection(DriverManager.java:525) 16:32:56.168 [DEBUG] jdbc.connection - open connections: 1 (1) 16:32:56.169 [DEBUG] jdbc.audit - 1. Connection.new Connection returned java.sql.DriverManager.getConnection(DriverManager.java:525) 16:32:56.284 [DEBUG] jdbc.audit - 1. PreparedStatement.new PreparedStatement returned com.avanon.basic.db.XPreparedStatement.prepare(XPreparedStatement.java:84) 16:32:56.292 [DEBUG] jdbc.audit - 1. Connection.prepareStatement(SELECT *FROM V_RCSA_40_4_CTRL_RATING) returned net.sf.log4jdbc.PreparedStatementSpy@423606 com.avanon.basic.db.XPreparedStatement.prepare(XPreparedStatement.java:84) 16:32:56.342 [DEBUG] jdbc.audit - 1. PreparedStatement.clearParameters() returned com.avanon.basic.db.SetParameters.clear(SetParameters.java:144) 16:32:56.343 [DEBUG] jdbc.sqlonly - com.avanon.basic.db.XPreparedStatement.executeQuery(XPreparedStatement.java:71) 1. SELECT * FROM V_RCSA_40_4_CTRL_RATING 16:32:56.350 [INFO ] jdbc.sqltiming - SELECT * FROM V_RCSA_40_4_CTRL_RATING {executed in 7 msec} 16:32:56.356 [DEBUG] jdbc.audit - 1. PreparedStatement.executeQuery() returned net.sf.log4jdbc.ResultSetSpy@2c5444 com.avanon.basic.db.XPreparedStatement.executeQuery(XPreparedStatement.java:71) 16:32:56.412 [DEBUG] jdbc.audit - 1. PreparedStatement.close() returned com.avanon.basic.db.DBUtil.close(DBUtil.java:114) 16:32:56.418 [INFO ] jdbc.connection - 1. Connection closed com.avanon.basic.db.DBUtil.close(DBUtil.java:129) 16:32:56.418 [DEBUG] jdbc.connection - open connections: none
The strange “1.” is the connection number.
Alternatively, check out jdbcdslog.
Leave a Comment » | Software | Tagged: Databases and Persistence, Java, Java Database Connectivity, JDBC, JDBC driver, Programming, SQL | Permalink
Posted by digulla
Dark Views 