Can GlassFish dynamically manage the JDBC pool for me?

You should look at the Performance Tuner part of the GlassFish Enterprise manager. In particular see this documentation page.

Note the Enterprise manager is available to customers.