| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
| Cc: | GGattis(at)iTeamOne(dot)com, "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: JDBC Update question (quoted strings) |
| Date: | 2004-09-01 09:28:22 |
| Message-ID: | 20040901102822.B8527@bacon |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2004-09-01 12:51:49 | multiple out parameters implementation |
| Previous Message | Oliver Jowett | 2004-09-01 03:46:07 | Re: JDBC Update question (quoted strings) |