Re: JDBC Update question (quoted strings) - Mailing list pgsql-jdbc

From Paul Thomas
Subject Re: JDBC Update question (quoted strings)
Date
Msg-id 20040901102822.B8527@bacon
Whole thread Raw
In response to JDBC Update question (quoted strings)  (Gerry Gattis <GGattis@iTeamOne.com>)
List pgsql-jdbc
On 01/09/2004 04:46 Oliver Jowett wrote:
> Gerry Gattis wrote:
>> Hi Oliver,
>>
>> Thanks for the response.  David pointed out that I was using the wrong
>> call to create the statement.  After I corrected that, the driver works
>> fine.  I think that it must be treating strings differently if it thinks
>> that it is talking to a stored procedure.  That would make sense.
>>
>> Methinks the bug is me!
>
> Hmm.. but prepareCall should behave the same as prepareStatement for
> simple queries, in theory. It should only behave differently if it sees
> a {call} escape sequence..
>
> Odd.


Could it be anything to do with him using stmt.execute() instead of the
more usual stmt.executeUpdate()?

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business             |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: JDBC Update question (quoted strings)
Next
From: Dave Cramer
Date:
Subject: multiple out parameters implementation