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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.