Message-ID: <3A0A40AD.810D4C7E@ucs.co.za>
Date: Thu, 09 Nov 2000 08:14:05 +0200
From: Grant Finnemore <gaf@ucs.co.za>
MIME-Version: 1.0
To: Christopher Farley <chris@northernbrewer.com>
CC: pgsql-interfaces@postgresql.org
Subject: Re: JDBC 'Unterminated quoted string'
References: <Pine.BSF.4.21.0011082342190.39636-100000@kraeusen.nbrewer.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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