Jitterbit · Database connector

Database connection could not be established due to a security policy violation

Short answer

This Jitterbit error means agent 12.10 or later blocked a database connection to a loopback address or one that uses a restricted connection string parameter. On the private agent, configure the [JdbcSecurity] section of jitterbit.conf to allow the specific connection or parameter.

VerifiedLast verified

01Error text

Jitterbit error
The database connection could not be established due to a security policy violation.
JDBC connections to loopback addresses are not permitted.
JDBC connection parameter 'allowmultiqueries' cannot be enabled.

02Likely causes

  • Agent 12.10 and later restricts connections to localhost or 127.0.0.1, and specific connection string parameters for the MySQL, PostgreSQL, Oracle and SQL Server drivers.
  • Upgrading a private agent to 12.10 can break a connection that worked before, because the [JdbcSecurity] section is not added automatically to an existing jitterbit.conf.

03How to fix it

  1. On the private agent, configure the [JdbcSecurity] section of jitterbit.conf to allow the specific connection or parameter.
  2. Restart the agent.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.