SQL Server JDBC - getting SQL query from Statement

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

getting SQL query from Statement

MrNobody

2005-04-14, 8:23 pm

Is there any way to get a SQL query using Microsoft's implementation of JDBC
interfaces/classes?

I know using Oracle, I can type cast a Statement into an OracleStatement and
it has a new method which returns the SQL query associated with that
Statement object

Any way to do this with SQL Server classes?

Alin Sinpalean

2005-04-16, 3:23 am

There isn't any and even if there were I would not recommend using it.
It will make your code dependent on the particular driver/DBMS
combination. If you really-really need to debug something use P6Spy,
but not in a production environment.

Alin,
The jTDS Project.

Sponsored Links