Developing Java applications using DB2 Everyplace

DB2® Everyplace® provides a Java™ API that you can use to develop applications that use the DB2 Everyplace database.

1. Import the java.sql package and any other necessary Java classes.
2. Connect to the database either using the DriverManager class or the DataSource interface. See the sample Java application for details. The JDBC URL syntax is jdbc:subprotocol:subname. The DB2 Everyplace subprotocol is db2e.
   Restriction: DB2 Everyplace does not support multitasking on Symbian. In order to access a database from a second thread, the Connection object from the first thread must be closed before the connection can be established in the second thread. The same Connection object cannot be shared between threads.
3. Create a Statement object.
4. Access the database (your application logic goes here):
   1. Execute a SQL statement using the Statement object.
   2. Retrieve data from the returned ResultSet object (if the SQL statement you executed is a query).
5. Release database and JDBC resources by closing the ResultSet, Statement, and Connection objects.

• Overview of DB2 Everyplace Java synchronization providers
  This topic describes the Sync Client Java-API that is supported by DB2 Everyplace. The API is a set of libraries that allow developers to build applications that synchronize data between DB2 Everyplace and enterprise relational databases. It works in conjunction with the DB2 Everyplace Sync Server to simplify the synchronization of relational data and files. The Sync Server provides conflict resolution and manages the movement of data to and from mobile devices.
• Character encoding in Java applications
  Java programs use Unicode text internally; however, the character data in a DB2 Everyplace table could be in a format other than Unicode, depending on the operating system and language in which the table was created. You can dynamically specify the data encoding format.
• Sample Java application with backup and restore utilities
  This topic describes the BackupSample.java sample application and demonstrates how to code a Java application for DB2 Everyplace backup and restore utilities.
• Developing with JDBC
  This topic explains the basics of developing JDBC applications that interact with DB2 Everyplace.