The technology solution implemented allows engineers to collect vital car statistics into an Oracle9i Lite Database that resides on a PDA (Compaq iPaq 6360). The data capturing ability is provided by a Java based application.
The application provides mechanisms for uploading the captured data to a central Oracle 8i database and for two-way synchronization of any corporate data that is used for look-up purposes on the PDA.
Overview of the Solution and the Scope
As part of the development of this application we have developed a toolkit of components to enable CDP to fast track application development for other clients.
We had to work around challenges concerned with the Java to Oracle API interfaces, and with the limited replication functionality that seems to be currently available in the Mobile Synchronisation API.
We have used Java wherever possible with a small number of components, including a bespoke synchronising agent, having to be written in C++.
CDP intend to offer the toolkit together with consultancy to our existing customers and to new prospects who wish to create an Oracle based end-to-end mobile solution.
Technology Highlights
Oracle8i Database Server
Oracle9i Lite Mobile Server
Oracle9i Lite Database
Compaq iPaq 6360
Java Native Interface (JNI)
CDP Handheld development team designed and successfully implemented a component that cascades data replication errors if any to the Java environment.
The component is a 32bit DLL written in C++ for embedded systems, this software component uses the Oracle Mobile Sync API to perform controlled replication.
The status returned by the C program is critical for the Java program to perform a necessary action. The software component is initialised by the java program using the Java Native Interface library (JNI)
The JEODE Java Virtual Machine (JVM)for StrongArm based PDAs was used for this application.
