Error using database.j​dbc.connec​tion/selec​t (line 74) Invalid connection.

15 views (last 30 days)
I can't connect to database using jdbc driver:
Error using database.jdbc.connection/select (line 74)
Invalid connection.
I tried to reinstall driver, updated javaclasspath but it doesn't work.
Is there any solution?

Answers (1)

Bob Hickish
Bob Hickish on 18 May 2020
I'm not sure if we had the same issue, but I managed to resolve mine by using these three functions in this order:
opts = configureJDBCDataSource('Vendor','PostgreSQL')
opts = setConnectionOptions(opts,"DataSourceName","PostgreSQL",..)
conn = database(databasename,username,password,driver,url)
I then checked I was connected to the database with: isopen(conn)

Community Treasure Hunt

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

Start Hunting!