This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connecting to a remote PostgreSQL

 
evan theon
Ranch Hand
Posts: 39
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 172
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
evan theon
Ranch Hand
Posts: 39
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic