This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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
 
Don't get me started about those stupid light bulbs.
 
subject: connecting to a remote PostgreSQL