Timesten - (SQL Developer|ODBC Client) Configuration

Prerequisites

• Download and install the last version of SQL Developer

Timesten Installation

To access a TimesTen database from SQL Developer,

• the TimesTen Data Manager
• or TimesTen Client

must be installed.

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

DSN

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

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.

• 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.

Add a new connection

Start Sql Developer and add a new connection:

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.

Third party driver

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

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