Matlab - No suitable driver when connecting to localhost

Asked Jan 16 '18 at 00:37

Active Jan 16 '18 at 00:55

Viewed 351 times

I am trying to connect to a localhost setup PostgreSQL 10 with Matlab R2015a and after following the instructions and connection string layout, I'm at a loss to explain why I'm still getting a "No suitable driver found" error.

datasource = 'toronto';
username = 'postgres';
password = '********';
driver = 'org.postgresql.Driver';
server = 'jdbc:postresql://localhost:5432/';

connection = database(datasource, username, password, driver, server)

I've checked this related SO thread but no dice. Here's some extra information, hopefully someone has come across this before.

PostgreSQL 10.1, build 1800 64-bit
Java Version 8, built 1.8.0_91-b14
PostgreSQL JDBC 4.2 Driver, 42.1.4

edited Jan 16 '18 at 00:55

asked Jan 16 '18 at 00:37

rovyko

3,053
2
19
35

Your JDBC driver isn't on the classpath (Matlab can't find it). That is all your error message means, and all you must do to fix it. – Elliott Frisch Jan 16 '18 at 00:39
That's the thing, I've already added it to the classpath with javaaddpath – rovyko Jan 16 '18 at 00:40
And it didn't work. What is "javaaddpath"? – Elliott Frisch Jan 16 '18 at 00:43
Can you verify that the right classpath is present using javaclasspath command? If so, try to add the class path in OS as well and restart your MATLAB. Hope that helps. – Zaki Anwar Hamdani Jan 16 '18 at 00:44
It adds jar files to the classpath: https://www.mathworks.com/help/matlab/ref/javaaddpath.html – rovyko Jan 16 '18 at 00:44
@ZakiAnwarHamdani Yeah I see it at the bottom. – rovyko Jan 16 '18 at 00:45
Other quick fix is to copy driver jars to java ext lib folder. – Zaki Anwar Hamdani Jan 16 '18 at 00:47
Might be worth checking your jdbc drivers downloaded correctly too. – Elliott Frisch Jan 16 '18 at 00:49
@ZakiAnwarHamdani I've already tried that unfortunately @ ElliottFrisch I have redownloaded them a few times. These should be the correct ones right? https://jdbc.postgresql.org/download.html – rovyko Jan 16 '18 at 00:51
1

If copying to ect lib is not working then you might have issues with java configuration as well. You can follow these steps to be sure: https://au.mathworks.com/help/compiler_sdk/java/configure-your-java-environment.html – Zaki Anwar Hamdani Jan 16 '18 at 02:40

Matlab - No suitable driver when connecting to localhost

0 Answers0