Forums Register Login

retrieving parameter values from PreparedStatement

+Pie Number of slices to send: Send
Hello.
I would like to make a method which replaces the tipical preparedstatement clause (?) from a sql String with it's value.
This should be the method sign
public String preparedReplace (String argSql, PreparedStatement pstm)
I want to retrieve parameter values from the preparedStatement object but I don´t know how.
Is There any way of retrieving these parameter values?
The API (ParameterMetaData) doesn´t show how to do that.
Thanks in advance.
1
+Pie Number of slices to send: Send
As far as I know, there isn't a way to do this using the API. There are several frameworks that do similar things, such as p6spy or log4jdbc.

I've actually implemented a wrapper around PreparedStatement, which intercepts and stores the values of parameters being passed and can output the SQL query text with embedded literals. I haven't implemented it fully though, only those parts that are needed by my project. It doesn't support obtaining BLOB and CLOB parameters back, for example. Implementing it for the standard types isn't that hard, the hard part is to ensure it is used at all appropriate places.
+Pie Number of slices to send: Send
Thank you for the quick response.

The idea is to make a simple method, nothing too complicated.

I didn´t know that frameworks. I not going to use them at the moment but they will probably be very usefull in a near future.

Thanks.


He repaced his skull with glass. So you can see his brain. Kinda like this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 2249 times.
Similar Threads
How to invoke a java class which is not an applet from the html page?
Simple JDBC debug question
Storing special characters(') into oracle
prepared statement with "in" predicate
Inserting Apostrophes Into MySQL
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 18, 2024 21:48:14.