Re: JDeveloper

Kris Jurka wrote:

>On Mon, 1 Nov 2004, Ron St-Pierre wrote:
>
>
>
>>*cough* *cough* of course *ahem* and now that I've supplied the correct
>>one it's telling me
>>that the connection has been refused, and to check hostname, port.etc.
>>This isn't a new database
>>or setup, I can still access it using pgAdminIII (just tried), I ssh
>>into the server all the time, etc.
>>I also tried to specify the port after the url (192.x.x.x:5432) but then
>>it complains that I don't
>>have a suitable driver. Any ideas?
>>
>>
>>
>
>Again I'm unsure of the URL you gave, but it should look like
>jdbc:postgresql://db.mycompany.com:port/database
>
Yes, that worked!

>
>Are you using pgadmin from your desktop or the server? If you are using
>it from the same machine as jdeveloper then the connection should look the
>same to postgresql and should work.
>
To connect from pgAdmin I simply use the ip address 192.x.x.x and the
port, without specifying the
jdbc:postgresql:: prefix or the database name.

>If you are using it from the server
>then you may be connecting over unix sockets instead of tcpip sockets
>which is a different situation. Double check the URL, the tcpip_socket
>flag in postgresql.conf, and your pg_hba.conf settings.
>
>Kris Jurka
>
Many thanks Kris, you've saved me from more frustration!

Ron