Re: JDBC Update question (quoted strings)

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   |
+------------------------------+---------------------------------------------+