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