Oct 30, 2017

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

asadmin list-jdbc-connection-pools
i88_ca_pool

asadmin ping-connection-pool i88_ca_pool
Command ping-connection-pool executed successfully.

asadmin get resources.jdbc-connection-pool.i88_ca_pool.property
asadmin get resources.jdbc-connection-pool.i88_ca_pool.property.ServerName

asadmin set resources.jdbc-connection-pool.i88_ca_pool.property.ServerName=it.i88.ca
resources.jdbc-connection-pool.google_mysql.property.ServerName=i88_ca_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 i88_ca_pool
Command ping-connection-pool executed successfully.