Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private final ComboPooledDataSource dataSource = new ComboPooledDataSource(); //The connection pool
- @Override
- public void onEnable() {
- saveResource("c3p0-0.9.5.1.jar", true);
- saveResource("mchange-commons-java-0.2.10.jar", true);
- saveResource("mysql-connector-java-5.1.37-bin.jar", true);
- getConfig().options().copyDefaults(true);
- getConfig().addDefault("database.driver-class", "com.mysql.jdbc.Driver");
- getConfig().addDefault("database.jdbc-url", "jdbc:mysql://<host>:<port>/<database>");
- getConfig().addDefault("database.host", "localhost");
- getConfig().addDefault("database.port", "3306");
- getConfig().addDefault("database.database", "database");
- getConfig().addDefault("database.user", "user");
- getConfig().addDefault("database.password", "password");
- getConfig().addDefault("database.checkout-timeout", 5000);
- saveConfig();
- ConfigurationSection databaseSection = getConfig().getConfigurationSection("database");
- String driverClass = databaseSection.getString("driver-class");
- String jdbcUrl = databaseSection.getString("jdbc-url");
- String host = databaseSection.getString("host");
- String port = databaseSection.getString("port");
- String database = databaseSection.getString("database");
- String user = databaseSection.getString("user");
- String password = databaseSection.getString("password");
- int checkoutTimeout = databaseSection.getInt("checkout-timeout");
- try {
- dataSource.setDriverClass(driverClass);
- } catch (PropertyVetoException e) {
- e.printStackTrace();
- }
- dataSource.setJdbcUrl(jdbcUrl.replace("<host>", host).replace("<port>", port).replace("<database>", database));
- dataSource.setUser(user);
- dataSource.setPassword(password);
- dataSource.setCheckoutTimeout(checkoutTimeout);
- }
- @Override
- public void onDisable() {
- dataSource.close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement