SqlConn
SqlConn : Conn
SQL connector to a relational database using JDBC.
Unique identifier for entity in its project
Type of this entity
Marker tag for Conn type
Timeout for messages send to the connector's actor thread
Error message associated when connStatus indicates an error condition
Linger timeout used to keep a connector open
Duration used for connector open retries
Duration used to configure the auto-ping feature on a given connector
Current connection open/close state of a connector
Current status of a connector as one of the predefined strings See Connectors
Reference to a tuning configuration defined by a ConnTuning rec
Sets connector into disabled state to prevent communication
Marker tag for SqlConn type
JDBC database URI
Username for authentication
Password for authentication
This is a tag which must be configured on each sqlConn record used by the connSyncHis() function
Marker
Marker tag for SqlConn type
Uri?
JDBC database URI
Str?
Username for authentication
Password?
Password for authentication
Str?
This is a tag which must be configured on each sqlConn record used by the connSyncHis() function. The value must be an Axon expression which evaluates to a function with three parameters:
- sqlConn: the sqlConn record
- his: the HisPoint record being synced
- span: a range of two DateTime values
The function must be return a grid with at exactly two columns for the history data to sync. The first column must be a timestamp in the correct timezone. The second column must be the value. See hx.sql.