ADBC Storage v1.0

The ADBC adapter is a standard adapter provided with Apama. It provides general database storage and retrieval (query) and also event capture and playback. The ADBC adapter supports both standard SQL and specialized databases. In particular, the adapter supports ODBC and JDBC. This support provides access to most commercial and open source SQL databases. ADBC provides a superset of the functionality that was available in the ODBC and JDBC Apama standard adapters.

Parameter	Description
service identifier	The name of the service to use.
database	The data source name of the database to connect to.
user name	The username to use when connecting to the database.
password	The password to use when connecting to the database (will be readable on screen).
table	The name of the table to store data in.
fields	A comma-separated list of field names.
values	A comma-separated list of values that will be placed in the fields list.
statement	If this is not empty, the correlator uses this as the storage command instead of using the fields and values parameters. This parameter can be set to an SQL operation such as UPDATE, DELETE, or ROLLBACK.
autocommit	The auto commit mode to use. The default is an empty string. Specify one of the following: OFF indicates no auto commit mode. ADBC indicates the ADBC adapter auto commit mode based on a time period. DATA_SOURCE indicates a data source specific auto commit mode. This might not be available for all data sources.
acknowledge store	Boolean that indicates whether the data source returns an acknowledgement to indicate success or failure for each store performed. True indicates that the data source always sends an acknowledgement. False indicates that the data source returns only store errors. The default is true. The success acknowledgement along with the current auto commit setting determine whether the data has been stored. A commit operation might also be needed.
unique connection	Boolean that indicates whether or not to create a new database connection. True indicates that you want the block to always create a new connection. False indicates that the block can use an existing connection. The default is false.
final store	If true indicates this will be the last store operation performed. Default value is false.If true the output feed field committed.final store complete will be set to true after the store operation completes (success or failure).

Operation	Description
connect	Establish a connection to the database.
store	Store in the database the data held in the block’s parameters.
commit	Commit any data sent to the database.
rollback	Rollback uncommitted changes to the database.
reset	Resets the output feed.
disconnect	Close the database connection.

Feed	Fields	Description
result	success	true if the last update to the database was successful.
	message	A message from the last database update operation.
	connected	true if connected to the database.
committed	status	true if the last commit operation succeeds, else false.
committed	final store complete	true when the store operation with the final store parameter set to true has completed.
rollback	status	true if the last rollback operation succeeded; otherwise false.