Thread: problem about postgresql and jdbc

problem about postgresql and jdbc

From
"Yousry Abdallah"
Date:
Hi,
 
i have trouble using PostgreSQL7.1.3 via jdbc on my Windows XP System
(using the actual cygwin distribution and j2sdk1.4.0).
 
The Database sends following error message after connection:
 PacketReceiveFragment: read() failed: Connection reset by peer
 
The Java Program prints following stack trace:
 ---Single simple object test and transaction test
 pl.PlException: org.postgresql.util.PSQLException:
 Something unusual has occured to cause the driver to fail.
 Please report this exception: Exception: java.lang.NullPointerException
 Stack Trace:
 java.lang.NullPointerException
        at org.postgresql.Connection.openConnection(Unknown Source)
        at org.postgresql.Driver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at pl.test.PostgresqlDatabase.getNewConnection(Unknown Source)
        at pl.sql.RelationalDatabase.getConnection(RelationalDatabase.java:278)
        at pl.PersistenceManager.getConnection(PersistenceManager.java:927)
        at pl.PersistenceManager.saveObject(PersistenceManager.java:289)
        at pl.PersistentObject.save(PersistentObject.java:133)
        at pl.test.Test.performTest(Unknown Source)
        at pl.test.Test.main(Unknown Source)
End of Stack Trace
 
Thanks in advance,
Yousry

Re: problem about postgresql and jdbc

From
"Dave Cramer"
Date:
Yoursy,
 
Can you give us a small program which demonstrates this problem
 
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Yousry Abdallah
Sent: Friday, March 01, 2002 7:33 AM
To: pgsql-jdbc@postgresql.org; pgsql-cygwin@postgresql.org
Subject: [JDBC] problem about postgresql and jdbc

Hi,
 
i have trouble using PostgreSQL7.1.3 via jdbc on my Windows XP System
(using the actual cygwin distribution and j2sdk1.4.0).
 
The Database sends following error message after connection:
 PacketReceiveFragment: read() failed: Connection reset by peer
 
The Java Program prints following stack trace:
 ---Single simple object test and transaction test
 pl.PlException: org.postgresql.util.PSQLException:
 Something unusual has occured to cause the driver to fail.
 Please report this exception: Exception: java.lang.NullPointerException
 Stack Trace:
 java.lang.NullPointerException
        at org.postgresql.Connection.openConnection(Unknown Source)
        at org.postgresql.Driver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at pl.test.PostgresqlDatabase.getNewConnection(Unknown Source)
        at pl.sql.RelationalDatabase.getConnection(RelationalDatabase.java:278)
        at pl.PersistenceManager.getConnection(PersistenceManager.java:927)
        at pl.PersistenceManager.saveObject(PersistenceManager.java:289)
        at pl.PersistentObject.save(PersistentObject.java:133)
        at pl.test.Test.performTest(Unknown Source)
        at pl.test.Test.main(Unknown Source)
End of Stack Trace
 
Thanks in advance,
Yousry

Re: problem about postgresql and jdbc

From
"Yousry Abdallah"
Date:
Hi,

it was a configuration problem (something unusual ?). I forgot the database
name in the url:

jdbc:postgresql://localhost:5432/Database
                                                ----------
in Method java.sql.DriverManager.getConnection.

Thanks,

Yousry

----- Original Message -----
From: "# sriram #" <sriram@imsc.ernet.in>
To: "Yousry Abdallah" <Yousry.Abdallah@epost.de>
Sent: Tuesday, March 05, 2002 4:36 AM
Subject: Re: [JDBC] problem about postgresql and jdbc


> somewhat similar to what i experience...
> check out if  pgsql is still running when you execute the code
>
> On Fri, 1 Mar 2002, Yousry Abdallah wrote:
>
> !Date: Fri, 1 Mar 2002 13:32:43 +0100
> !From: Yousry Abdallah <Yousry.Abdallah@epost.de>
> !To: pgsql-jdbc@postgresql.org, pgsql-cygwin@postgresql.org
> !Subject: [JDBC] problem about postgresql and jdbc
> !
> !Hi,
> !
> !i have trouble using PostgreSQL7.1.3 via jdbc on my Windows XP System
> !(using the actual cygwin distribution and j2sdk1.4.0).
> !
> !The Database sends following error message after connection:
> ! PacketReceiveFragment: read() failed: Connection reset by peer
> !
> !The Java Program prints following stack trace:
> ! ---Single simple object test and transaction test
> ! pl.PlException: org.postgresql.util.PSQLException:
> ! Something unusual has occured to cause the driver to fail.
> ! Please report this exception: Exception: java.lang.NullPointerException
> ! Stack Trace:
> ! java.lang.NullPointerException
> !        at org.postgresql.Connection.openConnection(Unknown Source)
> !        at org.postgresql.Driver.connect(Unknown Source)
> !        at java.sql.DriverManager.getConnection(DriverManager.java:512)
> !        at java.sql.DriverManager.getConnection(DriverManager.java:171)
> !        at pl.test.PostgresqlDatabase.getNewConnection(Unknown Source)
> !        at
pl.sql.RelationalDatabase.getConnection(RelationalDatabase.java:278)
> !        at
pl.PersistenceManager.getConnection(PersistenceManager.java:927)
> !        at pl.PersistenceManager.saveObject(PersistenceManager.java:289)
> !        at pl.PersistentObject.save(PersistentObject.java:133)
> !        at pl.test.Test.performTest(Unknown Source)
> !        at pl.test.Test.main(Unknown Source)
> !End of Stack Trace
> !
> !Thanks in advance,
> !Yousry
> !
>
> ----------
> mAtScIeNcE
> ----------
>