Getting started with jdbc3 and eclipse

[Dominik Heller]

Hi All,
I am about to get started with postgresql 8.2 and eclipse. the installation of the postgres DB was successful and now my problem is how to find the driver in eclipse. I have set the classpath correctly and I also added the library to the eclipse project (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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Guillaume Cottenceau]

"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 my problem is how to find the driver in eclipse. I have set the classpath correctly and I also added the library to the eclipse project (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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

[Michael Schmidt]

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 my problem is how to find the driver in eclipse. I have set the classpath correctly and I also added the library to the eclipse project (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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Guy Rouillier]

Dominik Heller wrote:
> java.sql.SQLException: No suitable driver

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

--
Guy Rouillier

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate