Matching Schemas with Oracle8i Lite

You can run existing business components against Oracle8i Lite as long as your schemas match and you keep in mind some limitations using Oracle8i Lite. You will not need to regenerate business components or modify SQL strings.

To run existing business components against Oracle8i Lite:

1. Edit your Oracle8i connect string to use an Oracle8i Lite connection.

   URL = "jdbc:polite:POLITE"
   user = "scott"
   password = "tiger"

   Oracle8i Lite requires the three-argument form of the connection string.

2. Be sure your view objects use JDBC style parameter binding.

   1. In the Workspace view of the Navigation Pane, right click a view object and choose Edit.

   2. Click the Query tab.

   3. Select Use ? style parameters.

   4. Repeat for each view object.

3. Change the SQLBuilder parameter to use an Oracle8i Lite database. There are several ways to achieve this, depending on if you want to modify the project locally, distribute the Oracle8i Lite capability to other developers, or toggle between Oracle8i Lite and Oracle8i databases.

Local project - When you want to modify your project locally, create a file with the name bc4j.properties and place the file in your project's working directory (the one named in Run/Debug working directory field on the Path tab of your Project Properties dialog). The file you create must contain this line:

jbo.SQLBuilder=OLite

• Distributed project - When you want to distribute the Oracle8i Lite capability to other developers, edit the oracle\jbo\server\jboserver.properties file in the JDeveloper lib directory (in the jbomt.zip), to set the SQLBuilder parameter.

• Toggle databases - When you want to toggle between Oracle8i Lite and Oracle8i databases, you can supply the SQLBuilder parameter in the Java VM Parameters field on the Run/Debug tab of the Project Properties dialog box, using the -D flag.

-Djbo.SQLBuilder=OLite

4. Add these Java libraries on the Libraries tab of the Project Properties dialog box:

   Oracle8i Lite
   JBO Generic Domains

   Note: By default JDeveloper installs an Oracle8i Lite library that points to C:\orant\; however, if you installed Oracle8i Lite in another location, you will need to change the library to use it.

5. If present, you must remove these libraries from the list to ensure your project does not use conflicting domain implementations:

   JBO Oracle Domains
   Oracle8i JDBC