The following sections describe how to develop and test Java applications:
Table 9-1 lists the Java support provided for each platform in Oracle Database Lite.
| Category | Web-to-Go (both Windows and Linux) | Windows 32 Native | Windows CE | Linux Native | For More Information... |
|---|---|---|---|---|---|
|
JDBC |
Yes Oracle Database Lite offer three JDBC drivers. Refer to Section 9.1.1, "JDBC Drivers". |
Yes |
Yes |
Yes On Linux, only JDBC and ODBC access is supported. |
|
|
Java Stored Procedures /Triggers |
Yes Java Stored Procedures/Triggers are not supported in the Web-to-Go application model. However Java Stored Procedures can be replicated using the Consolidator Manager API. |
Yes |
N/A |
Yes |
|
|
Java Server Pages |
1.1 |
N/A |
N/A |
N/A |
|
|
Java Servlet |
2.2 |
N/A |
N/A |
N/A |
Section 6.2.4, "Developing Java Servlets for Web-to-Go" and Section 6.2.7, "Developing Applet Servlet Communication" |
|
BC4J |
Yes Latest version of Oracle JDeveloper 10g. |
N/A |
N/A |
N/A |
|
|
Struts |
Yes |
N/A |
N/A |
N/A |
For programmatically synchronizing from a Java application, see Chapter 3, "Synchronization".
The Oracle Database Lite JDBC driver is JDBC 1.2 compliant. Oracle Lite provides a limited number of extensions specified by JDBC 2.0. These extensions are compatible with the Oracle Database JDBC implementation.
Oracle Database Lite offers the following JDBC drivers:
Type 2 driver: There are two types of type 2 driver: one provides an embedded, direct connnection. This driver allows Java applications to communicate directly with the Oracle Lite database. The other type 2 driver provides a remote connection and requires Multi-User service support.
Type 4 driver : 100% Java implementation. Requires the multi-user database version.
To develop Java applications, you need to set up your development environment to create Oracle Database Lite applications, as follows:
You must have the Sun Microsystems Java Development Kit (JDK), version 1.4.2 (or higher).
To enable Oracle Database Lite to work with the JDK, set your PATH and CLASSPATH environment variables after you install Oracle Database Lite. See Section 9.2.1, "Setting Variables for the JDK" for full details.
Note:
If your environment includes aCLASSPATH user variable before you install Oracle Database Lite and the user variable does not include the CLASSPATH system variable (is not specified as CLASSPATH=...;%CLASSPATH%), then you must modify the CLASSPATH user variable to include the olite40.jar file in the OLITE_HOME\bin directory.Note:
All command prompt windows must be closed and reopened to reflect changes made to yourCLASSPATH.The directory with the JDK 1.4.2 or 5.0 Java compiler (javac.exe) should be in the PATH variable before any other directories that contain other Java compilers.
Add the directory that contains the Classic Java Virtual Machine (JVM) shared library, jvm.dll, to the PATH. jvm.dll should be in your JDK_Home\jre\bin\classic directory.
For example,
set PATH=C:\JDK_Home\bin;c:\JDK_Home\jre\bin\classic set CLASSPATH=c:\JDK_Home\jrc\lib\rt.jar;c:\OLITE_HOME\bin\olite40.jar
As an alternative to using the Classic JVM, you can use the HotSpot JVM. HotSpot is a JDK add on module provided by Sun Microsystems. HotSpot is available from the Sun Microsystems Web site.
After installing HotSpot, set your PATH as given below.
set PATH=c:\jdk\bin;c:\jdk\jre\bin\hotspot;%PATH%
In the example above, your installation of the JDK and HotSpot is on Drive C:\. Verify the location of your installation before amending your PATH statement. To test whether your system is set up correctly, run the Java examples in the <ORACLE_HOME>\Mobile\Sdk\Samples\JDBC directory.