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 new synchronization parameter set.
createUUIDValue method	Creates a UUID value.
dropDatabase method	Drops a database.
emergencyShutdown method	Performs an emergency shut down of a connected database.
getDatabaseId method	Returns the value of database ID.
getDatabaseInfo method	Returns a DataInfo object containing information on database properties.
getDatabaseProperty method	Returns a property of the database.
getLastDownloadTime method	Returns the time of the most recent download of the specified publication.
getLastIdentity method	Retrieves the most recent value inserted into an DEFAULT AUTOINCREMENT or DEFAULT GLOBAL AUTOINCREMENT column, or zero if the most recent insert was into a table that had no such column.
getOption method	Returns a database option.
getState method	Returns the state of the connection.
getSyncObserver method	Returns the currently registered SyncObserver object for this Connection.
getSyncResult method	Returns the result of the last SYNCHRONIZE SQL statement, but not the last Connection.synchronize API call.
isSynchronizationDeleteDisabled method	Determine if 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	A connected state.
NOT_CONNECTED variable	A not connected state.
OPTION_BLOB_FILE_BASE_DIR variable	Database option: blob file base dir.
OPTION_DATABASE_ID variable	Database option: database id.
OPTION_DATE_FORMAT variable	Database option: date format.
OPTION_DATE_ORDER variable	Database option: date order.
OPTION_ML_REMOTE_ID variable	Database option: ML remote ID.
OPTION_NEAREST_CENTURY variable	Database option: nearest century.
OPTION_PRECISION variable	Database option: precision.
OPTION_SCALE variable	Database option: scale.
OPTION_TIME_FORMAT variable	Database option: time format.
OPTION_TIMESTAMP_FORMAT variable	Database option: timestamp format.
OPTION_TIMESTAMP_INCREMENT variable	Database option: timestamp increment.
OPTION_TIMESTAMP_WITH_TIME_ZONE_FORMAT variable	Database option: timestamp with time zone format.
PROPERTY_DATABASE_NAME variable	Database Property: database name.
PROPERTY_PAGE_SIZE variable	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 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 uncommited changes to the database
checkpoint (update the underlying persistent store with committed changes, rather than just storing the change transactions) the database.

The following example demonstrates how to create a schema for a simple database with a connection, 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();