Before you use SQL Developer with TimesTen or TimesTen In-Memory Database, you must perform the tasks:
For information about installing and starting SQL Developer, see Oracle SQL Developer User's Guide.
To access a TimesTen database from SQL Developer, install SQL Developer on the same system as the TimesTen Data Manager or Client. If you use SQL Developer to access local databases, install SQL Developer on the same system as the TimesTen Data Manager. If you use SQL Developer to access remote databases, install SQL Developer on the same system as the TimesTen Client.
Before you start SQL Developer, execute the installation_dir
/bin
/ttenv.sh
or installation_dir
/bin
/ttenv.csh
shell script on Linux and UNIX systems, the installation_dir
\bin
\ttenv.bat
batch file on Microsoft Windows systems, or the installation_dir
/bin
/ttenv.sh
on macOS. The shell script or batch file adds or modifies the environment variables:
CLASSPATH includes the TimesTen installation_dir
/lib
/ttjdbc8.jar
file on Linux and macOS systems or the TimesTen installation_dir
\lib
\ttjdbc8.jar
file on Microsoft Windows systems. SQL Developer Release 19.1 requires that you have installed Java Development Kit (JDK) 8.
To determine the third party JDBC drivers SQL Developer is using, from the Tools menu, select 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 installation_dir
/lib
directory on Linux systems.
PATH includes the TimesTen installation_dir
/bin
directory on Linux and macOS systems or the TimesTen installation_dir
\bin
directory on Microsoft Windows systems.
Additional prerequisites for specific platforms:
If you are using a TimesTen client version earlier than 18.1, you need to enable TimesTen Scaleout for SQL Developer:
Edit the SQL Developer product.conf
file. In most cases the file is located in C:\Users\
user
\AppData\Roaming\sqldeveloper\
release
\
For example, if you are using release 19.1 of SQL Developer, the release directory is 19.1.0
.
Add the following setting at the end of the product.conf
file:
AddVMOption -Doracle.dbtools.raptor.timesten.grid.internal.relaxDriverVersionCheck=true
To use SQL Developer with TimesTen on macOS, perform these prerequisites:
For macOS, you need to edit the SQL Developer product.conf file to enable TimesTen client functionality:
Edit the SQL Developer product.conf
file. In most cases the file is located in Users/
user
/.sqldeveloper/
release
/
For example, if you are using release 19.1 of SQL Developer, the release directory is 19.1.0
.
Add the following setting at the end of the product.conf
file:
Note:
Ensure that you replacetimesten_home
with the home directory of your local TimesTen client instance.
AddVMOption -Djava.library.path=/timesten_home/install/lib
Save the changes to the product.conf
file.
It is recommended that you create a shell script file that sources the TimesTen environment variables whenever you start SQL Developer.
Create a shell script file, env.sh
, in the /Users/
user
/.sqldeveloper
directory.
Add the following to the env.sh
file:
Note:
Ensure that you replacetimesten_home
with the home directory of your local TimesTen client instance.
source timesten_home/bin/ttenv.sh
Save the changes to the env.sh
file.