Re: Connect via odbc from Windows to Linux

--- On Mon, 12/1/08, Oliver Jowett <oliver(at)opencloud(dot)com> wrote:

> Bruce Hyatt wrote:
> > --- On Mon, 12/1/08, Oliver Jowett
> <oliver(at)opencloud(dot)com> wrote:
> >
> >> Bruce Hyatt wrote:
> >>
> >>> This is what I tried initially and it returns:
> >>> SQL Error: java.sql.SQLException: No suitable
> driver
> >> found for jdbc:postgresql://host/database 0 08001
> >>
> >> Have you followed the instructions here?
> >>
> >>
> http://jdbc.postgresql.org/documentation/head/load.html
> >>
> >> -O
> >
> > I had commented out that line because the Java SE 6
> API documentation for class DriverManager says it's no
> longer necessary but when I add it back in I get:
>
> You commented out what line?
>
> > Error: java.lang.ClassNotFoundException:
> org.postgresql.Driverorg.postgresql.Driver
>
> You have the wrong classname.

I had commented out:

Class.forName("org.postgresql.Driver");

I see that the classname is wrong. It seems the application is appending the classname to itself for some reason. The application is simple - only 27 lines total and three lines apply to the connection. The relevant lines are:

String data = "jdbc:postgresql://192.168.1.199/platingshop";
// I tried hostname/... and hostname.domain/platingshop too
try {
// call to Class.forName no longer necessary
Class.forName("org.postgresql.Driver");
Connection conn = DriverManager.getConnection(
data, "", "");

Bruce Hyatt