io.datarouter.client.mysql.connection.C3p0StatsService Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of datarouter-mysql Show documentation

datarouter-mysql

There is a newer version: 0.0.125

/*
 * Copyright © 2009 HotPads ([email protected])
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package io.datarouter.client.mysql.connection;

import java.util.Arrays;
import java.util.List;
import java.util.Optional;
import java.util.stream.Collectors;

import javax.inject.Singleton;
import javax.management.JMException;
import javax.management.MalformedObjectNameException;
import javax.management.ObjectName;

import io.datarouter.util.MxBeans;
import io.datarouter.util.string.StringTool;

@Singleton
public class C3p0StatsService{

	public List getC3p0Stats(){
		ObjectName query;
		try{
			query = new ObjectName("com.mchange.v2.c3p0:type=PooledDataSource,*");
		}catch(MalformedObjectNameException e){
			throw new RuntimeException(e);
		}
		return MxBeans.SERVER.queryNames(query, null).stream()
				.>map(objectName -> {
						try{
							String jdbcUrl = (String)MxBeans.SERVER.getAttribute(objectName, "jdbcUrl");
							Optional clientName = extractClientName(jdbcUrl);
							if(clientName.isEmpty()){
								return Optional.empty();
							}
							int total = (int)MxBeans.SERVER.getAttribute(objectName, "numConnections");
							int busy = (int)MxBeans.SERVER.getAttribute(objectName, "numBusyConnections");
							return Optional.of(new C3p0StatsDto(clientName.get(), total, busy));
						}catch(JMException e){
							throw new RuntimeException(e);
						}
				})
				.flatMap(Optional::stream)
				.collect(Collectors.toList());
	}

	protected static Optional extractClientName(String jdbcUrl){
		String queryParams = StringTool.getStringAfterLastOccurrence('?', jdbcUrl);
		return Arrays.stream(queryParams.split("&"))
				.filter(part -> part.startsWith(MysqlConnectionPoolHolder.CLIENT_NAME_KEY))
				.findAny()
				.map(part -> part.substring(MysqlConnectionPoolHolder.CLIENT_NAME_KEY.length()));
	}

}