[Opensource] Upgrading from 4.02 to 5.02: DBObject ... quoting issue

[Vincent Gogan]

I haven't gotten this problem to a nice test case yet but I thought I'ld see
if this is a known issue or a bug to hunt down. I have a DBObject with a
VARCHAR and a TEXT field. An update fails when I have a single single
quote in the VARCHAR field.

The errors I get are:

	* JDBCExecutor.update. - Error executing LOB set Character Stream
	Parameter index out of range

	followed by

	* JDBCExecutor.delete with no other messages.

This only happens when the VARCHAR field has the single quote. Everything
works
fine if there are no (or two) single quotes in the same field. It doesn't
seem
to matter what is in the TEXT field.

I use postgres733/JDK 1.4.0_04 and just upgraded the JDBC driver with no
change in behaviour.

An interesting point is that neither of these field values are being changed
in the
update that is taking place. There is another INT field that is actually
being updated.


Vincent

P.S. This code worked in 4.02