Fusion Server

Version 4.1
How To
Documentation
    Learn More

      JDBC Lookup Stage

      Table of Contents

      The JDBC Lookup query pipeline 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 example, 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.

      Example

      An example of setup for a JDBC Lookup query pipeline stage.

      Upload stage config via POST to Fusion REST API endpoint `api/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/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

      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.

      When using Fusion's REST API, the ID for this stage is:jdbc-query-lookup.

      Loading liquid template...

      Loading configuration schema...