Example To Update / Ping a JDBC Connection Pool in Oracle GlassFish / Payara Server

asadmin list-jdbc-connection-pools
goyun.info_pool

asadmin ping-connection-pool goyun.info_pool
Command ping-connection-pool executed successfully.

asadmin get resources.jdbc-connection-pool.goyun.info_pool.property
asadmin get resources.jdbc-connection-pool.goyun.info_pool.property.ServerName

asadmin set resources.jdbc-connection-pool.i88_ca_pool.property.ServerName=it.goyun.info
resources.jdbc-connection-pool.google_mysql.property.ServerName=goyun.info_pool
Command set executed successfully.

(Optional) If needed, restart the server.
Some parameters require server restart. Changing ServerName, User, Password does not need to restart the server.

asadmin ping-connection-pool goyun.info_pool
Command ping-connection-pool executed successfully.

Comments

Popular posts from this blog

Check MySQL query history from command line

Installing chocolatey on Windows