# 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`