The SQL Database driver provides a method of monitoring any JDBC-compliant Database Management System (DBMS). Almost all modern database servers provide a Java Database Connectivity drivers, and thus may be monitored and controlled by AggreGate.
The driver has the following capabilities:
| • | Checking database server availability and status; |
| • | Executing selection queries and providing access to query results; |
| • | Executing dynamically generated insert/update/delete queries. |
|
To allow AggreGate Server to load a third-party JDBC database driver supplied by your database server vendor, a JAR (Java Archive) file containing this driver must be added to the server classpath by putting it into /lib subdirectory of AggreGate Server installation or using AggreGate Server Launcher Properties File. |
Driver Information
Driver Plugin ID: |
com.tibbo.linkserver.plugin.device.database |
Global Settings
None defined.
User Level Settings
None defined.
Database Connection Properties
Property |
Description |
Database URL |
This is a database-specific string that defines the database type, the path (local or network) to a database to execute queries on and any additional options. To figure out the correct value for your selected JDBC database driver, please consult its documentation. |
Database Username |
This property defines which username is used to log on to the database server. |
Database Password |
This property defines which password is used to log on to the database server. |
Queries
This is a tabular setting defining what queries will be executed using a database server.
Field |
Description |
Name |
Name of device setting variable containing query result. |
Description |
Description of device setting variable containing query result. |
Expressions |
Forces treating Read Query and Write Query fields as expressions. These expressions must resolve to actual SQL query strings. |
Read Query |
Text of SQL selection query, or expression text if Expressions flag is set. Read query execution result will be accessible within AggreGate as a device setting variable. |
Write Query |
Text of SQL insert/update/delete query, or expression text if Expressions flag is set. If this field is non-empty, variable containing Read Query execution result will be writable (editable). Its modification will trigger execution of the Write Query. If Write Query is an expression, is may refer the Data Table containing Read Query result. This is a default table for references inside this expression. |
Device Settings
Database device driver creates one device setting variable per Queries table record. Format of this variable is dynamic, depending on the result of Read Query execution.
In addition, Database Statistics variable is created with the following fields:
| • | Database Name |
| • | Database Version |
| • | Database Driver Name |
| • | Database Driver Version |
Device Operations
This action lets you execute an arbitrary query on the database. Both select and update queries are supported.
Device Events
No events provided by the driver.
Connection Handling
This driver makes the device Online if JBDC connection to the database was established successfully.