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.
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 |