db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: are prepareCall and prepareStatement interchangeable when calling derby system procedures?
Date Sat, 26 May 2007 16:09:06 GMT
Knut Anders Hatlen wrote:
> Mike Matrigali <mikem_app@sbcglobal.net> writes:
> 
>> I see both use of prepareCall and prepareStatement in the tests.
>> Are both right?  If not is it surprising that the tests pass?
> 
> I think you only need prepareCall if the procedure has out parameters,
> since CallableStatement has methods to retrieve parameter values whereas
> PreparedStatement doesn't. If it doesn't have out parameters, you can
> use either of them.

That's correct, I seem to recall some discussion that maybe at some 
point JDBC specification may require use of CallableStatement for a 
procedure call, but that's not true at the moment.

Dan.

Mime
View raw message