Timesten JDBC Driver and SQL Developer Not Working On El Capitan (OS X,10.11) (Doc ID 2077453.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle SQL Developer - Version 4.1 to 4.1.5 [Release 4]
Oracle TimesTen In-Memory Database - Version 11.2.2.8.0 and later
Apple Mac OS X (Intel) (64-bit)

Symptoms

1. Before upgrading MacOS to El Capitan, user was able to connect to remote TimesTen instances using the ttJdbc6.jar, via SQL Developer and via any command line java application.

2. After upgrading to El Capitan the default Java version was forced to be 1.8. This is a Java requirement of El Capitan.

3. This is the error for any application that uses JDBC to connect to TimesTen:
Problems with loading native library/missing methods: no ttJdbcCS in java.library.path
Detailed Stack:
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbcCS in java.library.path
at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:643)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:878)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:845)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:839)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
... 15 more
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbcCS in java.library.path

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