You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by mule_user <sg...@aol.com> on 2008/09/30 22:23:31 UTC
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-JDK-1.5-tp19749688p19749688.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
RE: P6Spy for logging SQL with value using iBatis in JDK 1.5
Posted by Dsoares <ds...@uol.com.br>.
Hi Bryan,
I tried to configure Elvyx in Websphere 7, but I failed. I created a JDBS
Provider and a datasource that is associated with this provider. But there
isn't a field where I could put the Elvyx's url or the real_jdbc_url. I
tried to create a custom properties, however it didn't work.
Could you help me, please?
Shannon, Bryan wrote:
>
> 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: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:
> 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.
>
>
>
--
View this message in context: http://old.nabble.com/P6Spy-for-logging-SQL-with-value-using-iBatis-in-JDK-1.5-tp19749688p26389926.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
RE: P6Spy for logging SQL with value using iBatis in JDK 1.5
Posted by "Shannon, Bryan" <BS...@Tribune.com>.
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: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:
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.