From: | Bruce Hyatt <brucejhyatt(at)yahoo(dot)com> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org, John R Pierce <pierce(at)hogranch(dot)com> |
Subject: | Re: Connect via odbc from Windows to Linux |
Date: | 2008-12-02 02:40:37 |
Message-ID: | 264210.40241.qm@web34405.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
--- 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Hyatt | 2008-12-02 02:49:09 | Re: Connect via odbc from Windows to Linux |
Previous Message | Oliver Jowett | 2008-12-02 02:03:11 | Re: Connect via odbc from Windows to Linux |