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

Re: Problem linking Postgresql JDBC driverb and Matlab (Linux)

From: Yi LIN <ylin30(at)cs(dot)mcgill(dot)ca>
To: tuanito_AT_gmail_DOT_com_NOSPAM(at)svr1(dot)postgresql(dot)org
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem linking Postgresql JDBC driverb and Matlab (Linux)
Date: 2004-09-22 17:29:20
Message-ID: Pine.GSO.4.44.0409221326360.15778-100000@willy (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

I also use postgresql jdbc in planetlab and I have no problem with the
driver. Your classpath setting looks correct. Why don't u try a small jdbc
program without Matlab? If it works then it means that Matlab requries u
to register the jdbc driver somewhere in Matlab's configuration.

Regards,

Yi

On Wed, 22 Sep 2004, Tuan Nguyen wrote:

> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>


In response to

pgsql-jdbc by date

Next:From: WaldomiroDate: 2004-09-22 18:27:15
Subject: Char(100) fields
Previous:From: Tuan NguyenDate: 2004-09-22 17:12:58
Subject: Problem linking Postgresql JDBC driverb and Matlab (Linux)

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