[Squirrel-sql-develop] How to get more detail on query execution errors

[pchambre <pau...@il...>]

Hello,

We are working on a JDBC driver for a proprietary database.

>From a Java test app, I can connect and run executeQuery to pass a native
(not SQL) query to the database and get an iterable ResultSet.

>From SQL Squirrel, I was initially not able to connect. After implementing a
number of metadata methods that we weren't originally supporting, I can now
connect, and I can submit a query, but the result is:

Error: No current result
SQLState:  null
ErrorCode: 0

The result set is pretty simple - one String and two double columns with ten
rows. String (12) and double (8) are both data types that are returned from
the JDBC driver's getTypeInfo() call.

I see no details in STDOUT, .squirell-sql logs, or the logs generated by my
JDBC driver or database. The database end of things has very detailed logs,
and the query appears to have executed successfully. I am thinking that SQL
Squirrel is not finding something that it expects when attempting to
retrieve or render the ResultSet, but I do not know how to get more detail
about what's happening behind the scenes.

Any suggestions on how to log more detail about what SQL Squirrel is doing
here?

Thanks,
Paul



--
Sent from: http://squirrel-sql-client.10976.n7.nabble.com/Developer-f2439.html