Advertisement
Guest User

Hikaricp

a guest
Oct 30th, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.92 KB | None | 0 0
  1. package com.eu.habbo.database;
  2.  
  3. import com.eu.habbo.core.ConfigurationManager;
  4. import com.zaxxer.hikari.HikariConfig;
  5. import com.zaxxer.hikari.HikariDataSource;
  6.  
  7. class DatabasePool
  8. {
  9.     private HikariDataSource database;
  10.  
  11.     public boolean getStoragePooling(ConfigurationManager config)
  12.     {
  13.         try
  14.         {
  15.             HikariConfig databaseConfiguration = new HikariConfig();
  16.             databaseConfiguration.setMaximumPoolSize(20);
  17.             databaseConfiguration.setInitializationFailFast(true);
  18.             databaseConfiguration.setJdbcUrl("jdbc:mysql://" + config.getValue("db.hostname", "localhost") + ":" + config.getValue("db.port", "3306")+ "/" + config.getValue("db.database", "habbo"));
  19.             databaseConfiguration.addDataSourceProperty("serverName", config.getValue("db.hostname", "localhost"));
  20.             databaseConfiguration.addDataSourceProperty("port", config.getValue("db.port", "3306"));
  21.             databaseConfiguration.addDataSourceProperty("databaseName", config.getValue("db.database", "habbo"));
  22.             databaseConfiguration.addDataSourceProperty("user", config.getValue("db.username"));
  23.             databaseConfiguration.addDataSourceProperty("password", config.getValue("db.password"));
  24.             databaseConfiguration.setAutoCommit(true);
  25.             databaseConfiguration.setConnectionTimeout(3400L);
  26.             databaseConfiguration.setLeakDetectionThreshold(90000L);
  27.             databaseConfiguration.setMaxLifetime(2874000L);
  28.             databaseConfiguration.setIdleTimeout(2874000L);
  29.             databaseConfiguration.setDriverClassName("com.mysql.jdbc.jdbc2.optional.MysqlDataSource");
  30.             this.database = new HikariDataSource(databaseConfiguration);
  31.         }
  32.         catch (Exception e)
  33.         {
  34.             return false;
  35.         }
  36.         return true;
  37.     }
  38.    
  39.     public HikariDataSource getDatabase()
  40.     {
  41.         return this.database;
  42.     }
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement