Re: JDBC 'Unterminated quoted string'

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(at)ucs(dot)co(dot)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