The Oracle Lite Blog

Install either the Mobile Client or Mobile Development Kit.
Launch JDev.
Open the Connections Tab.
Right-click on Database and click New Database Connection.
Select Third Party JDBC Driver and click Next.

Enter your username and password. If it is a replicated database, username is SYSTEM.

For your url enter jdbc:polite:DSN.

You will also have to setup the Oracle Lite JDBC Driver. [...]

[Read more →]

I found a transaction test that I was performing a while back that might help you. In this example, I am using both drivers, I have an open connection with both drivers and I show an example of updating the dbname database with an insert and update statement. Note that even though I [...]

[Read more →]

So, you are planning on downloading one of these two databases and aren’t quite sure which one suits your needs.
Oracle XE is a scaled down version of Oracle’s flagship enterprise database. Some of the limitations are:

4GB database
Maximum of 1GB of memory
Cannot perform parallel processing of queries

This is ideal for students, developers and a practice [...]

[Read more →]

Ported a J2EE application this week to webtogo. I had an issue with my deployment due to the fact that I had an ‘_’ in my relative path. OJSP compiler translated that to ‘__’ and webtogo couldn’t find the package when I would reference the jsp. Also, noticed that the Webtogo Packaging [...]

[Read more →]

I have recently started coding for the sync process and have determined that the packaging wizard will not fulfil my needs. I have to use a hybrid approach combining the packaging wizard with the Consolidator API to get my application deployed. The first hurdle I have was to determine table weight. I completed that using [...]

[Read more →]

I have recently started coding for the sync process and have determined that the packaging wizard will not fulfil my needs. I have to use a hybrid approach combining the packaging wizard with the Consolidator API to get my application deployed. The first hurdle I have was to determine [...]

[Read more →]

One of the first things that you need to identify when developing a mobile application is to identify all the tables that will be synched and their relationships. In Oracle Lite, this is called Table Weights. Most applications that are developed have about 20-30 tables, so doing this manually shouldn’t take that long. I am [...]

[Read more →]