ÃֽŠ°Ô½Ã±Û(JAVA)
2016.11.03 / 10:12
BoneCP (Java database connection pool ) ¼³Á¤ ¹× »ç¿ë
±â¸®¾Æºü
Ãßõ ¼ö 496
Bonecp´Â dbcp, c3p0 ¸¦ ´ëüÇÏ´Â °í¼º´ÉÀÇ Java database connection pool ±¸Çö¹°.
»ç¿ëÁ¶°Ç
- JDK 1.5 ÀÌ»ó
- Google Guava library ÇÊ¿ä
- SLF4J logging library ÇÊ¿ä
¼³Á¤ °ª ¹× ¼º´É ÀÚ·á
¼³Á¤°ª
- partitionCount : Pool ¿¡¼ connection À» °¡Á®¿Ã¶§ lock °æÀïÀ» ÃÖ¼ÒÈÇϱâ À§ÇØ pool À» ¿©·¯ °³ ÆÄƼ¼ÇÀ¸·Î ³ª´¼ö ÀÖÀ½. ±âº»°ªÀº 1ÀÌ¸ç ³ôÀº ¼º´ÉÀÌ ÇÊ¿äÇÒ ¶§ 3~4 Á¤µµ Ãßõ
- maxConnectionsPerPartition: ÆÄƼ¼Çº° Connection ¼ö. Àüü Connection Àº partitionCount * maxConnectionsPerPartion ÀÌ µÊ.(3°³ ÆÄƼ¼ÇÀÌ ÀÖ°í maxConnectionsPerPartion ÀÌ 5¸é Àüü DB Connection Àº 15°¡ µÊ)
- acquireIncrement: ÆÄƼ¼Ç³» Connection ÀÌ ¸ðµÎ ¼Ò¸ðµÇ¾úÀ»¶§ ´Ã¸± Connection Count. ±âº»°ªÀº 10 À̸ç Àüü Count°¡ ¾Æ´Ï¶ó ÆÄƼ¼Çº° countÀÓ
¼º´É ºñ±³
WASÀÇ JNDI ·Î »ç¿ë
TOMCAT ¼³Á¤
JNDI ·Î »ç¿ë½Ã WAS ±¸µ¿½Ã BoneCP°¡ ÀÇÁ¸ÇÏ´Â library ¸¦ ã±â¶§¹®¿¡ WASÀÇ lib Æú´õ¿¡ ÀÇÁ¸¼ºÀÖ´Â library ¸¦ ³Ö¾î¾ß deploy ¹®Á¦ ¾øÀ½
- bonecp-0.8.0.RELEASE.jar
- guava-15.0.jar
- slf4j-log4j12-1.7.5.jar
- slf4j-api-1.7.5.jar
- log4j µî slf4j ¿¡ bindÇؼ »ç¿ëÇÏ´Â library
- releaseHelperThreads ´Â deprecated ÀÌ´Ù.
- IdleMaxAge ´ë½Å idleMaxAgeInMinutes ¸¦ ½á¾ß ÇÑ´Ù.
- idleConnectionTestPeriod ´ë½Å idleConnectionTestPeriodInMinutes ¸¦ ½á¾ß ÇÑ´Ù.
https://github.com/wwadge/bonecp/blob/master/bonecp/src/main/resources/bonecp-default-config.xml
tomcatÀÇ °æ¿ì Context.xml ¿¡ ResourceLink¸¦ Ãß°¡ÇØ Áà¾ß ÇÑ´Ù.
SpringÀÇ AppContext
Spring ÀÇ appContext¿¡¼ »ç¿ë
Application Context ¿¡ ´ÙÀ½ ³»¿ë Ãß°¡
maven pom.xml ¿¡ Ãß°¡
log4j ¼³Á¤
See Also