MATLAB Answers

Connect to PostGres db in 2011b

2 views (last 30 days)
Eoin
Eoin on 30 Sep 2011
Hi, I've upgraded to 2011b but still have 2010b running on my windows machine (both are 64-bit). Code that connects fine with my postgres dbin 2010b is having problems in 2011b. Here's the code:
conurl = ['jdbc:postgresql://localhost:5432/' dbname];
% Connect to the database.
con =database(dbname,username,password,'org.postgresql.Driver', conurl);
e = exec(con, ['select * from "tablename" ']);
cell_data = fetch(e);
This works a treat in 2010b but comes back with 'Undefined function 'fetch' for input arguments of type 'struct'. The value of e is 'Message: 'Invalid connection.''.
Does anyone know what the problem is? Why is this fine in 2010b and not 2011b? Please don't tell me i can't now connect to postgres - i had to move to postgres from MS Access because Matlab 64-bit can't connect to a MS Access database, so don't tell me i now have to move to another database platform.
Any help would be greatly appreciated.
Eoin

Accepted Answer

Oleg Komarov
Oleg Komarov on 30 Sep 2011
Verify that the path to the java driver is in javaclasspath.txt with:
javaclasspath
  1 Comment
Eoin
Eoin on 30 Sep 2011
Fantastic!
Thanks Oleg. Absolutely right!

Sign in to comment.

More Answers (1)

Dmitry
Dmitry on 10 Jan 2012
"Verify that the path to the java driver is in javaclasspath.txt with:" what does it mean ?
Can u explain ? thank you
  1 Comment
Walter Roberson
Walter Roberson on 10 Jan 2012
At the MATLAB prompt, give the command
javaclasspath
Look through the list of directory names shown. Is the path to your database drive shown in the list? If not then you will need to edit javaclasspath.txt to put it there (and will probably need to restart MATLAB.)

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!