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"); /*
Beforerunning 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