Problem linking Postgresql JDBC driverb and Matlab (Linux)

From: Tuan Nguyen <tuanito(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem linking Postgresql JDBC driverb and Matlab (Linux)
Date: 2004-09-22 17:12:58
Message-ID: 56afade704092210123df4ee7f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I know this subject has also to do with Matlab, but I do not get any
answer on the Matlab forum, so I allow myself to crosspost my question
here. The Matlab error messages give however a lot of indications that
may be relevant to readers of this newsgroup.

I am still having some problems trying to connect Postgresql via the
JDBC driver and Matlab. I believe that Matlab does not know where the
driver is.

I am just wondering if I am using the right driver for my version of
Java and I am wondering whether my export CLASSPATH has the good
syntax. Can somebody help me as it is driving me nuts (I've been
working on this for a quite a few days) ?

I am also wondering why it requires the SSL module (cf below). It
seems that this function is supported by Java 1.4 only, and my Matlab
runs on Java 1.3.1. Shall I change the Java version of Matlab (and in
that case, how can I do it ?).

Thanks.

Configuration :
Slackware 9.1 - Matlab 6.5 R13 - Java 1.4.2_03, but Matlab runs on
1.3.1 Blackdown

EDU>> version -java

ans =

Java 1.3.1 with Blackdown Java-Linux Team Java HotSpot(TM) Server VM
(mixed mode)

I tried drivers pg74.215.jdbc2ee.jar and pg74.215.jdbc3.jar

I added in classpath.txt :
/usr/local/pgsql/share/java/pg74.215.jdbc2ee.jar (and then tried with
pg74.215.jdbc3.jar)

and from bash :
export CLASSPATH=/usr/local/pgsql/share/java/pg74.215.jdbc2ee.jar:.

(is this the right syntax ?)

and from Matlab :

EDU>> java.lang.Class.forName('org.postgresql.Driver');
??? Java exception occurred:
java.lang.ClassNotFoundException: org/postgresql/Driver
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120).

EDU>> conn = database('testdb','postgres','postgres','org.postgresql.Driver','jdbc:postgresql://masd/MOSE');
??? Java exception occurred:
java.lang.NoClassDefFoundError: javax/net/ssl/SSLSocket
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120)
at com.mathworks.toolbox.database.databaseConnect.makeDatabaseConnection(databaseConnect.java:100).

Error in ==> /usr/local/matlab6p5/toolbox/database/database/@database/database.m
On line 114 ==> connectionVector = makeDatabaseConnection(conn);

EDU>> confds
??? Java exception occurred:
java.lang.NoClassDefFoundError: javax/net/ssl/SSLSocket
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120)
at com.mathworks.toolbox.database.databaseConnect.makeDatabaseConnection(databaseConnect.java:100).

Error in ==> /usr/local/matlab6p5/toolbox/database/database/@database/database.m
On line 114 ==> connectionVector = makeDatabaseConnection(conn);

Error in ==> /usr/local/matlab6p5/toolbox/database/vqb/loginconnect.m
On line 26 ==> c = database(datasource,u,p,srcs{i,2},srcs{i,3});

Error in ==> /usr/local/matlab6p5/toolbox/database/vqb/confds.m
On line 141 ==> c = loginconnect(sourcestr);

??? Error while evaluating uicontrol Callback.

Thanks very much for your help.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Yi LIN 2004-09-22 17:29:20 Re: Problem linking Postgresql JDBC driverb and Matlab (Linux)
Previous Message Markus Schaber 2004-09-22 15:19:19 Re: Remote access with JDBC