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.

Subtopics

Did you find this helpful?

Yes No