ADD RESOURCE

Description

The ADD RESOURCE syntax is used to add resources for the currently selected database.

Syntax

AddResource ::=
  'ADD' 'RESOURCE' resourceDefinition (',' resourceDefinition)*
resourceDefinition ::=
  resourceName '(' ( 'HOST' '=' hostName ',' 'PORT' '=' port ',' 'DB' '=' dbName  |  'URL' '=' url  ) ',' 'USER' '=' user (',' 'PASSWORD' '=' password )?  (',' proerties)?')'
resourceName ::=
  identifier
hostname ::=
  string
port ::=
  int
dbName ::=
  string
url ::=
  string
user ::=
  string
password ::=
  string
proerties ::=
  PROPERTIES '(' property ( ',' property )* ')'
property ::=
  key '=' value
key ::=
  string
value ::=
  string

Supplement

• Before adding resources, please confirm that a database has been created in Proxy, and execute the use command to successfully select a database;
• Confirm that the added resource can be connected normally, otherwise it will not be added successfully;
• resourceName is case-sensitive;
• resourceName needs to be unique within the current database;
• resourceName name only allows letters, numbers and _, and must start with a letter;
• 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

• Add resource using standard mode

ADD RESOURCE ds_0 (
    HOST=127.0.0.1,
    PORT=3306,
    DB=db_0,
    USER=root,
    PASSWORD=root
);

• Add resource and set connection pool parameters using standard mode

ADD RESOURCE ds_1 (
    HOST=127.0.0.1,
    PORT=3306,
    DB=db_1,
    USER=root,
    PASSWORD=root,
    PROPERTIES("maximumPoolSize"=10)
);

• Add resource and set connection pool parameters using URL patterns

ADD RESOURCE ds_2 (
    URL="jdbc:mysql://127.0.0.1:3306/db_2?serverTimezone=UTC&useSSL=false",
    USER=root,
    PASSWORD=root,
    PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
);

Reserved word

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

Related links

• Reserved word