Help HikariCP-3.2.0 in aCis 370

[Williams]

Hello removed c3p0 from my acis and having problems

 

 

I'm using these calls

 

package net.sf.l2j;

import java.sql.Connection;
import java.util.logging.Logger;

import com.zaxxer.hikari.HikariDataSource;

public class L2DatabaseFactory
{
	private static final Logger LOGGER = Logger.getLogger(L2DatabaseFactory.class.getName());
	
	private static final HikariDataSource _hds = new HikariDataSource();
	
	public static void init()
	{
		_hds.setDriverClassName("com.mysql.cj.jdbc.Driver");
		_hds.setJdbcUrl(Config.DATABASE_URL);
		_hds.setUsername(Config.DATABASE_LOGIN);
		_hds.setPassword(Config.DATABASE_PASSWORD);
		_hds.setMaximumPoolSize(Config.DATABASE_MAX_CONNECTIONS);
		_hds.setConnectionTimeout(600000);
		_hds.setIdleTimeout(1200000);
		_hds.setMaxLifetime(1200000);
		
		// Test if connection is valid.
		try
		{
			_hds.getConnection().close();
			LOGGER.info("Database: Initialized.");
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static Connection getConnection()
	{
		Connection con = null;
		while (con == null)
		{
			try
			{
				con = _hds.getConnection();
			}
			catch (Exception e)
			{
				LOGGER.severe("DatabaseFactory: Cound not get a connection. " + e);
			}
		}
		return con;
	}
	
	public static void shutdown()
	{
		try
		{
			_hds.close();
		}
		catch (Exception e)
		{
			LOGGER.severe("DatabaseFactory: There was a problem closing the data source. " + e);
		}
	}
}

        

Edited July 27, 2019 by Williams

[Williams]

Solved topic may close please