bc-serverservice JDBC

This is a status service that stores jobs status and output in a JDBC compatible database. BeyondCron is distributed with support for MySQL and PostgreSQL databases. With the inclusion of the the appropriate JDBC driver, and creation of the the required table, BeyondCron is able to support other databases.

Environment variables

BEYONDCRON_STATUS_SERVICE JDBC
JDBC_CONFIG Name of a configuration file containing JDBC status service configuration variables. If not an absolute file name, BeyondCron will search BEYONDCRON_DIR_CONFIG, the directory in which bc-server was started, and ~/.JDBC_CONFIG for this file. Default is jdbc.dat

Configuration variables

The following configuration variables can be defined within the JDBC_CONFIG file.

url Database connection URL.
user Database user name.
password Database user password.
Optional MySQL configuration properties.
url Database connection URL.
user Database user name.
password Database user password.
Optional MySQL configuration properties.
url Database connection.
user Database user name.
password Database user password.
Optional database configuration properties.

Table

This service requires the following table:

Table Required permissions
bc_status Select/Insert/Update/Delete

with the following colums:

Column Type Nullable Default Primary key
bc_name VARCHAR(2048)
bc_timestamp BIGINT
bc_start_timestamp BIGINT
bc_state VARCHAR(32)
bc_result VARCHAR(32)
bc_value INTEGER
bc_message TEXT
bc_trigger TEXT
bc_output LONGTEXT
bc_removed BOOLEAN false
Column Type Nullable Default Primary key
bc_name TEXT
bc_timestamp BIGINT
bc_start_timestamp BIGINT
bc_state TEXT
bc_result TEXT
bc_value INTEGER
bc_message TEXT
bc_trigger TEXT
bc_output TEXT
bc_removed BOOLEAN false
Column Java type Size Nullable Default Primary key
bc_name String >= 2KB
bc_timestamp long
bc_start_timestamp long
bc_state String 32B
bc_result String 32B
bc_value int
bc_message String >= 2KB
bc_trigger String >= 2KB
bc_output String >= 2MB
bc_removed boolean false

If the user account has permission, BeyondCron will create the table if it does not already exist.

See also

  • service status AWS

Reference