Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group