Database connector

The database connector is a implementation used for connecting to remote systems that are using JDBC. This includes databases like Oracle, MySQL, PostgreSQL, H2,.....

A valid driver has to be available in the classpath.

The scope of the connector is limited to a single table. Implementing views on the database can extend the behaviour.

Configuration

Below are all the parameters you can specify on this connector.

name	description
jdbcUrl	the jdbcUrl (correct syntax)
username	the username used for authenticating
password	the password used for authenticating
driver	the fully qualified classname of the driver
table	the name of the database table
test-query	query used for testing (select 1)

Supported functions

Below are the implemented operations on this connector.

name		description
create	yes	implemented
find	yes	implemented
search	yes	implemented
update	yes	implemented
delete	yes	implemented
disable	no
archive	no
unarchive	no
ping	yes	pings the connection
validate	yes	validates the configuration on init

Open issues

• sorting

• paging

• multiple tables