The Oracle Lite Blog

I have done a How to Connect JDeveloper to Oracle Lite, now I will connect Eclipse to Oracle Lite.

1. Window -> Preferences
2. Expand Data Management and then Connectivity
3. Select Driver Definitions and click Add…
4. Select Oracle Thin Driver… vendor Oracle, the version doesn’t really matter but just select 10 for this example.
5. Rename the Driver  Name to 
6. Click the Jar List tab
7. Select the only jar that is there and click Remove JAR/Zip
8. Click Add JAR/Zip…
9. Find %ORACLE_LITE_HOME%/bin/olite40.jar
10. Select the Properties tab
11. You can leave Catelog as USER or change it to something else.  Oracle Lite won’t use this.
12. Edit the Connection URL to be jdbc:polite:<USERNAME>_<Database>
13. Edit the Database Name to be <USERNAME>_<Database>
14. Edit the Driver Class to be oracle.lite.poljdbc.POLJDBCDriver
15. Edit the password to your password
16. Edit the username to be system
17. Click Ok
18. Now, find the Open Perspective button and click it.
19. Select Other…
20. Select Database Development and click OK
21. Data Source Explorer will attach to the left frame.
22. Right click on Database Connections and click New…
23. Select Oracle and enter POLJDBCDriver and click Next>
24. You should now see all the information that you entered earlier.  Click Test Connection.  If everything is set up correctly, then you should get a Ping Succeeded message.
25. Click Finish
26. You should now see your database connection in the Database Connections tree.
27. Right click on the POLJDBCDriver root and select Open SQL Scrapbook.

From the drop-downs in the Connection Profile, select Oracle_10 and the Type, POLJDBCDriver as Name and select your database name.