aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes connecting to a remote PostgreSQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "connecting to a remote PostgreSQL" Watch "connecting to a remote PostgreSQL" New topic
Author

connecting to a remote PostgreSQL

evan theon
Ranch Hand

Joined: Feb 16, 2005
Posts: 39
i'm designing an enterprise application using an EJB module and an EJB Client, i'm using SJSAS as my application server and POstgreSQL as my DBMS, and netbeans 1.4 as my tool. i'm having trouble connecting to the remote DB server (PostgreSQL). is there anyone here have experience in using netbeans and come up with the same issue with me? if there is, i will continue my posting

thanks for everyone
Annie Smith
Ranch Hand

Joined: Mar 05, 2005
Posts: 172
It would be appropriate if you post the error message you are receiving while connecting. A possible reason might be the connection parameters you have provided in the datasource configuration. Did you test the connectivity between the database machine and app server machine?

I presume you are configuring a datasource. Though I have mostly used WebLogic, IMO there should be a utility in your app server to test if the datasource you have configured is correct.

Post some more information please.


Cheers!<br /><b>Annie</b>
evan theon
Ranch Hand

Joined: Feb 16, 2005
Posts: 39
i'm receiving this as the error message :



Caught a remote exception: RemoteException occurred in server thread; nested exception is:

java.rmi.RemoteException: Unable to Connect.Error in allocating a connection. Cause: org.postgresql.Driver

>Did you test the connectivity between the database machine and app server machine? -> where can i start doing this? by ping? i already ping between the DB machine and the App server machine and it is connected. or is there something else i need to do? in addition, the DB machine is red hat linux and the app server is win2000.

yes i'm building a datasource for my purpose. for additional information, if we use netbeans IDE 4.1, there is a window in which we can configure a connection and connect directly to a database, and i have configure it from that window and i can see the tables,records,etc from the database as the result. i can assume that as a succesful connection, can't i?

by the way i really like the way your guiding me with your posting, it's enlighting i can see your point clearly. i really need this since i'm a newbie. thanks a lot
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: connecting to a remote PostgreSQL