BoneCP Manual Configuration

Manual setup of the connection pool is via the use of the BoneCPConfig class as per the following example (exception handling omitted for clarity):

 
	Class.forName("org.hsqldb.jdbcDriver"); 	// load the DB driver
 	BoneCPConfig config = new BoneCPConfig();	// create a new configuration object
 	config.setJdbcUrl("jdbc:hsqldb:mem:test");	// set the JDBC url
	config.setUsername("sa");			// set the username
	config.setPassword("");				// set the password
	
	config.setXXXX(...);				// (other config options here)
	
	BoneCP connectionPool = new BoneCP(config); 	// setup the connection pool
	
	Connection connection;
	connection = connectionPool.getConnection(); 	// fetch a connection
	
	...  do something with the connection here ...
	
	connection.close();				// close the connection
	connectionPool.shutdown();			// close the connection pool