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:

• "Java environment variables"

• "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 setting the environment variables 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.

Environment variables and runtime access to the Instant Client are configured through the appropriate ttenv script See "Environment variables" in the Oracle TimesTen In-Memory Database Installation Guide for additional information.

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, 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 (.sh or UNIX or .bat on Windows) creates a sample database and demo schema. You must use this before you start using the demos.

• Demo environment and setup: The ttquickstartenv script (.sh or .csh on UNIX or .bat on Windows), a superset of the ttenv script generally used for TimesTen setup, sets up the demo environment. You must use this each time you enter a session where you want to compile or 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.