Re: No suitable driver found exception

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Amanda K(dot) Martino" <amartino(at)mitre(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: No suitable driver found exception
Date: 2002-01-31 21:04:19
Message-ID: NEBBLAAHGLEEPCGOBHDGMEHEEEAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

This error usually means that the connection URL is not right. Try putting a
debug line into your code that prints the database URL just before it gets
used in the Store method. It should match one of these three forms:

jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

-Nick

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Amanda K. Martino
> Sent: Thursday, January 31, 2002 2:41 PM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC] No suitable driver found exception
>
>
> Hello,
>
> I have a simple java class (myTest.java) that I'm trying to run. This
> class uploads an RDFS schema into a postgresql database using three
> methods: setAuthentication, which specifies the username and password
> used to gain access to the database, setDBFunctionsPath, which specifies
> the library containing the functions to actually store the RDF, and
> store, which takes as parameters the URL of the RDF schema to be loaded
> into the database, and the URL of the database into which the schema
> will be loaded. When I try to run the class, I'm getting the following
> exception:
> SQLException: No suitable driver
> java.sql.SQLException: No suitable driver.
>
> I have the postgresql.jar file in my classpath, as well the
> jdbc7.1-1.2.jar which I downloaded from the postgresql.org's jdbc site.
> I'm using Postgresql v7.1.3 and JDBC v2.0. I'd appreciate any
> suggestions to resolve this issue that anyone has.
>
> Thank you very much,
> Amanda Martino
> amartino(at)mitre(dot)org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Arsalan Zaidi 2002-02-01 06:14:18 Strange JDBC error mesg
Previous Message Dave Cramer 2002-01-31 19:50:35 Re: No suitable driver found exception