From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Robert Bowen <syg6(at)yahoo(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: No suitable driver error trying to connect to |
Date: | 2004-08-06 16:10:21 |
Message-ID: | 1091808621.1548.69.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
the url is incorrect
it needs to be.
jdbc:postgresql://host:port/database
Dave
On Fri, 2004-08-06 at 08:05, Robert Bowen wrote:
> Anyone have this problem? Usually it is because of a classpath error
> but I have copied my jar file(s) into the jdeveloper/jdbc/lib
> directory (where the oracle jdbc drivers are ...) and tried the
> following:
>
> Connection Type : 3rd Party JDBC Driver
>
>
> Username and password correct (verified using pgAdmin)
>
> Driver class : org.postgresql.Driver
>
> Classpath : I have tried all 4 drivers that come with postgresql 7.5
> -- pg74.214.jdbc1.jar, jdbc2.jar, jdbc2ee.jar and jdbc3.jar.
>
> url : localhost:5432 (this works in pgAdmin)
>
> ... no dice. Any clues? My connection to Oracle 9i from jdeveloper
> works fine ... As does my pgAdmin connection to postgresql ...
>
> Many thanks!
> syg
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Dave Cramer
519 939 0336
ICQ # 14675561
From | Date | Subject | |
---|---|---|---|
Next Message | Jose Miguel Madinaveitia Ramirez | 2004-08-06 17:53:49 | Problems with big tables. |
Previous Message | Kris Jurka | 2004-08-06 16:09:33 | Re: No suitable driver error trying to connect to postgresql |