Matching Schemas with a Standards-based Database

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

To run existing Business Components against a foreign database:

1. Edit your Oracle8i connect string to use a generic SQL connection.

   URL = "jdbc:odbc:db_name"
   user = "scott"
   password = "tiger"

   Note that the three-argument form of the connection string is required.

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 a generic database. There are several methods you can use to complete this step, depending on if you want to modify the project locally, distribute the generic database capability to other developers, or toggle between Oracle8i and generic 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=SQL92

• Distributed project - When you want to distribute the generic database 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 and generic 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=SQL92

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

   Your JDBC implementation
   JBO Generic Domains

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