Ta ppls.
I agree with the fact that PreparedStatements are cleaner to use. It's the way I've always done it.
So, to put the original question in a context:
I've written a framework that allows you to extract the common db operations and only requires you to implement the sql data specific to the current query.
eg
(I realise there are some problems above but
you should be able to get the picture)
Here's the next question:
So, if PreparedStatements are reusable can I create a PreparedStatement once and cache it for successive queries that would set the parameters themselves?
I believe that this would have to be done via some extension to ConnectionPooling cos you'd be managing resources at a lower level, but is it possible?
Dave.