Reputation: 13519
I am trying to get a JDBC connection happening in my Glassfish 4, but it is complaining that the URL is incorrect when I ping it.
So far I have copied my ojdbc6.jar and ojdbc7.jar files into the Glassfish 4 > domain1 > lib directory.
My General settings look like this :
And my additional attributes look like this :
In my Oracle Devloper my settings look like this :
Any idea what I am doing wrong? Am I missing a slash or something?
Upvotes: 0
Views: 922
Reputation: 13857
It looks like you have to setup the server-url in the additional settings
of the JDBC connection pool
. In case of Oracle datasources the database server hostname is not sufficient.
username
and password
.url
to your JDBC connection pool.url
has to be in the following format: jdbc:oracle:thin:@<host>:<port>:<sid>
<sid>
is the service-id/service-name
Upvotes: 1
Reputation: 13519
Fixed it. This works.
I think it ignores everything except PASWORD and URL . So this setup seems to work
Upvotes: 0