Re: [BUGS] BUG #2250: JSTL parameterized queries inserting numeric

#1

On Thu, 9 Feb 2006, Ian Moore wrote:

Quote:

The following bug has been logged online:

Bug reference: 2250
PostgreSQL version: 8.0.3
Description: JSTL parameterized queries inserting numeric values
Details:

When using the JSTL via JDBC, there is the option to write INSERT/UPDATE
statements with parameters in JSP's.
There is only two types the data parameters can be, a date or a character
varying string.
In most databases, if a character varying string is provided that contains a
numeric value, and this is used to insert/update a numeric field, the driver
will attempt a type conversion to the numeric value of the string and report
errors only if the string is not a valid . However trying this in JSTL,
which only provides support for text or date parameters results in the
following error:

ERROR: column "????" is of type integer but expression is of type character
varying

Your options are to rewrite your query like:
INSERT INTO mytable (intcol) VALUES (CAST(? AS int))

or you may use the 8.2dev driver and add ?stringtype=unspecified to your
URL.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #2250: JSTL parameterized queries inserting numeric

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #2250: JSTL parameterized queries inserting numeric - 02-10-2006 , 02:15 AM