RE: JDBC 'Unterminated quoted string' - Mailing list pgsql-interfaces

From Peter Mount
Subject RE: JDBC 'Unterminated quoted string'
Date
Msg-id 1B3D5E532D18D311861A00600865478CF1B50A@exchange1.nt.maidstone.gov.uk
Whole thread Raw
In response to JDBC 'Unterminated quoted string'  (Christopher Farley <chris@northernbrewer.com>)
List pgsql-interfaces
Hmmm, there may be. I'll check shortly...

-- 
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council


-----Original Message-----
From: Christopher Farley [mailto:chris@northernbrewer.com]
Sent: Wednesday, November 08, 2000 7:31 PM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] JDBC 'Unterminated quoted string'


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


pgsql-interfaces by date:

Previous
From: Dave Page
Date:
Subject: RE: Access 2000 and empty fields
Next
From: Phil Davey
Date:
Subject: RE: Access 2000 and empty fields