The Oracle Lite Blog

Here is a quick overview for the Oracle Lite guys that are going to be or planning to move to Berkeley DB / SQLite API pretty soon. There are plenty of options in Berkeley DB that make the the database more stable then Oracle Lite on the mobile device. I was playing around with the [...]

[Read more →]

There is a new LinkedIn group for Oracle Mobile Enterprise Platform. Oracle Mobile Server plays a big part in the platform and it would be a good way to get connected with like minded individuals. So, if you work with Oracle Lite, Berkeley DB, SQLite, JDeveloper and ADF Mobile, this is a good place to [...]

[Read more →]

Before you read too far into the note, this is note for the decommissioning or the Oracle Lite Database Client. The server, sync, and device manager along with the development tools are still being developed. The client database will be Oracle Berkeley DB with SQL support via SQLite. Basically, if you are on Webtogo or [...]

[Read more →]

I bet you thought you could make an auto increment field in Oracle Lite the same way you make it in Oracle right? Well, you can’t do it the same way because Oracle Lite does not support PL/SQL. It does however support C, C++, C#, and Java stored procedures. We will review creating auto-increment fields [...]

[Read more →]

I set up my Nth Mobile Server/Oracle Application Server configuration this past weekend, and here is a list of modifications that I have made to my configuration files. In the webtogo.ora file: [WEBTOGO] DISPLAY_CLIENT_DATA_SIZE=NO ADMIN_JDBC_URL={changed this to use a RAC URL. Not required in 10.3.0.2 of the product as the installer handles this} THIN_JDBC_URL={ditto for [...]

[Read more →]

If you have picked up your November/December 2008 issue of Oracle Magazine, turn to page 28 and there is a brief interview with me. Here is the interview if you don’t have the magazine: Which new features in Oracle technologies are you currently finding most valuable? Oracle Database Lite’s automatic sync allows high reliability in [...]

[Read more →]

If you have been doing Oracle Lite development, chances are you have been either using the Packaging Wizard or the Mobile Workbench to create your applications. In some cases, you have had to use the APIs to do partition mapping or altering the publication items (I will show those in another post). I on the [...]

[Read more →]

If you plan on attending Oracle OpenWorld 2008 in San Francisco this year, I will be at the Oracle Lite booth in the Oracle DEMOgrounds. More details as they become available. **Update: Location Information Venue: Moscone Center Exhibition Hall – Database Demo Grounds Station ID: L05 DEMOground Floor Plan

[Read more →]

I have posted a suggestion at Oracle Mix for an Oracle Lite session on sizing and performance tuning. If you plan on going to Oracle OpenWorld San Francisco 2008 and are interested in this topic, go to Performance Tuning and Sizing Oracle Lite for a Global Enterprise Application and cast your vote. I am waiting [...]

[Read more →]

The last couple of weeks, for my own benefit, I have been looking at what products other then Oracle Lite do data synchronization between mobile devices and an enterprise database.  These products are: Sybase MobiLink IBM DB2 Everyplace Microsoft SQL Server Compact Edition (CE) From those 3, MobiLink and Everyplace are capable of syncing with [...]

[Read more →]