bonecp.jdbcUrl=jdbc:mysql://localhost:3306/mydatabase bonecp.username=root bonecp.password=mypassword bonecp.minConnectionsPerPartition=5 bonecp.maxConnectionsPerPartition=20 bonecp.partitionCount=3 bonecp.acquireIncrement=5 bonecp.releaseHelperThreads=3 bonecp.connectionTimeout=5000 bonecp.idleMaxAgeMinutes=10 bonecp.idleConnectionTestPeriodMinutes=5 BoneCPConfig config = new BoneCPConfig(); config.setJdbcUrl("jdbc:mysql://localhost:3306/mydatabase"); config.setUsername("root"); config.setPassword("mypassword"); config.setMinConnectionsPerPartition(5); config.setMaxConnectionsPerPartition(20); config.setPartitionCount(3); config.setAcquireIncrement(5); config.setReleaseHelperThreads(3); config.setConnectionTimeoutInMillis(5000); config.setIdleMaxAgeInSeconds(600); config.setIdleConnectionTestPeriodInSeconds(300); BoneCP connectionPool = new BoneCP(config); Connection connection = connectionPool.getConnection(); Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM mytable"); rs.close(); stmt.close(); connection.close();