Обсуждение: 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