Re: Another java connect problem

Why do you use 'Class.forName("org.postgresql.Driver").newInstance();'? Just
use 'Class.forName("org.postgresql.Driver");'
Oh, by the way, it's probably something you forgot in your e-mail, but
DriverManager.getConnection(url, "user", "password);
is not correct, it has to be:
DriverManager.getConnection(url, "user", "password");
That's the way it works for me...

Nico.

""Espen Isaksen"" <espen(dot)isaksen(at)statkart(dot)no> schreef in bericht
news:425121BB(dot)8020603(at)statkart(dot)no(dot)(dot)(dot)
> Hi!
>
> I have studied all the different questions where people have trouble
> connecting to PostgreSQL through Java, but it doesn't help me
> much. This is a program I first compiled on a Mac and I have no
> problems at all there. Now I am on Fedora Linux.
>
> First my code:
> Connection dbcon;
> java.sql.Connection conn;
> String url = "jdbc:postgresql://localhost:5432/espen";
> try {
> Class.forName("org.postgresql.Driver").newInstance();
> }
> catch( ClassNotFoundException cnfex ) {
> System.out.println("Class not found!");
> } //end catch
> conn = DriverManager.getConnection(url, "user", "password);
> Statement stmt = conn.createStatement();
> s = conn.createStatement();
>
>
> I compile by using this command:
> javac @files -classpath postgis.jar:postgresql.jar (where files include a
> list of all the .java files)
>
> No problems compiling.
>
> I try to run by:
> java road_generalization -verbose -classpath postgis.jar:postgresql.jar
>
> Then I get the usual error message:
>
> Unable to connect
> java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getConnection(Unknown Source)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at DataUthenter.connectPostgres(DataUthenter.java:67)
> at DataUthenter.<init>(DataUthenter.java:31)
> at road_generalization.<init>(road_generalization.java:99)
> at road_generalization.main(road_generalization.java:383)
>
> I have tried to change the code in a lot of different ways, but it does
> not
> seem to help much. Can anybody give me some insight in why this
> doesn't work. Is my "run command" not correct?
>
> Espen Isaksen
> http://www.espenisaksen.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>