HikariCP не получается установить пул.

[ScarlettDev]

Вообщем уже вторые сутки сижу туплю,как правильно должен составлен файл L2databaseFactory.
вот такая ситуация

Код:

Could not init database connection.

[Ashe]

Нет подключения к базе. Показывайте код.

[ScarlettDev]

:confused: установлено вроде бы правильно вот такая ситуация

[Ashe]

:confused: установлено вроде бы правильно вот такая ситуация

Код фабрики покажите.

[ScarlettDev]

Код:

public class L2DatabaseFactory
{
    protected static Logger _log = Logger.getLogger(L2DatabaseFactory.class.getName());

    private static HikariDataSource connectionPool;

    public static void doStart()
    {
        try
        {
            HikariConfig config = new HikariConfig();
            config.setMaximumPoolSize(100);
            config.setDataSourceClassName("com.mysql.jdbc.jdbc2.optional.MysqlDataSource");
            config.addDataSourceProperty("serverName", "localhost");
            config.addDataSourceProperty("port", "3306");
            config.addDataSourceProperty("databaseName", "mydb");
            config.addDataSourceProperty("user", "bart");
            config.addDataSourceProperty("password", "51mp50n");

            HikariDataSource ds = new HikariDataSource(config);

            _log.info("Database connection working.");
        }
        catch(final RuntimeException e)
        {
            _log.warning("Could not init database connection.");
        }
    }

    public static void doStop()
    {
        connectionPool.shutdown();
    }

    public static Connection getConnection()
    {
        try
        {
            return connectionPool.getConnection();
        }
        catch(final SQLException e)
        {
            _log.warning("Can't get connection from database");
        }

        return null;
    }

}

[WoWan-SM]

Вообщем уже вторые сутки сижу туплю,как правильно должен составлен файл L2databaseFactory.
вот такая ситуация

Код:

Could not init database connection.

https://forum.zone-game.info/showpost.ph...stcount=48

[ScarlettDev]

И даже с ним не получается делаю так

L2DatabaseFactory

Код:

public abstract class L2DatabaseFactory
{
    private static final Logger _log = Logger.getLogger(L2DatabaseFactory.class.getName());

    private static HikariDataSource connectionPool;

    public static void doStart()
    {
        try
        {
            HikariConfig config = new HikariConfig();
            config.setMaximumPoolSize(100);
            config.setDataSourceClassName("com.mysql.jdbc.jdbc2.optional.MysqlDataSource");
            config.addDataSourceProperty("serverName", "localhost");
            config.addDataSourceProperty("port", "3306");
            config.addDataSourceProperty("databaseName", "mydb");
            config.addDataSourceProperty("user", "bart");
            config.addDataSourceProperty("password", "51mp50n");

            connectionPool = new HikariDataSource(config);

            connectionPool.close();

            _log.info("Database connection working.");
        }
        catch(final RuntimeException e)
        {
            _log.warning("Could not init database connection.");
        }
    }

    public static void doStop()
    {
        connectionPool.shutdown();
    }

    public static Connection getConnection()
    {
        try
        {
            return connectionPool.getConnection();
        }
        catch(final SQLException e)
        {
            _log.warning("Can't get connection from database");
        }

        return null;
    }

}

его вызываю так в L2Pc например так

Использование

Код:

try (Connection con = L2DatabaseFactory.getConnection())
        {

Сейчас стали вот такие ошибки
в лс вроде бы всё нормально:

ЛС

Код:

---------------------------------------------------------------------=[  ]
Loading loginserver configuration files.
17:07:28.196 [main] INFO  com.zaxxer.hikari.HikariPool - HikariCP pool HikariPoo
l-0 is being shutdown.
17:07:28.196 [main] DEBUG com.zaxxer.hikari.HikariPool - State at shutdown Pool
stats HikariPool-0 (total=1, inUse=1, avail=0, waiting=0)
17:07:28.196 [main] INFO  com.zaxxer.hikari.HikariPool - HikariCP pool HikariPoo
l-0 is being shutdown.
17:07:28.196 [main] DEBUG com.zaxxer.hikari.HikariPool - State at shutdown Pool
stats HikariPool-0 (total=1, inUse=1, avail=0, waiting=0)
Database connection working.
----------------------------------------------------------=[ LoginController ]
Loading LoginController...
Cached 10 KeyPairs for RSA communication.
Stored 20 keys for Blowfish communication.
Loaded 127 server names.
Can't get connection from database
GameServerTable: Error loading registered game servers!
Loaded 0 registered gameserver(s).
Cached 10 RSA keys for gameserver communication.
-----------------------------------------------------------------=[ Ban List ]
Loaded 0 IP(s) from banned_ip.cfg.
-------------------------------------------------=[ IP, Ports & Socket infos ]
Listening for gameservers on *:9014
Loginserver ready on *:2106

Ну а в гс траблы вот такие:

Гс

Код:

---------------------------------------------------------------------=[  ]
Loading flood protectors.
Loading gameserver configuration files.
17:08:26.962 [main] INFO  com.zaxxer.hikari.HikariPool - HikariCP pool HikariPoo
l-0 is being shutdown.
17:08:26.962 [main] DEBUG com.zaxxer.hikari.HikariPool - State at shutdown Pool
stats HikariPool-0 (total=1, inUse=1, avail=0, waiting=0)
17:08:26.962 [main] INFO  com.zaxxer.hikari.HikariPool - HikariCP pool HikariPoo
l-0 is being shutdown.
17:08:26.962 [main] DEBUG com.zaxxer.hikari.HikariPool - State at shutdown Pool
stats HikariPool-0 (total=1, inUse=1, avail=0, waiting=0)
Database connection working.
Can't get connection from database
Exception in thread "main" java.lang.ExceptionInInitializerError
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:143)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:388)
Caused by: java.lang.NullPointerException
        at net.sf.l2j.gameserver.idfactory.IdFactory.setAllCharacterOffline(IdFa
ctory.java:81)
        at net.sf.l2j.gameserver.idfactory.IdFactory.<init>(IdFactory.java:69)
        at net.sf.l2j.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactor
y.java:45)
        at net.sf.l2j.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:60)

        ... 2 more

Server have terminated abnormaly.


Server terminated.

Для продолжения нажмите любую клавишу . . .

Что не так делаю то?

[JavaMan]

Убери connectionPool.close();

[ScarlettDev]

спасибо это уже понял,убрал всё хорошо но..

error

Код:

-------------------------------------------------------------------=[ Skills ]
17:45:52.724 [HikariCP connection filler] WARN  com.zaxxer.hikari.HikariPool - C
onnection attempt to database HikariPool-0 failed (not every attempt is logged):
Data source rejected establishment of connection,  message from server: "Too ma
ny connections"
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data sourc
e rejected establishment of connection,  message from server: "Too many connecti
ons"
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
~[na:1.7.0_21]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:57) ~[na:1.7.0_21]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45) ~[na:1.7.0_21]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:525) ~[na:
1.7.0_21]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connecto
r-java-5.1.26.jar:na]
        at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java
-5.1.26.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) ~[mysq
l-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) ~[mysql
-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) ~[mysql
-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1112) ~[mysql-connect
or-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486) ~
[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
519) ~[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304) ~
[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834) ~[mysql
-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysq
l-connector-java-5.1.26.jar:na]
        at sun.reflect.GeneratedConstructorAccessor6.newInstance(Unknown Source)
~[na:na]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45) ~[na:1.7.0_21]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:525) ~[na:
1.7.0_21]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connecto
r-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416) ~[
mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:346) ~[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlData
Source.java:443) ~[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlData
Source.java:141) ~[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlData
Source.java:111) ~[mysql-connector-java-5.1.26.jar:na]
        at com.zaxxer.hikari.HikariPool.addConnection(HikariPool.java:339) [Hika
riCP-1.3.6.jar:na]
        at com.zaxxer.hikari.HikariPool.access$300(HikariPool.java:52) [HikariCP
-1.3.6.jar:na]
        at com.zaxxer.hikari.HikariPool$1AddConnection.run(HikariPool.java:251)
[HikariCP-1.3.6.jar:na]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47
1) [na:1.7.0_21]
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [n
a:1.7.0_21]
        at java.util.concurrent.FutureTask.run(FutureTask.java:166) [na:1.7.0_21
]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145) [na:1.7.0_21]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615) [na:1.7.0_21]
        at java.lang.Thread.run(Thread.java:722) [na:1.7.0_21]
17:45:52.724 [HikariCP connection filler] WARN  com.zaxxer.hikari.HikariPool - C
onnection attempt to database HikariPool-0 failed (not every attempt is logged):
Data source rejected establishment of connection,  message from server: "Too ma
ny connections"
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data sourc
e rejected establishment of connection,  message from server: "Too many connecti
ons"
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
~[na:1.7.0_21]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:57) ~[na:1.7.0_21]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45) ~[na:1.7.0_21]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:525) ~[na:
1.7.0_21]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connecto
r-java-5.1.26.jar:na]
        at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java
-5.1.26.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) ~[mysq
l-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) ~[mysql
-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) ~[mysql
-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1112) ~[mysql-connect
or-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486) ~
[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
519) ~[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304) ~
[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834) ~[mysql
-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysq
l-connector-java-5.1.26.jar:na]
        at sun.reflect.GeneratedConstructorAccessor6.newInstance(Unknown Source)
~[na:na]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45) ~[na:1.7.0_21]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:525) ~[na:
1.7.0_21]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connecto
r-java-5.1.26.jar:na]
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416) ~[
mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:346) ~[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlData
Source.java:443) ~[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlData
Source.java:141) ~[mysql-connector-java-5.1.26.jar:na]
        at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlData
Source.java:111) ~[mysql-connector-java-5.1.26.jar:na]
        at com.zaxxer.hikari.HikariPool.addConnection(HikariPool.java:339) [Hika
riCP-1.3.6.jar:na]
        at com.zaxxer.hikari.HikariPool.access$300(HikariPool.java:52) [HikariCP
-1.3.6.jar:na]
        at com.zaxxer.hikari.HikariPool$1AddConnection.run(HikariPool.java:251)
[HikariCP-1.3.6.jar:na]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47
1) [na:1.7.0_21]
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [n
a:1.7.0_21]
        at java.util.concurrent.FutureTask.run(FutureTask.java:166) [na:1.7.0_21
]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145) [na:1.7.0_21]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615) [na:1.7.0_21]
        at java.lang.Thread.run(Thread.java:722) [na:1.7.0_21]
FishingSkillTreeTable: Loaded 109 general skills.
DwarvenCraftSkillTreeTable: Loaded 8 dwarven skills.
EnchantSkillTreeTable: Loaded 30 enchant types and 14430 enchant skills.
PledgeSkillTreeTable: Loaded 64 pledge skills.

[n3k0nation]

Уменьшайте количество коннектов в настройках сервера, либо увеличивайте в вашей базе данных, если это mysql, то в my.cfg