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