| From: | "Stefano Bonnin" <stefano(dot)bonnin(at)comai(dot)to> | 
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> | 
| Subject: | SSL Problem | 
| Date: | 2004-07-14 13:43:22 | 
| Message-ID: | 001601c469a8$87de94f0$0501a8c0@comai04 | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-jdbc | 
Hi, I have seen the same problem in the past of this list but I don't know how (and if) it has been solved.
I'm trying to connect my java stand alone application with postgres 7.4.2 via SSL.
I followed the istructions 
...
http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php
...
and then I tryed an SSL connection with pgAdmin: all works correctly
After I tryed to connect via java and the following error appear on the screen:
PostgreSQL 7.4.3 JDBC3 with SSL (build 214)
    ssl = true
    compatible = 7.4
    loglevel = 2
Using Protocol Version3
Asking server if it supports ssl
Server response was (S=Yes,N=No): S
server does support ssl
converting regular socket connection to ssl
org.postgresql.util.PSQLException
        at org.postgresql.core.PGStream.flush(PGStream.java:415)
        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(Abstrac
tJdbc1Connection.java:284)
        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJ
dbc1Connection.java:213)
        at org.postgresql.Driver.connect(Driver.java:139)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at SmitConnection.<init>(SmitConnection.java:42)
        at Config.<init>(Config.java:120)
        at ServerTask$RemindTask.run(ServerTask.java:146)
        at java.util.TimerThread.mainLoop(Timer.java:432)
        at java.util.TimerThread.run(Timer.java:382)
Exception: org.postgresql.util.PSQLException: Si Þ verificato un errore di I/O m
entre si svuotava il buffer duscita - {0}
getConnection failed: org.postgresql.util.PSQLException: Si Þ verificato un erro
re di I/O mentre si svuotava il buffer duscita - {0}
Syncroro: errore nella fase di connessione al database di sistema.
org.postgresql.util.PSQLException: Si Þ verificato un errore di I/O mentre si sv
uotava il buffer duscita - {0}
        at org.postgresql.core.PGStream.flush(PGStream.java:415)
        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(Abstrac
tJdbc1Connection.java:284)
        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJ
dbc1Connection.java:213)
        at org.postgresql.Driver.connect(Driver.java:139)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at SmitConnection.<init>(SmitConnection.java:42)
        at Config.<init>(Config.java:120)
        at ServerTask$RemindTask.run(ServerTask.java:146)
        at java.util.TimerThread.mainLoop(Timer.java:432)
        at java.util.TimerThread.run(Timer.java:382)
java.lang.NullPointerException
        at Config.<init>(Config.java:122)
        at ServerTask$RemindTask.run(ServerTask.java:146)
        at java.util.TimerThread.mainLoop(Timer.java:432)
        at java.util.TimerThread.run(Timer.java:382)
I'have no changed my java code. I have only changed the jdbc url by adding ?ssl&loglevel=2 at the end of the url.
Thanks in advance.
RedS
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-07-14 14:07:45 | Re: [Pginstaller-devel] Re: Windows port installer | 
| Previous Message | Magnus Hagander | 2004-07-14 13:30:20 | Re: [Pginstaller-devel] Re: Windows port installer |