rying to connect sqldeveloper to a postgresql database via a jaspersoft jdbc connector.
have been able to make the conncection with dbeaver, but i really prefer sqldeveloper.
connection URL looks like this
jdbc:jaspersoft@https://<jaspersoftserver>/ reportservice;datasource=<BEAN path>;pagesize=500
i select Connection Type = Advanced
enter the URL into the Custom JDBC URL box, along with the username and password and when i test i get "Status : Failure -Test failed: Invalid connection information specified. Verify the URL format for the specified driver."
when i did the setup for dbeaver i did have to add a couple of vendor provided .jar files (one for the vendor jdbc, on for jaxb-api, and one for postgresql) - not exactly sure where to do this in sqldeveloper. in dbeaver it was in the Driver Manager section, then used it to create a new Database Connector. again, not sure how to do this in SQLDeveloper.
never had issues with SQLDeveloper in the past, but that was when i was connecting to an Oracle database using either the SID or Service name and connecting via the TNSNAMES definitions.
any and all help would be appreciated.