I'm having problems attempting to create a datasource for a Postgres database. I've tried various combinations of data-source-class and URL without success. Currently, I have it configured as:
data-source-class : oracle.jdbc.pool.OracleDataSource
URL : jdbc:postgresql:XPGSQL
This is give the error: java.sql.SQLException: Invalid Oracle URL specified
I have a feeling I should be using a url of the form jdbc:oracle:thin:@host:<port>:<SID> but I'm not sure exactly what it should be.
It's only when attempting to access the database through a datasource that I run into difficulties. I can make DriverManager connections without any problems.
Any thoughts would be much appreciated.