SQL actor adapter

The SQL actor adapter provides the ability to interact with an SQL database using Java Database Connectivity (JDBC). You can configure multiple SQL actor adapters within Grid Manager, each with a unique configuration node and adapter name with the <configs> tag.

The SQL actor adapter supports simple and parameterized statements. The adapter configuration does not depend on the statement type.

You must place the driver for the SQL database, to which this adapter connects, in the $AO_HOME/lib/shared directory on each peer, on which the adapter is enabled. Each peer is restarted after you place the .jar file for the driver.