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" : "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).