Retrieving SQL code from a DB query

[kurent]

We do a database query:

javax.naming.InitialContext ctx = new javax.naming.InitialContext();
ds = (javax.sql.DataSource) ctx.lookup("jdbc/DB1");

// ...

con = ds.getConnection("username", "password");
con.setAutoCommit(false);
stmt = con.createStatement();

// ...

rs = stmt.executeQuery("SELECT SOMETHING FROM TABLE WHERE ...");


Now how to get the SQL code returned from the database?

[chazzy]

which sql code? the error?

[kurent]

Yes.

[chazzy]

if you catch the sqlexception, it should be in the result of getMessage

[kurent]

Oh right! So if no exception -> SQL code = 0.