Trying to figure out a way to retrieve the value passed to prepareStatement() and the parameters thereof, but I do not see an immediate way to do this within the Statement, PreparedStatement, or CallableStatement objects.
David, What are you trying to do with the values? The database driver has a way of getting them, but an application developer normally wouldn't. You are passing in the values, so you have them at some point.
David, I don't think it is possible to log at that level. The only places that I can think of to log that info:
1) When you set the string for the prepared statement 2) From a DAO wrapper for the prepared statement 3) From the callable statement itself
tumbleweed and gunslinger
Joined: Jun 29, 2001
I found a way to get what I need. We were having issues with the Microsoft SQL Server driver so I tried out the JTDS Open Source driver instead and found a CallableStatement_Base class in the driver source. By casting a regular CallableStatement (passed into my DAO), I was able to get the name of the Procedure and the parameters passed, all in a generic way.
I can post some code if anyone is interested. [ July 07, 2004: Message edited by: David Yutzy ]