From: Grant Finnemore <gaf@ucs.co.za>
To: Christopher Farley <chris@northernbrewer.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: JDBC 'Unterminated quoted string'
Date: Thu, 09 Nov 2000 06:54:49 +0200
Message-ID: <3A0A2E19.281C7CB3@ucs.co.za> (raw)
References: <Pine.BSF.4.21.0011081318270.35907-100000@kraeusen.nbrewer.com>
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@ucs.co.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: gaf@ucs.co.za, chris@northernbrewer.com
Subject: Re: JDBC 'Unterminated quoted string'
In-Reply-To: <3A0A2E19.281C7CB3@ucs.co.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox