Сведения о пуле подключения JDBC к Glassfish
Я могу получить некоторую базовую информацию из Glassfish v4 о пуле соединений JDBC из CLI с 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:~$
Как получить полную информацию, все параметры соединения, как и через веб-интерфейс:
Также, где хранятся данные пула соединений?
см. также:
https: / /glassfish.java.net/nonav/v3/admin/planning/j109/admin-cli.html#latestversion
https://glassfish.java.net/nonav/v3/admin/ планирование / J109 / админ-cli.html # ПоследняяВерсия
1
задан Thufir
10 October 2014 в 14:43
поделиться
1 ответ
это работает:
asadmin>
asadmin> get domain.resources.jdbc-connection-pool.legacy_on_glassfish
domain.resources.jdbc-connection-pool.legacy_on_glassfish.allow-non-component-callers=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.associate-with-thread=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.connection-creation-retry-attempts=0
domain.resources.jdbc-connection-pool.legacy_on_glassfish.connection-creation-retry-interval-in-seconds=10
domain.resources.jdbc-connection-pool.legacy_on_glassfish.connection-leak-reclaim=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.connection-leak-timeout-in-seconds=0
domain.resources.jdbc-connection-pool.legacy_on_glassfish.connection-validation-method=table
domain.resources.jdbc-connection-pool.legacy_on_glassfish.datasource-classname=com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
domain.resources.jdbc-connection-pool.legacy_on_glassfish.deployment-order=100
domain.resources.jdbc-connection-pool.legacy_on_glassfish.fail-all-connections=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.idle-timeout-in-seconds=300
domain.resources.jdbc-connection-pool.legacy_on_glassfish.is-connection-validation-required=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.is-isolation-level-guaranteed=true
domain.resources.jdbc-connection-pool.legacy_on_glassfish.lazy-connection-association=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.lazy-connection-enlistment=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.match-connections=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.max-connection-usage-count=0
domain.resources.jdbc-connection-pool.legacy_on_glassfish.max-pool-size=32
domain.resources.jdbc-connection-pool.legacy_on_glassfish.max-wait-time-in-millis=60000
domain.resources.jdbc-connection-pool.legacy_on_glassfish.name=legacy_on_glassfish
domain.resources.jdbc-connection-pool.legacy_on_glassfish.non-transactional-connections=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.object-type=user
domain.resources.jdbc-connection-pool.legacy_on_glassfish.ping=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.pool-resize-quantity=2
domain.resources.jdbc-connection-pool.legacy_on_glassfish.pooling=true
domain.resources.jdbc-connection-pool.legacy_on_glassfish.res-type=javax.sql.ConnectionPoolDataSource
domain.resources.jdbc-connection-pool.legacy_on_glassfish.statement-cache-size=0
domain.resources.jdbc-connection-pool.legacy_on_glassfish.statement-cache-type=
domain.resources.jdbc-connection-pool.legacy_on_glassfish.statement-leak-reclaim=false
domain.resources.jdbc-connection-pool.legacy_on_glassfish.statement-leak-timeout-in-seconds=0
domain.resources.jdbc-connection-pool.legacy_on_glassfish.statement-timeout-in-seconds=-1
domain.resources.jdbc-connection-pool.legacy_on_glassfish.steady-pool-size=8
domain.resources.jdbc-connection-pool.legacy_on_glassfish.validate-atmost-once-period-in-seconds=0
domain.resources.jdbc-connection-pool.legacy_on_glassfish.wrap-jdbc-objects=true
Command get executed successfully.
asadmin>
в соответствии с:
https://serverfault.com/a/637457/132080
0
ответ дан Community
24 May 2018 в 03:00
поделиться