Re: postgreSQL driver installation on Oracle9i Application Server - Mailing list pgsql-jdbc

From David Wall
Subject Re: postgreSQL driver installation on Oracle9i Application Server
Date
Msg-id 005801c24ea7$52ea7fc0$3201a8c0@expertrade.com
Whole thread Raw
In response to postgreSQL driver installation on Oracle9i Application Server  (Anandhi Narayanaswamy <a_narayanaswamy@fccc.edu>)
List pgsql-jdbc
> I have a servlet running on Oracle9i Application Server on a solaris
> box. This servlet accesses a postgreSQL database on another machine.

I hope Ellison doesn't read your scenario.  I'm sure he didn't ever expect
anybody to use an Oracle app server with anything but an Oracle db.  Sorry I
can't help on this one in particular.  But some possibilities...

For webapps, you generally don't put the postgresql.jar in the classpath,
but instead put it in the WEB-INF/lib of the webapp and it will be added
automatically.  Next, are you configuring the correct URL/userid/password to
reach the actual database on the other system (if you have psql installed,
you could try to ensure that you can open the database from the other
computer)?  Did you start postgresql with the '-i' flag to ensure it has a
TCP socket?  Is your pg_hba.conf configured to allow access from the other
host?  Access is best proven by using psql on the webapp server to ensure it
can use the database on the other...

David


pgsql-jdbc by date:

Previous
From: "David Wall"
Date:
Subject: Re: setBlob loop performance?
Next
From: Jean-Luc Lachance
Date:
Subject: Re: jdbc & tomcat