tags:

views:

8

answers:

1
Q: 

P6spy doesn't spy on hsql jdbc driver

When trying to spy on the jdbc connection to a hsqldb database it doesn't work. It looks like the org.hsqldb.jdbcDriver is not deregistered.

A: 

The solution is to deregister both drivers registered by hsqldb.jar.

In spy.properties you should have

realdriver=org.hsqldb.jdbcDriver
realdriver2=org.hsqldb.jdbc.JDBCDriver
deregisterdrivers=true
raisercostin  2010-10-14 09:40:37

related questions

How do you determine if a JDBC Connection was retrieved from a JTA enabled DataSource or straight JDBC?
How can I expose a C ODBC connection to a JVM using JNI?
Error connecting to oracle. Getting an UnsatisfiedLinkError for the method t2cGetCharSet
Delete all tables in Derby DB
UNIX socket implementation for Java?
Oracle merge constants into single table
Can I connect to SQL Server using Windows Authentication from Java EE webapp?
How do I get the row count in JDBC?
Cause of No suitable driver found for...
Suggested JDBC books
Best way to validate user input JDBC?
jdbc driver for Microsoft SQL Server CE(Compact Edition) 3.5
What is the list of JConnect error-codes?
How to avoid storing passwords in the clear for tomcat's server.xml Resource definition of a DataSource?
How to avoid storing credentials to connect to Oracle with JDBC?
JDBC Database Connections in a Web App DAL
Update a backend database on software update with Java
Hibernate 3: unable to query PostgreSQL database
ResultSet not closed when connection closed?
What is the best way to encrypt a clob?
What is the best way to present data from a very large resultset?
Is it possible to store and retrieve a boolean value in a varchar field using Java JDBC?
What is the equivalent of Oracle's REF CURSOR in Postgresql when using JDBC?
How to accept REF cursor in JAVA without importing Oracle Package
MySQL Data Truncation Error