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:
jdbcostgresql://host/database

for example:
jdbcostgresql://localhost/jsc_test

This is all documented in Chapter 3 of Postgres' JDBC docs:
http://jdbc.postgresql.org/documenta...1/connect.html

eric

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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