Re: JDeveloper

Apologies in advance if this isn't quite the correct forum to post this
question in. but I thought it might be more appropriate than a posting
to general. I am evaluating Oracles JDeveloper 10g and want to use
postgres as the database but it doesn't want to work. Google results
show that it is possible but I haven't found the details on how to
configure it.

database - postgresql 7.4.2 on debian
java ide - jdeveloper 10g on windows 2000

In jdeveloper I'm trying to create a new database connection
-> Connection Type: Third Party JDBC Driver
-> username: postgres pasword: mypassword
-> Driver Class: org.postgresql.Driver
-> Classpath: c:\pg74.215.jdbc2.jar
-> Source Path: c:\pg74.215.jdbc2.jar
and then I run Test Connection:
java.lang.NullPointerException

Of course any help or insight is gratefully accepted.

Thanks
Ron

On Mon, 1 Nov 2004, Ron St-Pierre wrote:
> In jdeveloper I'm trying to create a new database connection
> -> Connection Type: Third Party JDBC Driver
> -> username: postgres pasword: mypassword
> -> Driver Class: org.postgresql.Driver
> -> Classpath: c:\pg74.215.jdbc2.jar
> -> Source Path: c:\pg74.215.jdbc2.jar
> and then I run Test Connection:
> java.lang.NullPointerException

Do you have the stacktrace in addition to the message?

Did you give it a postgresql URL ?

Kris Jurka

Kris Jurka wrote:

>On Mon, 1 Nov 2004, Ron St-Pierre wrote:
>
>
>>In jdeveloper I'm trying to create a new database connection
>>-> Connection Type: Third Party JDBC Driver
>>-> username: postgres pasword: mypassword
>>-> Driver Class: org.postgresql.Driver
>>-> Classpath: c:\pg74.215.jdbc2.jar
>>-> Source Path: c:\pg74.215.jdbc2.jar
>>and then I run Test Connection:
>> java.lang.NullPointerException
>>
>>
>
>Do you have the stacktrace in addition to the message?
>
>Did you give it a postgresql URL ?
>
>
*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?

Thanks
Ron

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

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. 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

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