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 OCTOBER 03, 2017

Applies to:

Oracle API Gateway - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.4.0 version, Oracle API Gateway

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 $INSTALLDIR/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
-----------------------




Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms