1 Java Development Environment

Installing TimesTen and the JDK

Install and configure TimesTen for your environment, as described in Oracle TimesTen In-Memory Database Installation Guide, and the Java JDK, as described in your Java installation documentation. As you set up a Java development environment, the topics of particular interest in Oracle TimesTen In-Memory Database Installation Guide include the following:

• "JDK support"

• "Client/Server configurations"

• "Environment variables"

After you have installed and configured TimesTen, create a database DSN as described in "Managing TimesTen Databases" in Oracle TimesTen In-Memory Database Operations Guide. The topics of particular interest include the following:

• "Connecting using the TimesTen JDBC driver and driver manager"

• "Overview of user and system DSNs"

• "Defining DSNs for direct or client/server connections"

• "Thread programming with TimesTen"

• "Creating a Data Manager DSN on UNIX" or "Creating a Data Manager DSN on Windows"

Setting the environment for Java development

Before you begin developing Java applications for TimesTen, you must set your environment appropriately. This includes the following considerations:

• Environment variables must be set appropriately. See "Java environment variables" in Oracle TimesTen In-Memory Database Installation Guide for more information about environment variables for Java, including discussion of the PATH, CLASSPATH, THREAD_FLAGS, and shared library path environment variables.

• TimesTen includes Oracle Instant Client, which is required for certain JDBC features and operations.

Use the appropriate ttenv script to set up environment variables and runtime access to the Instant Client.

On UNIX platforms, execute one of the following scripts.

install_dir/bin/ttenv.sh
install_dir/bin/ttenv.csh

On Windows, run the following:

install_dir\bin\ttenv.bat

Compiling Java applications

"Java environment variables" in Oracle TimesTen In-Memory Database Installation Guide discusses the CLASSPATH setting for compiling Java applications in TimesTen.

Compiling any Java application requires the JAR file appropriate for your JDK to be in your classpath. In TimesTen, the following are for JDK 5.0 and JDK 6.0, respectively:

install_dir/lib/ttjdbc5.jar
install_dir/lib/ttjdbc6.jar

In addition, compiling any JMS/XLA application requires the following to be in your classpath:

install_dir/lib/timestenjmsxla.jar
install_dir/3rdparty/jms1.1/lib/jms.jar
install_dir/lib/orai18n.jar

About the TimesTen Java demos

After you have configured your Java environment, you can confirm that everything is set up correctly by compiling and running the TimesTen Quick Start demo applications. Refer to the Quick Start welcome page at install_dir/quickstart.html, especially the links under SAMPLE PROGRAMS, for information about the following:

• Demo schema and setup

  The build_sampledb script creates a sample database and demo schema. You must run this before you start using the demos.

• Demo environment and setup

  The ttquickstartenv script, a superset of the ttenv script generally used for TimesTen setup, sets up the demo environment. You must run this each time you enter a session where you want to compile and run any of the demos.

• Demos and setup

  TimesTen provides demos for JDBC and JMS/XLA under the quickstart/sample_code directory. For instructions on compiling and running the demos, see the README file or files in the subdirectories.

• What the demos do

  A synopsis of each demo is provided when you click JDBC (Java) under SAMPLE PROGRAMS. The TimesTen basic Java demos are named level1, level2, level3, and level4. Data files for the level demos are in the jdbc/datfiles directory.