C3P0 Connection Pool Monitoring

This section describes the types, names, and meanings of C3P0 connection pool metrics collected by APM.

**Table 1** Collection parameters for C3P0 connection pool monitoring
Parameter	Data Type	Application Type	Default	Supported Start Agent Version	Supported End Agent Version	Description
Threshold (ms) for Reporting Connection Trace	integer	JAVA	1	2.1.3	-	Threshold for reporting getConnection method traces. If the threshold is not exceeded, such traces will not be reported.
Obtain Pool Info or Not	radio	JAVA	false	2.1.3	-	Whether to obtain pool information when getting connections

**Table 2** C3P0 connection pool metrics
Category	Metric	Name	Description	Unit	Data Type	Default Aggregation Mode
Data source (dataSource)	url	URL	URL	-	ENUM	LAST
	driverClass	Driver	Driver	-	STRING	LAST
	initialPoolSize	initialPoolSize	Number of initialized connections	-	INT	LAST
	minPoolSize	minPoolSize	Minimum connection pool size	-	INT	LAST
	maxPoolSize	maxPoolSize	Maximum connection pool size	-	INT	LAST
	numIdleConnections	numIdleConnections	Number of idle connections	-	INT	LAST
	numBusyConnections	numBusyConnections	Number of busy connections	-	INT	LAST
	numConnections	numConnections	Total number of connections	-	INT	LAST
	maxIdleTime	maxIdleTime	Maximum connection idle time	-	INT	LAST
	idleConnectionTestPeriod	idleConnectionTestPeriod	Interval for checking for idle connections	-	INT	LAST
	testConnectionOnCheckout	testConnectionOnCheckout	Connection validity check during check-out	-	STRING	LAST
	testConnectionOnCheckin	Connection Validity Check During Check-In	Connection validity check during check-in	-	STRING	LAST
	acquireRetryAttempts	Connection Retries	Number of Connection retry times	-	INT	LAST
	acquireRetryDelay	Connection Retry Interval	Connection retry interval	-	INT	LAST
	acquireIncrement	Connections Created If No Connection Exists	Number of connections created if no connection exists	-	INT	LAST
Connection details (connection)	url	Connection Address	Connection address	-	ENUM	LAST
	invokeCount	Calls	Number of calls	-	INT	LAST
	totalTime	Total Time	Total time	-	INT	LAST
	errorCount	Errors	Number of errors	-	INT	SUM
	maxTime	Max. RT	Maximum response time	-	INT	SUM
	range1	0–10 ms	Number of requests with 0–10 ms response time	-	INT	SUM
	range2	10–100 ms	Number of requests with 10–100 ms response time	-	INT	SUM
	range3	100–500 ms	Number of requests with 100–500 ms response time	-	INT	SUM
	range4	500–1000 ms	Number of requests with 500–1000 ms response time	-	INT	SUM
	range5	1–10s	Number of requests with 1–10s response time	-	INT	SUM
	range6	> 10s	Number of requests with response time longer than 10s	-	INT	SUM
	concurrentMax	Max. Concurrency	Maximum concurrency	-	INT	MAX
Version (version)	version	Version	Version	-	STRING	LAST
Exception (exception: C3P0 call exception statistics)	exceptionType	Exception Type	Exception type	-	ENUM	LAST
	causeType	Exception Class	Exception class	-	ENUM	LAST
	count	Count	Number of times the exception has occurred	-	INT	SUM
	message	Exception Message	Message returned when the exception occurred	-	STRING	LAST
	stackTrace	Exception Stack	Exception stack information	-	CLOB	LAST