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:s...@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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
