| From: | Christopher Farley <chris(at)northernbrewer(dot)com> | 
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org | 
| Subject: | JDBC 'Unterminated quoted string' | 
| Date: | 2000-11-08 19:30:45 | 
| Message-ID: | Pine.BSF.4.21.0011081318270.35907-100000@kraeusen.nbrewer.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-interfaces | 
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grant Finnemore | 2000-11-09 04:54:49 | Re: JDBC 'Unterminated quoted string' | 
| Previous Message | Dadure Arnaud | 2000-11-08 16:07:45 | PostgreSQL + JDBC |