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 Oracle8i Lite JDBC driver in JDeveloper to create connections and build your business components against Oracle8i Lite databases, you must first configure JDeveloper to work with Oracle8i Lite:
To configure a business component project for Oracle8i Lite:
Close JDeveloper. You may want to print these directions first.
Open jdeveloper.ini in a text editor. This file is located in your [jdev_home]\bin directory.
In the jdeveloper.ini file, add olite40.jar to your IDEClassPath.
Note: By default JDeveloper installs an Oracle8i Lite library that points to C:\orant\lite\classes\olite40.jar; however, if you installed Oracle8i Lite in another location, you will need to change the location to use it.
In the jdeveloper.ini file, modify the JLP and SLP values to point to your OLite implementation. The default value points to c:\orant\bin.
Start JDeveloper and begin a Business Components Project.
Note: In the Business Components Project Wizard you will notice that the OLite SQL dialect and Java type map have been selected for you by default. If you made a custom type map, it will appear on the list here.
Additionally, you must observe certain limitations when building your business components using the Oracle8i Lite connection.