The Oracle Lite Blog

So as you can see not many Oracle Lite posts in a while. Ok, correction, no posts at all. The main reason for this is that I had a career move way back in 2011 and I became DBA focusing on MongoDB and MySQL. Does this mean I will stop answering questions? No, but I […]

[Read more →]

The 11g version is finally out. I have yet to play with the new version of the product and will download it in the coming weeks. But in short, here is what the release notes contain: The Oracle Database Mobile Server 11g supports synchronization from only two mobile clients, the Berkeley DB Mobile Client and […]

[Read more →]

With Oracle’s announcement about the direction of Oracle Lite, Webtogo, and Branch Office, application development teams will be looking for possibly new directions.  So, decisions are going to have to be made.  Those decisions are: Do we keep the JSP/Struts application and run it on another platform like JBoss or Tomcat and just migrate from […]

[Read more →]

I am moving the blog into a slightly different direction.  Not that I am moving away from Oracle Lite related posts, but what I will focus on more is mobile development with embedded databases blog posts.  This blog has been specifically targeted to Oracle Lite and specifically to the synchronization portion of the technology.  Although, […]

[Read more →]

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

If you are in the situation where you are migrating Oracle Lite to Berkeley DB including Webtogo Web Based migrations, I can help. I have experience with Oracle Lite from versions 9i(5.0.2) to 10g(10.3.0.3) and I can help with your migration. Contact me for further assistance.

[Read more →]

I have done a How to Connect JDeveloper to Oracle Lite, now I will connect Eclipse to Oracle Lite. Window -> Preferences Expand Data Management and then Connectivity Select Driver Definitions and click Add… Select Oracle Thin Driver… vendor Oracle, the version doesn’t really matter but just select 10 for this example. Rename the Driver […]

[Read more →]

In this post, I will try to give a quick overview of setting up Berkeley DB to Sync with Mobile Server. It is important to note that we will be overriding the SQLite deployment. Step 1: Building the Berkeley DB Here is the document to get you started. Step 2: Rename Binaries Once you have […]

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

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 creating auto-increment fields […]

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

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

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

[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 on the […]

[Read more →]