PDA

View Full Version : trying to connect to postgres database



lconklin
03-11-2009, 04:46 PM
My url I am using is
jdbc:postgresql://localhost:5432/dm_JobCosting

The error I am getting is
exception: java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/dm_JobCosting

I added to my classpath in windows where the driver is
.;C:\Program Files\PostgreSQL\8.1\jdbc\postgresql-8.1-410.jdbc3.jar

I have also changed the weka.ini file to be
cp=%CLASSPATH%;C:/Program Files/PostgreSQL/8.1/jdbc

none of this has helped :confused:

Mark
03-11-2009, 05:32 PM
Hi,

You might need to watch spaces in your classpath entries. Try enclosing the entry for the jdbc jar in double quotes. Another thing to look at is the System Info (select "SystemInfo" from the "Help" menu in Weka) - see what is recorded for the java.class.path property.

Cheers,
Mark.

tdidomenico
03-13-2009, 12:55 PM
If the double quoting Mark suggested does not help, maybe something in this thread can:

http://forums.pentaho.org/showthread.php?t=66622 (http://forums.pentaho.org/showthread.php?t=66622&highlight=weka+oracle)

It was written for Oracle, but it should be easy to adapt it to Postgres.

Cheers!