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

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?

Answer 1

[Bob Hickish]

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)