Connection interface

Describes a database connection, which is required to initiate database operations.

Syntax

public interface Connection

Members

All members of Connection interface, including all inherited members.

Name	Description
checkpoint method	Checkpoints the database changes.
commit method	Commits the database changes.
createDecimalNumber method	Creates a new DecimalNumber object.
createSyncParms method	Creates a set of synchronization parameters.
createUUIDValue method	Creates a UUID value.
dropDatabase method	Drops a database.
emergencyShutdown method [BlackBerry]	Performs an emergency shut down of a connected database.
getDatabaseId method [BlackBerry]	Returns the value of database ID.
getDatabaseInfo method	Returns a DataInfo object containing information on database properties.
getDatabaseProperty method	Returns a database property.
getLastDownloadTime method	Returns the time of the most recent download of the specified publication.
getLastIdentity method	Retrieves the most recent value inserted into a DEFAULT AUTOINCREMENT or DEFAULT GLOBAL AUTOINCREMENT column, or zero if the most recent INSERT transaction was made on a table that had no such column.
getOption method [BlackBerry]	Returns a database option.
getState method [BlackBerry]	Returns the state of the connection.
getSyncObserver method	Returns the SyncObserver object that is currently registered for this Connection object.
getSyncResult method	Returns the result of the last SYNCHRONIZE SQL statement.
isSynchronizationDeleteDisabled method [BlackBerry]	Determine if the synchronization of deletes is disabled.
prepareStatement method	Prepares a statement for execution.
release method	Releases this connection.
resetLastDownloadTime method	Resets the time of the download for the specified publications.
rollback method	Commits a rollback to undo changes to the database.
setDatabaseId method	Sets the database ID for global autoincrement.
setOption method	Sets the database option.
setSyncObserver method	Sets a SyncObserver object to monitor the progress of synchronizations on this connection.
synchronize method	Synchronizes the database with a MobiLink server.
CONNECTED variable	Denotes a connected state.
NOT_CONNECTED variable	Denotes a not connected state.
OPTION_BLOB_FILE_BASE_DIR variable [BlackBerry]	Database option: blob file base dir.
OPTION_DATABASE_ID variable [BlackBerry]	Database option: database id.
OPTION_DATE_FORMAT variable [BlackBerry]	Database option: date format.
OPTION_DATE_ORDER variable [BlackBerry]	Database option: date order.
OPTION_ML_REMOTE_ID variable [BlackBerry]	Database option: ML remote ID.
OPTION_NEAREST_CENTURY variable [BlackBerry]	Database option: nearest century.
OPTION_PRECISION variable [BlackBerry]	Database option: precision.
OPTION_SCALE variable [BlackBerry]	Database option: scale.
OPTION_TIME_FORMAT variable [BlackBerry]	Database option: time format.
OPTION_TIMESTAMP_FORMAT variable [BlackBerry]	Database option: timestamp format.
OPTION_TIMESTAMP_INCREMENT variable [BlackBerry]	Database option: timestamp increment.
OPTION_TIMESTAMP_WITH_TIME_ZONE_FORMAT variable [BlackBerry]	Database option: timestamp with time zone format.
PROPERTY_DATABASE_NAME variable [BlackBerry]	Database Property: database name.
PROPERTY_PAGE_SIZE variable [BlackBerry]	Database Property: page size.
SYNC_ALL variable	The publication list used to request synchronization of all tables in the database, including tables not in any publication.
SYNC_ALL_DB_PUB_NAME variable	The reserved name of the SYNC_ALL_DB publication.
SYNC_ALL_PUBS variable	The publication list used to request synchronization of all publications in the database.

A connection is obtained using the connect or createDatabase methods of the DatabaseManager class. Use the release method when the connection is no longer needed. When all connections for a database are released, the database is closed.

A Connection object provides the following capabilities:

Create new schema (tables, indexes and publications)
Create new value and domain objects
Permanently commit changes to the database
Prepare SQL statements for execution
Roll back uncommitted changes to the database

The following example demonstrates how to create a schema for a simple database with a Connection object, conn, created for it. The database contains a table named T1, which has a single integer primary key column named num, and a table named T2, which has an integer primary key column named num and an integer column named quantity. T2 has an addition index on quantity. A publication named PubA contains T1.

// Assumes a valid connection object, conn, for the current database.

PreparedStatement ps;

ps = conn.prepareStatement( "CREATE TABLE T1 ( num INT NOT NULL PRIMARY KEY )" );
ps.execute();
ps.close();

ps = conn.prepareStatement( "CREATE TABLE T2 ( num INT NOT NULL PRIMARY KEY, quantity INT)" );
ps.execute();
ps.close();

ps = conn.prepareStatement( "CREATE INDEX index1 ON T2( quantity )" );
ps.execute();
ps.close();

ps = conn.prepareStatement( "CREATE Publication PubA ( Table T1 )" );
ps.execute();
ps.close();

Discuss this page in DocCommentXchange.