Troubleshooting. Database Connector (Legacy) for Oracle works, new Oracle Connector doesn't.

Hello,

I’ve been scratching my head trying to solve this. I can connect to my oracle database utilizing the legacy Database connector, but when I attempt to use the new Oracle Connector I get:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor.

My hostname/port/login credentials are identical for both nodes. But, cannot use the new Oracle connector. Any ideas?

Signed,
John

Hi John,
currently the node uses a fixed JDBC URL schema which is:
jdbc:oracle:thin:@\<host>:\<port>/\<database>
If you need to use another URL schema e.g. another driver type then you need to use the generic DB Connector node with Oracle as database type and database dialect.
We are working right now on an update of the framework which will allow you to specify the JDBC schema when you register the driver. The connector nodes will then use the URL template e.g. jdbc:oracle:oci8:@\<host>:\<port>/\<database> that you can specify when you register a driver (see below).


Bye
Tobias

Greetings Tobias,

That works! :slight_smile: Thank you.

Signed,
John

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.