Re: JDBC 'Unterminated quoted string'

Christopher,

I would suggest that you examine the query that arrives at the backend.
(Start the postmaster with the -d2 switch)

This should at least give you the source of the unterminated string, and
presumably, we can then trace it through the execution of the JDBC driver.

Offhand, I would suggest that one of the string fields in the insert has a '
character inside. AFAIK the postgresql jdbc driver does not automatically
escape this character. The correct escape would be ''.

Regards,
Grant

Christopher Farley wrote:

> I am migrating a Java application from a commercial RDBMS to
> Postgresql. The transition has been near-seamless, except I am getting a
> troublesome SQLException when executing one of my PreparedStatement
> objects.
>
> The SQLException is 'Unterminated quoted string', and it occurs on a
> simple SQL insert statement. I have other insert statements which execute
> flawlessly, and this particular statement worked fine on a different
> database.
>
> I searched the archives and the only information I could find on this
> error had to do with quoting question-mark (?) literals with ODBC. Since
> the JDBC PreparedStatement uses ?, I was wondering if there was a problem
> parsing the PreparedStatement. The only thing that distinguishes the
> problematic PreparedStatement is that I am inserting a large number of
> columns (21).
>
> I'm using the jdbc7.0-1.1.jar, and running Posgresql 7.0.2.
>
> Thanks if you can help!
> ----
> Christopher Farley
> Northern Brewer / 1150 Grand Avenue / St. Paul, MN 55105
> www.northernbrewer.com

--
> Poorly planned software requires a genius to write it
> and a hero to use it.

Grant Finnemore BSc(Eng) (mailto:gaf(at)ucs(dot)co(dot)za)
Software Engineer Universal Computer Services
Tel (+27)(11)712-1366 PO Box 31266 Braamfontein 2017, South Africa
Cell (+27)(82)604-5536 20th Floor, 209 Smit St., Braamfontein
Fax (+27)(11)339-3421 Johannesburg, South Africa