ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shannon, Bryan" <BShan...@Tribune.com>
Subject RE: P6Spy for logging SQL with value using iBatis in JDK 1.5
Date Thu, 02 Oct 2008 14:18:39 GMT
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

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:sgho@aol.com] 
Sent: Tuesday, September 30, 2008 4:24 PM
To: user-java@ibatis.apache.org
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:
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

View raw message