Re: postgreSQL driver installation on Oracle9i Application Server

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: "Anandhi Narayanaswamy" <a_narayanaswamy(at)fccc(dot)edu>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: postgreSQL driver installation on Oracle9i Application Server
Date: 2002-08-28 15:26:47
Message-ID: 005801c24ea7$52ea7fc0$3201a8c0@expertrade.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jean-Luc Lachance 2002-08-28 15:35:15 Re: jdbc & tomcat
Previous Message David Wall 2002-08-28 15:19:42 Re: setBlob loop performance?