I have used P6Spy with iBatis quite successfully... Just follow along with the documentation.
Also, try a great program I found out there called "Elvyx" that will also let you record your sql statements (with and without placeholders). These products both work by WRAPPING your existing jdbc driver (no matter which it is) and recording metrics about the call before passing the actual jdbc call to your own driver. I've had both of these wrap up Sybase's jconnect, jTds, and mysql's jdbc drivers with no problem. You configure each with what your actual jdbc url and options are, then in your own java code, you set up your jdbc url to be the p6spy or elvyx driver. Elvyx is very helpful, as it stores your historical metrics in an in-memory database (which you can query to get your own statistics) and it has a nice front end that has a pie chart to show you up-front which queries are taking the longest time to execute. Either of these programs will do what you want, and either proxy driver will most likely be able to be set up with Websphere's JNDI with no problem. (p6spy uses a config file that might be tricky, it has to be somewhere in Webshere's classpath) and Elvyx uses encoded parameters sent to it's own jdbc url to determine how it should set up your own (real) jdbc driver. I'd recommend either of these to any iBatis or even Hibernate or straight jdbc users. (Comes in especially handy when you're trying to get performance metrics for certain queries, etc.) -----Original Message----- From: mule_user [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 4:24 PM To: [email protected] Subject: P6Spy for logging SQL with value using iBatis in JDK 1.5 I have following questions on using P6Spy for logging SQL (along with the values passed in the prepared statement) using iBatis in JDK 1.5. 1. Has anybody used P6Spy in WebSphere 6.1 (JDK 1.5)? 2. Does P6Spy require you to use its own database driver, and replace the standard database driver (DB2Java.zip for DB2) with P6Spy driver instead? If so, I will require to replace my DB2Java.zip (DB2 driver) with P6Spy.jar instead. Is that true? 3. Is there any other alternative for logging SQL (along with its values) in JDK 1.5 using iBatis? For example, I want to see SQL like: select co1 from table1 where is=11 -- I want to see the value of 11, along with SQL. I was thinking that P6Spy would solve it. However, if I am required to use P6Spy driver (and cannot use DB2 driver), I may be hesitant to using P6Spy option. Any suggestion? -- View this message in context: http://www.nabble.com/P6Spy-for-logging-SQL-with-value-using-iBatis-in-J DK-1.5-tp19749688p19749688.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
