This preface introduces you to the Oracle Database Lite Developer’s Guide, discussing the intended audience, documentation accessibility, and structure of this document.
This manual is intended for application developers as the primary audience and for database administrators who are interested in application development as the secondary audience.
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
TTY Access to Oracle Support Services
Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week. For TTY support, call 800.446.2398.
This guide includes the following topics:
Provides an introduction to Oracle Database Lite 10g and gives an overview of the application development process using the Mobile Development Kit.
Chapter 2, "The Oracle Database Lite RDBMS"
Presents the Oracle Database Lite Relational Database Management System (RDBMS).
Describes synchronization functions between Oracle Database Lite and an Oracle database using the Mobile Server and the Mobile Sync client application.
Chapter 4, "Invoking Synchronization APIs from Applications"
Describes APIs for COM, C, C++, and Java for programmatically starting the synchronization phases.
Chapter 5, "Using Mobile Database Workbench to Create Publications"
Use the Mobile Database Workbench to create publications and subscriptions.
Chapter 6, "Using the Packaging Wizard"
Describes how to use the packaging wizard when publishing applications.
Chapter 7, "Developing Mobile Web Applications"
Discusses Web based Mobile application development.
Chapter 8, "Native Application Development"
Discusses Mobile application development for native platforms.
Chapter 9, "Java Application Development"
Describes how to develop and test Java applications.
Chapter 10, "JDBC Programming"
Discusses the Oracle Database Lite support for JDBC programming.
Chapter 11, "Java Stored Procedures and Triggers"
Describes how to use Java stored procedures and triggers within the Oracle Database Lite support for JDBC programming.
Chapter 12, "Using Simple Object Data Access (SODA) for PalmOS and PocketPC Platforms"
Describes support for PalmOS and Pocket PC/Windows CE devices using the SODA interface.
Chapter 13, "Developing Mobile Applications for PalmOS Devices"
Discusses building Oracle Database Lite 10g applications for Palm devices. Oracle Database Lite 10g for Palm OS supports Simple Object Database Access (SODA) and Open Database Connectivity (ODBC) as programming interfaces. This document also describes how to build and run Oracle Database Lite 10g applications using Metrowerks CodeWarrior 9.
Chapter 14, "Oracle Database Lite ADO.NET Provider"
Discusses ADO.NET support for Windows CE.
Chapter 15, "Oracle Database Lite Transaction Support"
Describes how to implement transactions.
Chapter 16, "Oracle Database Lite Development Performance Considerations"
Describes how you can increase performance for Oracle Database Lite.
Chapter 17, "Oracle Database Lite Security"
Describes security configuration for Oracle Database Lite.
Chapter 18, "Oracle Database Lite Tracing"
Describes how to initiate tracing.
Chapter 19, " Building Mobile Web Applications: A Tutorial"
Guides you through the relevant phases of implementing a Web application for Mobile devices through a tutorial.
Chapter 20, "Building Offline Mobile Web Applications Using BC4J: A Tutorial"
Enables you to create, deploy, and use a BC4J application through a tutorial.
Chapter 21, "Building Offline Mobile Applications for Win32: A Tutorial"
Guides you through the Mobile application development process for the Win32 platform through a tutorial.
Chapter 22, "Building Offline Mobile Applications for Windows CE: A Tutorial"
Describes how to build a Visual Basic.NET (Visual Studio.NET 2003) application using the Oracle Database Lite 10g ADO.NET interface for Pocket PC through a tutorial.
Appendix A, "Optimizing SQL Queries "
Provides tips on improving the performance of your SQL queries.
Appendix B, "Oracle Lite Database Utilities"
Describes the utilities you can use to manage your Oracle Lite database.
Appendix C, "ODBC Support on Palm"
Describes the Open Database Connectivity (ODBC) support provided in Oracle Database Lite 10g for the Palm OS Platform.