JDBC Palette

The JDBC palette contains activities for querying, updating, or calling stored procedures in the database.

The CPU usage can be lowered by passing the following properties as a VM argument for eclipse or the config.ini file for AppSpace or AppNode at runtime.

  • -Dbw.application.jdbc.validateConnection=false

  • bw.application.jdbc.validateConnection.frequency=<int>

where, <int> represents a number which must be smaller than the Connection Idle Timeout property in the JDBC Shared Resource

Note: To avoid errors for the JDBC MS SQL Server Database, pass the trustServerCertificate=true property in the JDBC MS SQL Server URL.