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 08:14:05 +0200
Message-ID: <3A0A40AD.810D4C7E@ucs.co.za> (raw)
References: <Pine.BSF.4.21.0011082342190.39636-100000@kraeusen.nbrewer.com>
Christopher,
Yep, this is the correct place to discuss bugs...
I tried the following code, and it seems to work. Is this similar to what you are
trying to do?
import java.sql.*;
public class JDBCTest {
public static void main(String[] args) throws Exception {
Class.forName("org.postgresql.Driver");
Connection conn =
DriverManager.getConnection("jdbc:postgresql://localhost/test",
"jms", "jms");
/* Before running this class, ensure that the database is created.
* CREATE DATABASE test;
* CREATE TABLE t ( aa char(1) );
*/
PreparedStatement ps =
conn.prepareStatement("insert into t values (?)");
ps.setString(1, null);
ps.executeUpdate();
}
}
Also, what version of the driver are you using - is it off CVS, the version 7.0.x
tarballs, something else?
Regards,
Grant
Christopher Farley wrote:
> Grant,
> Thanks for the -d2 tip, it will make my life a lot easier for quite
> some time!
> Actually, I already tested the 'unescaped single quote' theory, and the
> JDBC driver *does* escape them for you.
> The problem in my case seems to be that the JDBC driver is throwing the
> 'unterminated quoted string' because I am inserting a null value into a
> char(1) field. I do not have any 'not null' constraints on the field.
> I can easily work around this problem now that I understand it, but I'm
> pretty sure this is not correct behavior for the JDBC driver. Is this the
> proper forum to report bugs, if this is indeed a bug?
>
> ----
> 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: <3A0A40AD.810D4C7E@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