URL of the JDBC driver
The URL of the JDBC driver is the critical information that is required for applications to establish database connections by calling the Connection operation. The URL of the JDBC driver is usually used to specify the protocol for database connections. LindormTSDB is connected with the client by using the JDBC driver.
The following example shows the syntax of the URL of the JDBC driver:
jdbc:lindorm:tsdb:url=http://${host:port}[;${connection_parameter}=${connection_value}]...Parameters
Category | Parameter | Example | Description |
host:port | N/A | jdbc:lindorm:tsdb:url=http://ld-bp12pc23yfb3*****-proxy-tsdb-pub.lindorm.rds.aliyuncs.com:8242 | The endpoint and port used to connect to LindormTSDB. For more information about how to obtain the endpoint, see View endpoints. |
connection_parameter | username | root | The username that is used for authentication when you connect to LindormTSDB. Note If the user authentication feature is not enabled for LindormTSDB, you do not need to specify the username. For more information about how to enable the user authentication feature, see Enable the user authentication and permission verification feature. |
password | root | The password that is used for authentication when you connect to LindormTSDB. If you forget the password, you can change the password in the cluster management system of LindormTable. For more information, see Change the password. Note If the user authentication feature is not enabled for LindormTSDB, you do not need to specify the password. | |
database | default | The database to which you want to connect. If you do not specify this parameter, you are connected to the | |
lindorm.tsdb.driver.connect.timeout | 60 | The timeout period when the client tries to connect to the server of LindormTSDB. Unit: milliseconds. The default value is 60,000, which is equal to 60 seconds. | |
lindorm.tsdb.driver.socket.timeout | 60 | The timeout period for the interval of socket read and write requests. Unit: milliseconds. The default value is -1, which indicates that the interval does not time out. |
If a connection is idle for more than 90 seconds, the LindormTSDB server closes the connection to save resources. If you use the connection after the connection is closed, the com.aliyun.lindorm.client.shaded.org.apache.calcite.avatica.http.ConnectionDisconnectedException error is reported. To resolve the issue, you can establish a new connection.