JDBC

Version: 2.1.0

Connects to database using JDBC. Supports connection to Postgres via postgreSQL-42.6.0.

Connect JDBC with LogicHub

  1. Navigate to Automations > Integrations.
  2. Search for JDBC.
  3. Click Details, then the + icon. Enter the required information in the following fields.
    • Label: Enter a connection name.
    • Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.
    • Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).
    • Remote Agent: Run this integration using the LogicHub Remote Agent.
    • Connection String: Connection string for JDBC. Example: 'jdbc:postgresql://1.2.3.4:5432/database?sslmode=allow'.
    • Username: User to connect to your database instance.
    • Password: Password for database.
    • JVM Arguments: Arguments to be passed while starting JVM. Example: '-Doracle.jdbc.javaNetNio=false,-Doracle.jdbc.timezoneAsRegion=false'.
    • Driver Name: Driver name to be used in JDBC. (Default is 'org.postgresql.Driver').
  4. After you've entered all the details, click Connect.

Query

Query Database

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
QueryJinja-templated text containing the database query. e.g SELECT * from customers where id={{id_column_name}}Required

Output

JSON containing the following items:

{
   "error":null,
   "has_error":false,
   "result":{
      "version":"PostgreSQL 10.10 (Debian 10.10-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit"
   }
}

Release Notes

  • v2.1.0 - Code vulnerability fix by removing usage of static jar
  • v2.0.0 - Updated architecture to support IO via filesystem
  • v1.0.0 - Added 1 new action Query.