Error using database.jdbc.connection/select (line 74) Invalid connection.
15 views (last 30 days)
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)