Thread: Getting started with jdbc3 and eclipse

Getting started with jdbc3 and eclipse

From
"Dominik Heller"
Date:
Hi All,
I am about to get started with postgresql 8.2 and eclipse. the installation of the postgres DB was successful and now
myproblem is how to find the driver in eclipse. I have set the classpath correctly and I also added the library to the
eclipseproject (although I know the is not even neccessary). 

So now by trying to establish a connection with the following code:

Class.forName("org.postgresql.Driver");
            db = DriverManager.getConnection("localhost:5432", "postgres", "*****");

I get this exception:

java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getConnection(DriverManager.java:545)
    at java.sql.DriverManager.getConnection(DriverManager.java:171)
    at com.seitenbau.test.testDB.<init>(testDB.java:12)
    at com.seitenbau.test.App.main(App.java:14)


So I am using jdk 1.5_12 and the postgresql-8.2-506.jdbc3.jar

Does someone has any idea? THX in advance

-Dominik
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

Re: Getting started with jdbc3 and eclipse

From
Guillaume Cottenceau
Date:
"Dominik Heller" <Dominik.Heller 'at' gmx.net> writes:

> Hi All,
> I am about to get started with postgresql 8.2 and eclipse. the installation of the postgres DB was successful and now
myproblem is how to find the driver in eclipse. I have set the classpath correctly and I also added the library to the
eclipseproject (although I know the is not even neccessary). 
>
> So now by trying to establish a connection with the following code:
>
> Class.forName("org.postgresql.Driver");
>             db = DriverManager.getConnection("localhost:5432", "postgres", "*****");
>
> I get this exception:
>
> java.sql.SQLException: No suitable driver

http://www.google.com/search?q=jdbc+postgresql+No+suitable+driver

--
Guillaume Cottenceau, MNC Mobile News Channel SA, an Alcatel-Lucent Company
Av. de la Gare 10, 1003 Lausanne, Switzerland - direct +41 21 317 50 36

Re: Getting started with jdbc3 and eclipse

From
Michael Schmidt
Date:
Dominik Heller wrote:
> Hi All,
> I am about to get started with postgresql 8.2 and eclipse. the installation of the postgres DB was successful and now
myproblem is how to find the driver in eclipse. I have set the classpath correctly and I also added the library to the
eclipseproject (although I know the is not even neccessary). 
>
> So now by trying to establish a connection with the following code:
>
> Class.forName("org.postgresql.Driver");
>             db = DriverManager.getConnection("localhost:5432", "postgres", "*****");
>
> I get this exception:
>
> java.sql.SQLException: No suitable driver
>     at java.sql.DriverManager.getConnection(DriverManager.java:545)
>     at java.sql.DriverManager.getConnection(DriverManager.java:171)
>     at com.seitenbau.test.testDB.<init>(testDB.java:12)
>     at com.seitenbau.test.App.main(App.java:14)
>
>
> So I am using jdk 1.5_12 and the postgresql-8.2-506.jdbc3.jar
>
> Does someone has any idea? THX in advance
>
> -Dominik

The Komo project is an Eclipse application that can be used as a
foundation for a PostgreSQL interface.  It uses dynamic loading of the
jdbc driver and has a connection manager class that handles the database
connection.  You can download it at pgFoundry and look at the source code.

Michael Schmidt

Re: Getting started with jdbc3 and eclipse

From
Guy Rouillier
Date:
Dominik Heller wrote:
> java.sql.SQLException: No suitable driver

Add the PG jar file as an external JAR file to your project.

--
Guy Rouillier