1 Prerequisites to Using SQL Developer

Before you use SQL Developer with TimesTen or TimesTen In-Memory Database, you must perform the tasks:

• Setting environment variables for TimesTen and SQL Developer

For information about installing and starting SQL Developer, see Oracle SQL Developer User's Guide.

Setting environment variables for TimesTen and SQL Developer

To access a TimesTen database from SQL Developer, install SQL Developer on the same system as the TimesTen Data Manager or Client. If you want to use SQL Developer to access local databases, install SQL Developer on the same system as the TimesTen Data Manager. If you want to use SQL Developer to access remote databases, install SQL Developer and the TimesTen Client on the same system.

Before you start SQL Developer, execute the timesten_home/bin/ttenv.sh or timesten_home/bin/ttenv.csh shell script on Linux and UNIX systems, the timesten_home\bin\ttenv.bat batch file on Microsoft Windows systems, or the timesten_home/bin/ttenv.sh on macOS. The shell script or batch file adds or modifies the environment variables:

• CLASSPATH includes the TimesTen timesten_home/install/lib/ttjdbc8.jar file on Linux and macOS systems or the TimesTen timesten_home\install\lib\ttjdbc8.jar file on Microsoft Windows systems. SQL Developer Release 20.2 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 timesten_home/install/lib directory on Linux systems.

• PATH includes the TimesTen timesten_home/bin directory on Linux and macOS systems or the TimesTen timesten_home\bin directory on Microsoft Windows systems.

Additional prerequisites for specific platforms:

• Additional prerequisites for Microsoft Windows

• Additional prerequisites for macOS

Additional prerequisites for Microsoft Windows

If you are using a TimesTen client version earlier than 18.1, you need to enable TimesTen Scaleout for SQL Developer:

1. 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 21.2 of SQL Developer, the release directory is 21.2.0.

2. Add the following setting at the end of the product.conf file:

   AddVMOption -Doracle.dbtools.raptor.timesten.grid.internal.relaxDriverVersionCheck=true
   

Additional prerequisites for macOS

To use SQL Developer with TimesTen on macOS, perform these prerequisites:

• Enable TimesTen client functionality

• Create script that sources TimesTen environment variables

Enable TimesTen client functionality

For macOS, you need to edit the SQL Developer product.conf file to enable TimesTen client functionality:

1. 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 21.2 of SQL Developer, the release directory is 21.2.0.

2. Add the following setting at the end of the product.conf file:

   Note:

   Ensure that you replace timesten_home with the home directory of your local TimesTen client instance.

   AddVMOption -Djava.library.path=/timesten_home/install/lib
   

3. Save the changes to the product.conf file.

Create script that sources TimesTen environment variables

It is recommended that you create a shell script file that sources the TimesTen environment variables whenever you start SQL Developer.

1. Create a shell script file, env.sh, in the /Users/user/.sqldeveloper directory.
2. Add the following to the env.sh file:

   Note:

   Ensure that you replace timesten_home with the home directory of your local TimesTen client instance.

   source timesten_home/bin/ttenv.sh
   

3. Save the changes to the env.sh file.