August 1st, 2002, 10:56 AM
Retrieving SQL from JDBC CallableStatement
Our current system is using CallableStatements (for performance) to log information to a database table. If there is an exception during this process, we want to log the SQL to a file for recovery later. Obviously, since the CallableStatement SQL statment only contains the '?' placeholders, we don't see the actual data in our logs.
Does anyone know how to retrieve the data that is inside the statement once it is put in using the set() methods? If not, does anyone know of a "drop-in" replacement that will provide access to that actual data?