Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

[JDBC] Bug (?) in JDB

From: Calum <caluml(at)gmail.com>
Date: Mon Jan 21 2008 - 09:00:34 EST


Hello all,

I've noticed that when using Java and postgres-jdbc, setting ssl=false in Properties doesn't get read, and ssl=false and ssl=true both cause SSL to be tried.

E.g:

 String url              = "jdbc:postgresql://"+host+"/"+database;
        Properties props = new Properties();
        props.setProperty("user",       "blah");
        props.setProperty("password",   "blah");
        props.setProperty("ssl",        "false");
        props.setProperty("sslfactory",

"org.postgresql.ssl.NonValidatingFactory");
Connection conn = null; conn = DriverManager.getConnection(url, props);

causes it to throw: org.postgresql.util.PSQLException: The server does not support SSL. (even though I've said not to try SSL).

 String url              = "jdbc:postgresql://"+host+"/"+database;
        Properties props = new Properties();
        props.setProperty("user",       "blah");
        props.setProperty("password",   "blah");
        // Don't even set these ones below, as they seem to make it
try SSL regardless.
   //     props.setProperty("ssl",        "false");
   //     props.setProperty("sslfactory",

"org.postgresql.ssl.NonValidatingFactory");
Connection conn = null; conn = DriverManager.getConnection(url, props);

works fine.

Problem exists both with postgresql-8.2-505.jdbc3.jar and postgresql-8.2-507.jdbc3.jar

C

-- 
bash# Got root? Get root. Fast Linux VPS
http://linuxvps.org/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly
Received on Mon Jan 21 17:00:28 2008

This archive was generated by hypermail 2.1.8 : Wed Jun 18 2008 - 23:43:11 EDT

Do you need help?X

Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library