Java Cover Story — Debugging JDBC with a Logging Driver

A couple of years ago I began developing in Java, and my first Java project required that I also learn SQL. Our project team was using mostly EJBs for database access, although for some performance-critical sections of the application we wrote the JDBC logic directly. A problem that we faced regularly was tracking the bind parameters to our PreparedStatements. Over the course of the project, all of the team members tried different techniques to determine what our JDBC statements were actually doing.

Reader Feedback: Page 1 of 1

#8	Good grief commented on 28 Apr 2006 P6Spy has done this for years, is completely open source, and has support tools. Why on earth do people not bother to resarch these things - and how on earth did this article get past the editors
#7	SYS-CON Australia News Desk commented on 28 Apr 2006 A couple of years ago I began developing in Java, and my first Java project required that I also learn SQL. Our project team was using mostly EJBs for database access, although for some performance-critical sections of the application we wrote the JDBC logic directly. A problem that we faced regularly was tracking the bind parameters to our PreparedStatements. Over the course of the project, all of the team members tried different techniques to determine what our JDBC statements were actually doing.
#6	SYS-CON India News Desk commented on 27 Apr 2006 A couple of years ago I began developing in Java, and my first Java project required that I also learn SQL. Our project team was using mostly EJBs for database access, although for some performance-critical sections of the application we wrote the JDBC logic directly. A problem that we faced regularly was tracking the bind parameters to our PreparedStatements. Over the course of the project, all of the team members tried different techniques to determine what our JDBC statements were actually doing.
#5	JDJ News Desk commented on 27 Apr 2006 A couple of years ago I began developing in Java, and my first Java project required that I also learn SQL. Our project team was using mostly EJBs for database access, although for some performance-critical sections of the application we wrote the JDBC logic directly. A problem that we faced regularly was tracking the bind parameters to our PreparedStatements. Over the course of the project, all of the team members tried different techniques to determine what our JDBC statements were actually doing.
#4	Vajee Uddin commented on 21 Apr 2006 I have implemented spy6log for logging the JBDC statements executed. It not only logs the queries but also the resultsets. Check this out. I would like to know you comments and views on this tool.
#3	Shilpa commented on 19 Apr 2006 Hi, I tried using the LogDriver and it did not work for me. The problem i faced is that it was not able to get a connection. I was using jdbc:log:oracle.jdbc.driver.OracleDriver:oracle:thin as the URL for database connection. It did not seem to work. Is there any formal documentation available for the Logdriver? Please let me know. It would be great if I get it working. Thanks.
#2	William Louth commented on 18 Apr 2006 JDBInsight (now a sub component of JXInsight) has been in production at some very large J2EE sites for the last 3 years. Honestly there was simply no need for another logging driver especially as most implementations are extremely primitive only performing System.out calls. You should have checked out the following links to see the tooling that is required for enterprise production systems in both test and production modes. http://www.jinspired.com/products/jxinsight/new-in-2.1.html http://www.jinspired.com/products/jxinsight/new-in-2.5.html http://www.jinspired.com/products/jxinsight/new-in-3.0.html http://www.jinspired.com/products/jxinsight/new-in-3.1.html http://www.jinspired.com/products/jxinsight/new-in-3.2.html http://www.jinspired.com/products/jxinsight/new-in-4.0.html http://www.jinspired.com/products/jxinsight/new-in-4.1.html William Louth JXInsight Product Architect JInspired "J2EE tuning, testing and tracing with JXInsight" http://www.jinspired.com
#1	Thorbjørn commented on 18 Apr 2006 Is there any particular reason that you chose to write your own instead of using the p6spy driver which AFAIK does the same?

YOUR FEEDBACK

	TechTarget Gets Caught Spying on SYS-CON By James Hamilton TechTarget Spy News wrote: SYS-CON Events' sales team replied to Scott Kelly's exhibitor inquiry, but when they never heard back from Scott, they decided to do a little Googling and here is what they found out. Mr Kelly is actually the 'Director of Product Management at TechTarget,' a technology media company that is struggli...
	High-Performance Batch Processing with Java Enterprise Edition By Colin Hendricks Snehal Antani wrote: Kalyan, to answer your questions: "what are the hiccups?": a key issue with batch processing using java and application servers relates to JDBC cursors, transactions, and holding cursors across transactions. Checkpointing - committing work periodically so you can restart the job if needed - is i...
	Optimizing Database Performance in J2EE Applications By Didier Cabannes kasiazaki wrote: dfdf
	A Compiled JavaFX Script Example: Spinning Wheel Got to Go 'Round By James L. Weaver Tattoo Designs wrote: Interesting little idea. I'd like to see it made into a more useful example, or used for a more practical purpose.
	Guitar Center, Inc. Selects Datavantage Xstore Java POS for its Guitar Center Retail Stores By Java News Desk Sophia Lo wrote: GC scrap project. to complicate for interprize