1 Prerequisites to using SQL Developer

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.

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 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 Mac OS X. 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 Mac OS X systems or the TimesTen installation_dir\lib\ttjdbc8.jar file on Microsoft Windows systems. SQL Developer Release 18.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 installation_dir/lib directory on Linux systems.

  • PATH includes the TimesTen installation_dir/bin directory on Linux and Mac OS X systems or the TimesTen installation_dir\bin directory on Microsoft Windows systems.

Additional prerequisites for specific platforms:

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 18.2 of SQL Developer, the release directory is 18.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

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 18.2 of SQL Developer, the release directory is 18.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.