Discovering SQL from a ResultSet

Question

Discovering SQL from a ResultSet

Navigation

#1 by (2 votes)
#2 by (2 votes)
#3 by (0 votes)

3

I have a java ResultSet object that does not know the SQL / Parameters that generated it. I would like to know how do I get the SQL used to create it? would have something like:

  rs.getStm.getSql

?

sql java resultset

asked by anonymous 21.07.2015 / 22:11

3 answers

Block upload of .gif images renamed with .jpg or .png in PHP Eclipse future for Android development [closed]

score 2 · Answer 1

2

You should get the SQL from java.sql.PreparedStatement:

System.out.println(ps);

Just call the PrepareStatement toString.

21.07.2015 / 22:17

score 2 · Answer 2

I'm writing this by relying on this javadoc .

By javadoc, class FirebirdResultSet inherits from ResultSet of library java.sql .

The class ResultSet has method getStatement() that returns an object Statement ; then you can follow the user's response @Afonso , and call the toString method of the Statement class.

score 0 · Answer 3

Only complementing Mr. Afonso. With Postgre it works too. Only use the toString () method with the PreparedStatement.

preparedStatement = conection.prepareStatement("SELECT * FROM usuario");
System.out.println(preparedStatement.toString());

Console:

SELECT * FROM usuario

With Common Statement does not work because sql is inserted directly with the executeQuery method.