I have a question related the JDBC Adapter. I’m trying to connect to an Oracle Database through a VPN. The link is up, and the JDBC Adapter is already configured to access the database. The JDBC Pool Connection is up without errors, but when I try to create a select or a notification in Developer it is not able to get the list of tables and select what is necessary to create my query.
We already checked that the access is working because the SQLPlus client could connect to the database showing the tables created.
Question: how can I find out where the problem is?
I think the problem might be with the connection but I’d like to have some help to test all the conditions… Anyone has faced this problem?
The JDBC properties:
Description JDBC Adapter
Adapter Version 6.0.3 Release Notes
JCA Spec Version 1.