|
Hello!
I'm having a problem with the JDBC
driver: I am getting the "no suitable driver" exception
when I try to log on
to the database through a simple java program.
I have postgresql 7.2.1 running in Win98, with
Cygwin. The database was downloaded
and installed through the Cygwin setup.
The JDBC driver I use is the one that comes with
Cygwin. Java is installed in
windows in d:Programming/j2sdk1.4.0
The postmaster is initiated with the
parameter -i and in case it matters I have the ipc-daemon running.
My variables are:
$ echo
$PATH
/usr/local/bin:/usr/bin:/bin:.:/home/inigo:/cygdrive/c/WINDOWS:/cygdrive/c/W
INDOWS/COMMAND:/cygdrive/d/PROGRAMMING/J2SDK1.4.0/BIN
$
echo
$CLASSPATH
/usr/share/postgresql/java/postgresql.jar:/cygdrive/d/PROGRAMMING/J2SDK1.4.0/LIB
When I try to run the program below, I get the
exception:
$ java test
org.postgresql.Driver
While connecting: No
suitable driver
I even tried to run the program, removing the
Class.forName line, giving the JDBC drivers
in command line, but the result
was the same.
Sorry for the big mail, but I'm new to Postgres, JDBC and
Cygwin, and at a loss.
Thank you all.
Here is the code of my program. (That program used
to work in Postgres when I had Linux.)
import java.sql.*;
public class test {
public static void
main(String args[]) {
try
{
Class.forName("org.postgresql.Driver");
} catch
(ClassNotFoundException e) {
System.out.println(e.getMessage());
}
try {
Connection db =
DriverManager.getConnection("jdbc:postgresql://localhost:5432/inigo", "inigo",
null);
} catch(SQLException e)
{
System.out.println("while connecting: " +
e.getMessage());
}
}
}
| 