JDBC Lookup Stage

The JDBC Lookup Stage was renamed for Fusion 3.0; it was called the JDBC Query Lookup stage in previous versions.

The JDBC Lookup Stage is used to call out to a database as part of a pipeline stage, to inject results into either the context/request or the pipeline document. For instance, if you needed to look up a user from a DB and add their profile information onto a request for downstream use in a pipeline, the JDBC Lookup Stage would facilitate this.

Note
You must first upload the JDBC driver to Fusion, see the Connector JDBC API page.

Example

An example of a JDBC Lookup Stage setup

Upload stage config via POST to Fusion REST-API endpoint `api/apollo/query-stages/instances`

curl -u user:pass -X POST -H "Content-Type: application/json" -d '{"id": "jdbc-quer","type":"jdbc-query-lookup","driver":"postgresql-9.3-1101-jdbc4.jar","connection":"jdbc:postgresql:database","username":"user","password":"password1","preparedStatement":"select ID as id from DATABASE;"}' http://localhost:8764/api/apollo/query-stages/instances

Response

{
  "type" : "jdbc-query-lookup",
  "id" : "jdbc-quer",
  "driver" : "postgresql-9.3-1101-jdbc4.jar",
  "connection" : "jdbc:postgresql:database",
  "username" : "user",
  "password" : "password1",
  "preparedStatement" : "select ID as id from DATABASE;",
  "fetchSize" : -1,
  "join" : true,
  "rows" : 10,
  "skip" : false,
  "label" : "jdbc-query-lookup",
  "type" : "jdbc-query-lookup"
}

Configuration

Tip
When entering configuration values in the UI, use unescaped characters, such as \t for the tab character. When entering configuration values in the API, use escaped characters, such as \\t for the tab character.