Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
java.sql.PreparedStatement
- Thread starter Hattusas
- Start date
I don't think you can.
The point of a PreparedStatement is that the PreparedStatement and parameters are sent to the SQL server separately, where they're compiled into the actual SQL statement to use. That way, reusing the same PreparedStatement speeds up the execution time of the SQL statement, because it's already been compiled. The SQL server only needs to plug the new parameters in.
So I don't think the client is actually aware of the final form of the SQL statement.
The best you could do is a toString() on the PreparedStatement.
The point of a PreparedStatement is that the PreparedStatement and parameters are sent to the SQL server separately, where they're compiled into the actual SQL statement to use. That way, reusing the same PreparedStatement speeds up the execution time of the SQL statement, because it's already been compiled. The SQL server only needs to plug the new parameters in.
So I don't think the client is actually aware of the final form of the SQL statement.
The best you could do is a toString() on the PreparedStatement.
- Status