Thread: Java Studio Creator
Hi
I'm having trouble connecting the Postgresql JDBC drivers to Java Studio Creator. No matter which of the Postgresql drivers, for version 8.1, that I attempt for connection I continue to get an error message "wrong driver: org.postgresql.Driver for url: localhost"
I am trying to determine where the problem is - Creator, Postgresql or me.
Has anyone else experienced difficulty in using these Postgresql/Java drivers.
Bob Pawley
On Mar 12, 2006, at 4:47 PM, Bob Pawley wrote:
> Hi
>
> I'm having trouble connecting the Postgresql JDBC drivers to Java
> Studio Creator. No matter which of the Postgresql drivers, for
> version 8.1, that I attempt for connection I continue to get an
> error message "wrong driver: org.postgresql.Driver for url: localhost"
I've never used Java Studio Creator, but based on the error message I
would guess that the JDBC URL provided is incorrect.
A format that the Postgres JDBC drivers like is:
jdbc:postgresql://host/database
for example:
jdbc:postgresql://localhost/jsc_test
This is all documented in Chapter 3 of Postgres' JDBC docs:
http://jdbc.postgresql.org/documentation/81/connect.html
eric
Bob,
The JDBC drivers work fine for me - using PostgreSQL 8.1.3 and Windows XP. From your error message, it looks like JDBC is on your classpath, which is good. The connection string can be a little finicky. There is a document on the PostgreSQL website that I found helpful in getting my connection to work. Also, there is a JDBC discussion group - it might be better to post there than on this General group.
Good luck!
Michael Schmidt