JdbcClient

Module for outbound JDBC access

Introduction

The JdbcClient module manages connections and access to JDBC compatible databases (RDBMS).

Each module (instance) manages a single pooled connection to a single RDBMS (a destination). To configure connections to multiple servers, use multiple modules. To increase throughput, increase the number of module instances.

The module provides a service on the internal event bus with a JSON based protocol and a java library for simplified use.

This module is used for all internal JDBC access, including the bundled JDBC valves.

Prerequisites

RDBMS specific driver available on class path.

Configuration

Module name: JdbcClient | JDBCClient

Properties

Name	Description	Default	Mandatory
name	Destination name. Unique identifier for a specific configuration/connection/service. This value must be unique for all jdbcclient configurations.	"default"
instances	Number of instances to deploy	1
jdbc	JDBC connection object
jdbc.url	RDBMS specific JDBC URL
jdbc.user	Connection user
jdbc.password	Connection password

Example

{
    "name": "JdbcClient",
    "config": {
        "name": "default",
        "jdbc": {
            "url": "jdbc:hsqldb:file:target/db/test",
            "user": "SA",
            "password": "secret"
        }
    }
}

Driver

JDBC requires a RDBMS specific driver. This driver must be manually downloaded and added to the server class path (restart required).