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 […]
Entries Tagged as 'Oracle Lite'
Updates on my activities
May 26th, 2013 · 6 Comments
Tags: Oracle Lite
New Release of Oracle Database Mobile Server
October 11th, 2011 · No Comments
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 […]
Tags: Android · Berkeley DB · Java · Oracle Lite · Oracle Mobile Server · SQLite · Webtogo
What is next for Webtogo users?
March 23rd, 2011 · No Comments
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 […]
Tags: HTML5 · Oracle Lite · Oracle Mobile Server · SQLite · Webtogo
Blog Direction
March 6th, 2011 · No Comments
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, […]
Tags: Oracle Lite
Synchronizing with Berkeley DB
November 9th, 2010 · 6 Comments
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 […]
Tags: Berkeley DB · Oracle Lite · SQLite
Oracle Mobile Enterprise Application Platform Group on Linkedin
November 2nd, 2010 · No Comments
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 […]
Tags: Berkeley DB · Mobile ADF · Oracle Lite · Oracle Mobile Server · SQLite
Migration from Oracle Lite to Berkeley DB
October 21st, 2010 · Comments Off on Migration from Oracle Lite to Berkeley DB
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.
Tags: Berkeley DB · Oracle Lite
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. 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 […]
Tags: Java · Oracle Lite
Getting started with Berkeley DB and Oracle Mobile Server
August 26th, 2010 · 16 Comments
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 […]
Tags: Berkeley DB · Oracle Lite · SQLite
Changes to Oracle Lite Database components coming
August 4th, 2010 · 2 Comments
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 […]
Tags: Berkeley DB · Oracle Lite · SQLite · Webtogo
Gaining performance out of Queue-Based refresh
March 9th, 2010 · 3 Comments
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 […]
Tags: Oracle Lite
How to create an auto increment field in Oracle Lite
October 24th, 2009 · 12 Comments
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 […]
Tags: Oracle Lite
What is a Oracle Lite developer made of?
September 21st, 2009 · No Comments
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 […]
Tags: Oracle Lite
Testing Concurrent Synchronization in Oracle Lite
May 11th, 2009 · No Comments
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 […]
Tags: Oracle Lite
Patching Oracle Lite in Unix
March 31st, 2009 · No Comments
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 […]
Tags: Oracle Lite
Setting up a Mobile Server for size and performance
December 15th, 2008 · 6 Comments
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 […]
Tags: Java · Oracle Lite
Mentioned in Oracle Magazine Peer-to-Peer
November 5th, 2008 · 2 Comments
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 […]
Tags: Oracle · Oracle Lite
Think NB 2008
October 24th, 2008 · No Comments
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 […]
Tags: Oracle Lite
Oracle Lite on a Smartphone
October 12th, 2008 · 4 Comments
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 […]
Tags: Oracle Lite
Creating publication items using the Oracle Lite API
September 19th, 2008 · 3 Comments
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 […]
Tags: Java · Oracle Lite