#i18n{module.jpa.hibernate.monitor.jmx.title}

#i18n{module.jpa.hibernate.monitor.jmx.status} <#if jmx_state> #i18n{module.jpa.hibernate.monitor.jmx.activated} <#else> #i18n{module.jpa.hibernate.monitor.jmx.notActivated}

<#if !jmx_state>

<#list list_stats as stat>

#i18n{module.jpa.hibernate.monitor.stats.pool} : ${stat.poolName} <#if stat.stats.statisticsEnabled> <#-- Uncomment when freemarker is upgrade to provide number_to_datetime

#i18n{module.jpa.hibernate.monitor.stats.startTime}: ${stat.stats.startTime?number_to_datetime}

-->

#i18n{module.jpa.hibernate.monitor.stats.sessions}

connectCount : ${stat.stats.connectCount?default("N/A")}

sessionCloseCount : ${stat.stats.sessionCloseCount?default("N/A")}

sessionOpenCount : ${stat.stats.sessionOpenCount?default("N/A")}

flushCount : ${stat.stats.flushCount?default("N/A")}

successfulTransactionCount : ${stat.stats.successfulTransactionCount?default("N/A")}

transactionCount : ${stat.stats.transactionCount?default("N/A")}

optimisticFailureCount : ${stat.stats.optimisticFailureCount?default("N/A")}

#i18n{module.jpa.hibernate.monitor.stats.entities}

entityDeleteCount : ${stat.stats.entityDeleteCount?default("N/A")}

entityLoadCount : ${stat.stats.entityLoadCount?default("N/A")}

entityFetchCount : ${stat.stats.entityFetchCount?default("N/A")}

entities : <#if stat.stats.entityNames?has_content> <#list stat.stats.entityNames as entity> <#assign entity_stats = stat.stats.getEntityStatistics(entity) />

${entity}
loadCount	${entity_stats.loadCount?default("N/A")}
fetchCount	${entity_stats.fetchCount?default("N/A")}
optimisticFailureCount	${entity_stats.optimisticFailureCount?default("N/A")}
insertCount	${entity_stats.insertCount?default("N/A")}
updateCount	${entity_stats.updateCount?default("N/A")}
deleteCount	${entity_stats.deleteCount?default("N/A")}

#i18n{module.jpa.hibernate.monitor.stats.queries}

queryExecutionCount : ${stat.stats.queryExecutionCount?default("N/A")}

queryExecutionMaxTime : ${stat.stats.queryExecutionMaxTime!?default("N/A")}

queryExecutionMaxTimeQueryString : ${stat.stats.queryExecutionMaxTimeQueryString?default("N/A")}

queries : <#if stat.stats.queries?has_content> <#list stat.stats.queries as query> <#assign query_stats = stat.stats.getQueryStatistics(query) />

${query}
executionCount	${query_stats.executionCount?default("N/A")}
executionAvgTime	${query_stats.executionAvgTime?default("N/A")}
executionMaxTime	${query_stats.executionMaxTime?default("N/A")}
cacheHitCount	${query_stats.cacheHitCount?default("N/A")}
cacheMissCount	${query_stats.cacheMissCount?default("N/A")}
cachePutCount	${query_stats.cachePutCount?default("N/A")}

<#else>

N/A

#i18n{module.jpa.hibernate.monitor.stats.cache}

queryCacheHitCount : ${stat.stats.queryCacheHitCount?default("N/A")}

queryCacheMissCount : ${stat.stats.queryCacheMissCount?default("N/A")}

queryCachePutCount : ${stat.stats.queryCachePutCount?default("N/A")}

secondLevelCacheHitCount : ${stat.stats.secondLevelCacheHitCount?default("N/A")}

secondLevelCacheMissCount : ${stat.stats.secondLevelCacheMissCount?default("N/A")}

secondLevelCachePutCount : ${stat.stats.secondLevelCachePutCount?default("N/A")}

<#if stat.stats.secondLevelCacheRegionNames?has_content> <#list stat.stats.secondLevelCacheRegionNames as region> <#assign region_stats=stat.stats.getSecondLevelCacheStatistics(region) />

Region	hitCount	missCount	putCount	elementCountInMemory	elementCountOnDisk	sizeInMemory
${region}	${region_stats.hitCount?default("N/A")}	${region_stats.missCount?default("N/A")}	${region_stats.putCount?default("N/A")}	${region_stats.elementCountInMemory?default("N/A")}	${region_stats.elementCountOnDisk?default("N/A")}	${region_stats.sizeInMemory?default("N/A")}

<#else> <#-- statistics disabled-->

#i18n{module.jpa.hibernate.monitor.stats.disabled}