Props configuration for JDBC

This section introduces the props configuration for JDBC access, which includes optimization parameters for ShardingSphere internal functions and some dynamic switch configurations. With the optimization parameters in the props configuration, you can flexibly tune to achieve optimal performance on the JDBC access side, while with the dynamic switch configuration, you can quickly locate issues and improve problem-solving efficiency.

Java configuration items

Let's follow our usual flow and start with the Java configuration items first. You will find the items classified by common, optimized, or checked props:

• Common props: In the following table, the SQL props are presented with their types, descriptions, and default values. These will allow you to set the SQL properties:

Table 7.47

• Optimized props: The following table shows you the optimization props. These will allow you to set the task-processing thread...