Database Structuring

Question

I would like to create a database connection pool.

Can someone tell me which data structure should be used to support the pool?

Answer 1

It should be implemented using the Object Pool desing pattern . You can read about it in Kircher, Michael; Prashant Jane; (2002-07-04). Pool Association. EuroPLoP 2002. Received 2007-06-09. or in the Object Pool Design Template . Java implementation for classes ObjectPooland JDBCConnectionPoolcan be found here .

singleton (, ) :

• - ,
• - ,

Lists HashTables - , . ObjectPool - LinkedList .

Answer 2

, , , ​​ Commons DBCP, .

Answer 3

. http://www.javaworld.com/jw-06-1998/jw-06-object-pool.html. !

Answer 4

:

• - "" Connection , , , , .. - , ,
• , , / - , ConcurrentLinkedQueue
• - Semaphore class
• , - " " (, "getConnection ( , readOnly)", ).

, /.

. , , , - () , () , , , .

Answer 5

, ?

. API Apache Database

Answer 6

. Sun: :

JDBC 2.0 , . JDBC 2.0 , JDBC-.

Answer 7

, .

c3p0 ( Hibernate)