Problem linking Postgresql JDBC driverb and Matlab (Linux)

Поиск
Список
Период
Сортировка
От Tuan Nguyen
Тема Problem linking Postgresql JDBC driverb and Matlab (Linux)
Дата
Msg-id 56afade704092210123df4ee7f@mail.gmail.com
обсуждение исходный текст
Ответы Re: Problem linking Postgresql JDBC driverb and Matlab (Linux)
Re: Problem linking Postgresql JDBC driverb and Matlab (Linux)
Список 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.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: Remote access with JDBC
Следующее
От: Yi LIN
Дата:
Сообщение: Re: Problem linking Postgresql JDBC driverb and Matlab (Linux)