2011년 6월 13일 월요일

jdbcdslog(Tracing tool for JDBC)

The goal of the project is to create a high-performance and easy to use tool for the SQL queries logging for JDBC applications.
Features include:
  • can be attached on Connection, Driver or DataSource(XA,Pooling) levels
  • can log bind parameters for PreparedStatement and CallableStatement calls
  • can log result of queries from ResultSet objects
  • can log queries execution time
  • logging engine agnostic (thanks to SLF4J, you can use most of popular logging libraries like log4j, apache common logging, java logging or simple printing to System.out)
You have three choices how to configure logging proxy:

- wrap JDBC Connection object in your code.
You can use construction like following in this case:
Connection loggingConnection = ConnectionLoggingProxy.wrap(originalConnection);

- configure JDBC Driver logging proxy.
In this case you should use org.jdbcdslog.DriverLoggingProxy instead of the original JDBC Driver class and use jdbcdslog URL format for connection URL parameter:
jdbc:jdbcdslog:;targetDriver=
- configure JDBC DataSource logging proxy.
In this case you should use org.jdbcdslog.ConnectionPoolXADataSourceProxy class instead of your original DataSource class and pass additional parameter targetDS to the DataBase or URL setting for DataSource.

댓글 없음:

댓글 쓰기

ETL 솔루션 환경

ETL 솔루션 환경 하둡은 대용량 데이터를 값싸고 빠르게 분석할 수 있는 길을 만들어줬다. 통계분석 엔진인 “R”역시 하둡 못지 않게 관심을 받고 있다. 빅데이터 역시 데이터라는 점을 볼때 분산처리와 분석 그 이전에 데이터 품질 등 데이...