Oracle API Gateway JDBC Driver Connection To TimesTen Fails with java.lang.Error: No JDBC Driver found for the name: timesten
Last updated on OCTOBER 03, 2017
Applies to:Oracle API Gateway - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.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 126.96.36.199.0 on Windows: > oagpolicystudio.exe -clean
The connection string is jdbc:timesten:direct:dsn=timesten_direct;UID=<user>;PWD=<password>.
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