Oracle API Gateway JDBC Driver Connection To TimesTen Fails with java.lang.Error: No JDBC Driver found for the name: timesten
(Doc ID 2311728.1)
Last updated on MAY 01, 2024
Applies to:
Oracle API Gateway - Version 11.1.2.1.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to create a JDBC Database Connection pool in Policy Studio to TimesTen, the following error occurs:
java.lang.Error: No JDBC Driver found for the name: timesten
The next steps were performed to install JDBC driver to API Gateway. Same steps for Oracle Database 12c work fine, but it is not working with Timesten.
1- For Oracle API Gateway, copy the Timesten JDBC Driver jar into <OAG HOME>/apigateway/ext/lib on Linux and restart.
2- For Policy Studio, add the Timesten JDBC Driver jar to Policy Studio:
• Select Windows -> Preferences -> Runtime Dependencies in the Policy Studio main menu.
• Click Add to select a JAR file to add to the list of dependencies.
• Click Apply when finished. A copy of the JAR file is added to the plugins directory in your Policy Studio installation.
• Click OK.
• Restart Policy Studio from a command prompt with the "-clean" option. Here "-" is the minus sign.
o 11.1.2.4.0 on Windows: > oagpolicystudio.exe -clean
The connection string is jdbc:timesten:direct:dsn=timesten_direct;UID=<USER>;PWD=<PASSWORD>.
ERROR
-----------------------
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |