Thread: postgreSQL driver installation on Oracle9i Application Server

I have a servlet running on Oracle9i Application Server on a solaris
box. This servlet accesses a postgreSQL database on another machine. I
installed the postgreSQL jdbc driver on the machine  hosting the
application server and specified its location in the classpath.

When I try to run the servlet from the web, I get this error:

Connect Err: java.lang.ClassNotFoundException: org.postgresql.Driver
Driver
  Loaded: Making Connection Connect Err: java.sql.SQLException: No
  suitable driver

Wondering if anybody has experience with Oracle9iAS configuration before
and could enlighten me on what I am missing.

Thanks,
Anandhi

> 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