Re: postgreSQL driver installation on Oracle9i Application Server

Поиск
Список
Период
Сортировка
От David Wall
Тема Re: postgreSQL driver installation on Oracle9i Application Server
Дата
Msg-id 005801c24ea7$52ea7fc0$3201a8c0@expertrade.com
обсуждение исходный текст
Ответ на postgreSQL driver installation on Oracle9i Application Server  (Anandhi Narayanaswamy <a_narayanaswamy@fccc.edu>)
Список 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 по дате отправления:

Предыдущее
От: "David Wall"
Дата:
Сообщение: Re: setBlob loop performance?
Следующее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: jdbc & tomcat