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.
In this development scenario you can build and run business components against Oracle8i and one or more foreign databases by switching the connection.
To configure a business component project for switchable datasources:
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, the appropriate connection type.
Create your database connection.
For a standards-based database, follow the steps for creating a connection in Developing an Application for a Generic Database.
For information on database connections, see Specifying the Connection to the Database.
Click Test Connection for each connection. You should see the message "Success".
Repeat steps 2-5 for each connection.
Click OK.
Start a Business Components project.
In the Business Components Project Wizard's Connection page
In the SQL Dialect field, select SQL92.
In the Type Map field, select Oracle.
When you want to switch datasources you must switch the libraries and change the connection first. Additionally, you must observe certain limitations depending on your connection type.