The Oracle Lite Blog

We have all been there.  Users start synching, MGP kicks in, some junior SQL developer has written a poorly executing batch job (yeah, I am blaming the junior PL/SQL guy) and all of the sudden, everything comes to a halt. Your online community can’t perform any transactions, your syncing users are just sitting there twiddling [...]

[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 [...]

[Read more →]

So, you are starting an IT project and there is a need for a disconnected component and you require Oracle Lite for your project.  What do you do?  Most people seem to dump the responsibility on the DBA.  Probably not the best move.  Not because they can’t handle the technology, but because they are often [...]

[Read more →]

So, you are all ready to go. Your application has gone through some final testing and all that is really left is to perform some minor performance tweaks here and there and clean up some bugs. Then someone in the rooms asks a question, “How will performance be during concurrent synchronizations? How will it affect [...]

[Read more →]

Ran into an issue today that I almost forgot about. It was during patching an Mobile Server on a Unix platform. The issue that I ran into was the following:
1. Stopped the server
2. Installed the patch
3. Tried to log into mobile manager
4. Got the following error:
WTG-10118: Mobile Server is not connected to the Repository
WTG-10117: Please [...]

[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 this URL}
The DISPLAY_CLIENT_DATA_SIZE is [...]

[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 →]

I will be attending Think NB again this year with OAOT as an exhibitor. I will be stationed at booth #122.
The event will be at the Saint John Trade and Convention Centre October 29-30.
Visitor schedule is posted here.
If all goes well this week, I will be demoing Oracle Lite on my new Samsung ACE [...]

[Read more →]

Ever since I started working with Oracle Lite, I have worked with Win32, Webtogo, or OC4J applications. This week, I am picking up a Samsung ACE World Edition Smartphone and I plan on putting some demo and sample applications on the phone to get my feet wet from a different perspective. Working on a small [...]

[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 [...]

[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 →]

As the mobility market is increasing in popularity more companies are recognizing the value of pushing the current boundaries of enterprise applications to extend the reach into mobile computing. With the extension of the enterprise to mobile devices the strategy and technology used to support them has met the growing demand but offered some interesting [...]

[Read more →]

Performance is often overlooked on a mobile database. Users are generally only dealing with thousands of rows instead of millions of rows, so not a lot of thought is spent on tuning a client database. I will show you a scenario where querying a table with 3600 hundred records can cause a [...]

[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 an Oracle database.  I [...]

[Read more →]

I recently upgraded my WordPress and while I was at it, I decided to update my blog theme as well.  I change the images to be images from Oracle OpenWorld 2007 in San Francisco.  They were all pictures that I took.
Let me know what you think of the new look.

[Read more →]

When you start designing an Oracle Lite solution, the very first thing you should think about after you determine that Oracle Lite is the path for your company, start thinking about performance. You are probably thinking, performance? This is Oracle Lite. I shouldn’t have to worry about performance tuning. Well, the truth of the matter [...]

[Read more →]

Starting upgrading Webtogo to OC4J and here are my likes and dislikes so far:Likes:

Full J2EE compliance
Easier to develop and debug application code
I can specify different JVM from the one that is installed last.

Dislikes:

Customized workspace is not supported (Although, I think I can get around that)
WTGJDBCDriver is doing some really, really weird things.
Session does not contain [...]

[Read more →]

Here is an example of how you deploy an application. I will follow it up with examples of how to add publication items to the application and adding users to the application as well.
The following command should be all on one line:
java -classpath .:$ORACLE_HOME/mobile/classes/consolidator.jar:
$ORACLE_HOME/mobile/server/bin/devmgr.jar:
$ORACLE_HOME/mobile/server/bin/webtogo.jar:
$ORACLE_HOME/jdbc/lib/ojdbc14.jar Deploy MOBILEADMIN MOBILEPWD localhost 1521 XE

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import [...]

[Read more →]

Let me start by saying that this is not supported or will be supported by Oracle. If you are doing some R&D work and want to see how Oracle Lite will work, it will install on Oracle XE. And just in case you were still thinking of using this in your production system, [...]

[Read more →]