Most JDBC drivers allow use of standard property lists to specify the user, password, and other resource configuration information. Although properties are optional with respect to the Payara Server, some properties might be necessary for most databases.
The following standard properties are common to many JDBC vendors.
passwordSpecifies the password for connecting to the database.
databaseNameSpecifies the database for this connection pool.
serverNameSpecifies the database server for this connection pool.
portSpecifies the port on which the database server listens for requests.
networkProtocolSpecifies the communication protocol.
roleNameSpecifies the initial SQL role name.
datasourceNameSpecifies an underlying XADataSource, or a ConnectionPoolDataSource if connection pooling is done.
descriptionSpecifies a text description.
urlSpecifies the URL for this connection pool. Although this is not a standard property, it is commonly used.