I can get some basic information from Glassfish v4 about the JDBC connection pool from the CLI with asadmin
:
thufir@dur:~$
thufir@dur:~$ glassfish-4.1/glassfish/bin/asadmin
Use "exit" to exit and "help" for online help.
asadmin>
asadmin> list-jdbc-connection-pools
CLI031: Warning: Option "target" is obsolete and will be ignored.
CLI031: Warning: Option "target" is obsolete and will be ignored.
__TimerPool
DerbyPool
SamplePool
connectionPool
legacy_on_glassfish
Command list-jdbc-connection-pools executed successfully.
asadmin>
asadmin> ping-connection-pool legacy_on_glassfish
Command ping-connection-pool executed successfully.
asadmin>
asadmin> list-jdbc-resources
jdbc/sample
jdbc/__TimerPool
jdbc/__default
jdbc/local
jdbc/legacy_resource
Command list-jdbc-resources executed successfully.
asadmin>
asadmin> exit
Command multimode executed successfully.
thufir@dur:~$
How do I get the full details, all the parameters of the connection, as through the web interface:
Also, where are the connection pool details stored?
see also:
https://glassfish.java.net/nonav/v3/admin/planning/j109/admin-cli.html#latestversion
https://glassfish.java.net/docs/4.0/administration-guide.pdf
JDBC resource
, via the CLI.