ALTER RESOURCE

    Syntax

    • Before altering the resources, please confirm that a database exists in Proxy, and execute the use command to successfully select a database;
    • ALTER RESOURCE is not allowed to change the real data source associated with this resource;
    • ALTER RESOURCE will switch the connection pool. This operation may affect the ongoing business, please use it with caution;
    • resourceName is case-sensitive;
    • resourceName needs to be unique within the current database;
    • poolProperty is used to customize connection pool parameters, key must be the same as the connection pool parameter name, value supports int and String types;
    • When password contains special characters, it is recommended to use the string form; for example, the string form of password@123 is "password@123".

    Example

    • Alter resource using standard mode
    • Alter resource and set connection pool parameters using standard mode
    • Alter resource and set connection pool parameters using URL patterns

    , RESOURCE, HOST, PORT, DB, USER, PASSWORD, , URL