The Oracle Lite Blog

The Rekounas Blog about Oracle's Mobile Enterprise Application Platform

The Oracle Lite Blog header image 2

How to Connect Eclipse to Oracle Lite

September 4th, 2010 · No Comments

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.



Tags: Java · Oracle Lite

0 responses so far ↓

  • There are no comments yet...Kick things off by filling out the form below.

Leave a Comment