Re: Another java connect problem - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Another java connect problem
Date
Msg-id 42527FE4.70902@fastcrypt.com
Whole thread Raw
In response to Another java connect problem  ("Espen Isaksen" <espen.isaksen@statkart.no>)
Responses Re: Another java connect problem
Re: Another java connect problem
List pgsql-jdbc
Hi,

What is the postgis.jar doing? Does it still implement it's own version
of the jdbc driver ?

the newinstance thing doesn't matter it will still work that way.

Try it without the postgis.jar, it may be loading its version of the driver.

Dave

Espen Isaksen wrote:

> 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
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561


pgsql-jdbc by date:

Previous
From: "Benjamin W. Fisher"
Date:
Subject: Re: JBuilder Question [SOLVED]
Next
From: Espen Isaksen
Date:
Subject: Re: Another java connect problem