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