Timesten - (SQL Developer|ODBC Client) Configuration

Timesten Component

About

How to configure SQL Developer to connect to a Timesten Database.

Steps

Prerequisites

Timesten Installation

To access a TimesTen database from SQL Developer,

must be installed.

Download the Oracle Timesten software. (The client is included with the server installation).

Timesten Component

DSN

You can connect to a TimesTen database after you have defined a client data source name (DSN) for the database.

Timesten Dsn Client Windows

The default Network Port is 53397

Environment Variable

Before you start SQL Developer, execute:

  • on Linux: the TimesTen install_dir/bin/ttenv.sh or TimesTen install_dir/bin/ttenv.csh shell script systems,
  • on Windows: the TimesTen install_dir\bin\ttenv.bat batch file

The shell script or batch file adds or modifies the environment variables:

  • CLASSPATH includes the TimesTen install_dir/lib/ttjdbc6.jar file on Linux systems or the TimesTen install_dir\lib\ttjdbc6.jar file on Microsoft Windows systems.

SQL Developer 3.0 requires that you have installed Java Development Kit (JDK) 6. To determine the third party JDBC drivers SQL Developer is using, select Tools > Preferences. In the Preferences dialog, click the + to the left of the Database node. Select Third Party JDBC Drivers. View the path name of all third party JDBC drivers including the TimesTen JDBC drivers.

  • LD_LIBRARY_PATH includes the TimesTen install_dir/lib directory on Linux systems.
  • PATH includes the TimesTen install_dir/bin directory on Linux systems or the TimesTen install_dir\bin directory on Microsoft Windows systems.
C:\Users\gerard>C:\TimesTen\tt1122_64\bin\ttenv.bat
Setting environment variables for TimesTen

set PATH to "C:\TimesTen\TT1122~1\bin;C:\TimesTen\TT1122~1\quickstart\sample_code\oci;C:\TimesTen\TT
1122~1\quickstart\sample_code\odbc;C:\TimesTen\TT1122~1\quickstart\sample_code\odbc\xla;C:\TimesTen\
TT1122~1\quickstart\sample_code\jdbc;C:\TimesTen\TT1122~1\quickstart\sample_code\odbc_drivermgr;C:\T
imesTen\TT1122~1\quickstart\sample_code\proc;C:\TimesTen\TT1122~1\quickstart\sample_code\ttclasses;C
:\TimesTen\TT1122~1\quickstart\sample_code\ttclasses\xla;C:\TimesTen\TT1122~1\ttoracle_home\instantc
lient_11_2;C:\TimesTen\TT1122~1\ttoracle_home\instantclient_11_2\sdk;C:\TimesTen\TT1122~1\3rdparty\a
nt\bin;C:\TimesTen\TT1122~1\lib;C:\app\gerard\product\11.2.0\client_32bit\bin;C:\app\gerard\product\
11.2.0\client_1\bin;C:\OracleBI\server\Bin;C:\OracleBI\web\bin;C:\OracleBI\web\catalogmanager;C:\Ora
cleBI\SQLAnywhere;C:\Program Files (x86)\Java\jdk1.6.0_32\bin;C:\Windows\system32;C:\Windows;C:\Wind
ows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\WIDCOMM\Bluetooth Sof
tware\;C:\Program Files\WIDCOMM\Bluetooth Software\syswow64;C:\Program Files\TortoiseSVN\bin;C:\Prog
ram Files (x86)\Calibre2\;C:\Program Files\jEdit;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\C
ommon Files\Intel\WirelessCommon\"

set CLASSPATH to "C:\TimesTen\TT1122~1\lib\ttjdbc6.jar;C:\TimesTen\TT1122~1\lib\orai18n.jar;C:\Times
Ten\TT1122~1\lib\timestenjmsxla.jar;C:\TimesTen\TT1122~1\3rdparty\jms1.1\lib\jms.jar;."
NOTE: TNS_ADMIN is already set in environment - D:\svn\Config\Oracle Database

SQL Developer Preferences

TimesTen connections work best in SQL Developer if the AutoCommit flag is checked. ????

Go to Tools, and select Preferences.

Sql Developer Preference Autocommit

Add a new connection

Start Sql Developer and add a new connection:

Sqldeveloper Connection Timesten

If the TimesTen database will be used to cache data from an Oracle database, specify the password of the Oracle user in the Oracle Password (for Cache) field. The Oracle user has the same name as the TimesTen user that was specified in the Username field.

If you select User specified for the DSN:

  • then choose either Client/server to establish a client/server connection or Direct driver to establish a direct connection.
  • specify a Connection string to define the DSN and set attributes for the DSN. Each attribute setting must be separated by a semicolon. Do not delimit the connection string with a pair of double quotation marks.

Support

Third party driver

The installation must configure the Jdbc Driver of Timesten. You can see him in the Sql Developer preferences.

Sql Developer Timesten Third Party Jdbc Driver

Problems with loading native library

An error was encountered performing the requested operation:

Problems with loading native library/missing methods: C:\TimesTen\tt1122_64\bin\ttJdbcCS1122.dll: 
Can't load AMD 64-bit .dll on a IA 32-bit platform

Vendor code 0

SQL Developer use a 32 bit JDK in place of a 64 bit. You can check it in the properties. Help > About > Properties > java.home

And you can set it here: SQL Developer JDK Home

Documentation / Reference





Discover More
Timesten Component
(TimesTen|TT) (In-Memory Database|IMDB)

Oracle TimesTen In-Memory Database (TimesTen) is amemory-optimized relational database. IMDB = In-Memory Database For existing application with data residing on the Oracle Database, TimesTen is deployed...
Sql Developer Connection String
Timesten - Connection String

A Connection string is a way to define connection attributes that are not define in the DSN. According to the ODBC standard, when an attribute occurs multiple times in a connection string, the first value...
Timesten Component
Timesten - How to set up the Timesten Cache ?

Steps to set up the Timesten Cache to cache data of an Oracle Database. Before you cache Oracle data in a TimesTen database, you must perform certain tasks: either outside SQL Developer using command-line...



Share this page:
Follow us:
Task Runner