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.

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.