Note: Before you start a Business Components project, you must chose which database scenario you will use. You cannot change the SQL dialect and type map once you start the project.
If you want to use the SQL92 driver in JDeveloper to create connections and build your business components against generic databases, you must configure JDeveloper to work with the SQL92 driver.
To configure a business component project for a generic database:
Begin a Business Components Project.
On the Connection page of the Business Component Project Wizard, click New to create a new connection.
In the Connection dialog box's Select a JDBC Driver field, select Sun JDBC-ODBC Bridge.
In the Select an ODBC Datasource field, select your datasource name.
Click Test Connection. You should see the message "Success".
Click OK.
In the Business Components Project Wizard you will notice that the the SQL92 dialect and Java type map have been selected for you.
Additionally, you must observe certain limitations when building your business components using the SQL92 connection.