[B! jdbc] y93ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

y93 id:y93

jdbcã«é–¢ã™ã‚‹y93ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Commons DBCPã‚’è¶…ãˆã‚‹Tomcat JDBC Poolã¨ã¯
Commons DBCPã‚’è¶…ãˆã‚‹Tomcat JDBC Poolã¨ã¯ï¼šTomcat 7ã®æ–°æ©Ÿèƒ½ã§ä½•ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã®ã‹ï¼Ÿï¼ˆç•ªå¤–ç·¨ï¼‰ï¼ˆ1/2 ãƒšãƒ¼ã‚¸ï¼‰ Tomcatã®DBã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒ«ã¯2ã¤ã‚ã‚‹ ï¼ ITèªè€…ã®çš†ã•ã‚“ã¯ã€ŒTomcat JDBC Connection Poolã€ã‚’ã”å˜ã˜ã§ã™ã‹ï¼Ÿ é€šå¸¸ã€Tomcatã®DBã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒ«ã¨ã„ãˆã°Apache Commonsãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ã€ŒCommons DBCPã€ã‚’æƒ³åƒã™ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ã—ã‹ã—ã€Tomcatã«ã¯ã€ŒCommons DBCPã€ä»¥å¤–ã«ã‚‚DBã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒ«ã®å®Ÿè£…ãŒå˜åœ¨ã—ã¾ã™ã€‚ãã‚ŒãŒã€ã€ŒTomcat JDBC Connection Poolã€ï¼ˆä»¥ä¸‹ã€Tomcat JDBC Poolï¼‰ã§ã™ã€‚ Tomcat JDBC Poolã¨ã¯ã€Apache Tomcatãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒç‹¬è‡ªã«ä½œæˆã—ãŸDBã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒ«ã®å®Ÿè£…ã®ã“ã¨ã§ã™ã€‚
y93 2015/06/02
jdbc

java
ãƒªãƒ³ã‚¯
Oracle RACã§ã®ãƒžãƒ«ãƒãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚½ãƒ¼ã‚¹ã®ä½¿ç”¨
B Oracle RACã§ã®ãƒžãƒ«ãƒãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚½ãƒ¼ã‚¹ã®ä½¿ç”¨ ã“ã®ç« ã§ã¯ã€WebLogic Serverã§Oracle Real Application Clusters (RAC)ã‚’ä½¿ç”¨ã™ã‚‹éš›ã«ãƒžãƒ«ãƒãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚½ãƒ¼ã‚¹ã‚’æ§‹æˆã—ã¦ä½¿ç”¨ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚Oracleã¯ã€RACã‚’ä½¿ç”¨ã—ãŸãƒ¬ã‚¬ã‚·ãƒ¼ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç’°å¢ƒç”¨ã®ãƒžãƒ«ãƒãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚½ãƒ¼ã‚¹æ§‹æˆã‚’å¼•ãç¶šãã‚µãƒãƒ¼ãƒˆã—ã¾ã™ã€‚ Oracle Real Application Clustersã®æ¦‚è¦ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢è¦ä»¶ JDBCãƒ‰ãƒ©ã‚¤ãƒè¦ä»¶ ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢è¦ä»¶ Oracle RACã§ã®ãƒžãƒ«ãƒãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚½ãƒ¼ã‚¹ã®æ§‹æˆ ã‚°ãƒãƒ¼ãƒãƒ«ãƒ»ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã®ãƒžãƒ«ãƒãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚½ãƒ¼ã‚¹ã®ä½¿ç”¨ ã‚°ãƒãƒ¼ãƒãƒ«ãƒ»ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã—ãªã„å ´åˆã®ãƒžãƒ«ãƒãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚½ãƒ¼ã‚¹ã®ä½¿ç”¨ Oracle RACãƒŽãƒ¼ãƒ‰ä¸Šã®ã‚µãƒ¼ãƒ“ã‚¹ã«å¯¾ã™ã‚‹æŽ¥ç¶šã®æ§‹æˆ Oracle RACã§ãƒžãƒ«ãƒãƒ»ãƒ‡
y93 2015/05/25
oracle

jdbc
ãƒªãƒ³ã‚¯
Oracle JDBCãƒ‰ãƒ©ã‚¤ãƒãƒ—ãƒãƒ‘ãƒ†ã‚£ã®æ´»ç”¨
Oracle JDBCãƒ‰ãƒ©ã‚¤ãƒãƒ—ãƒãƒ‘ãƒ†ã‚£ã®æ´»ç”¨ 1. WebLogic Serverå‹‰å¼·ä¼šï¼ æ±äº¬LT Oracle JDBCãƒ‰ãƒ©ã‚¤ãƒãƒ—ãƒãƒ‘ãƒ†ã‚£ã®æ´»ç”¨ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚µãƒ¼ãƒ“ã‚¹æœ¬éƒ¨ ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã‚µãƒãƒ¼ãƒˆéƒ¨ å±±ç”° è²´è£• 2013/12/19 Copyright (c)2013 ITOCHU Techno-Solutions Corporation 2. ã¯ã˜ã‚ã« â€¢ ç™ºè¡¨ã™ã‚‹å†…å®¹ã¯å€‹äººã®è¦‹è§£ã§ã‚ã‚Šã€æ‰€å±žã™ã‚‹çµ„ç¹”ã®å…¬å¼ãªè¦‹è§£ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ â€¢ è³‡æ–™ã®å†…å®¹ã¯æ£ç¢ºã‚’æœŸã™ã‚‹ã‚ˆã†æ³¨æ„ã—ã¦ãŠã‚Šã¾ã™ãŒã€å¦¥å½“æ€§ã‚„ æ£ç¢ºæ€§ã«ã¤ã„ã¦ä¿è¨¼ã™ã‚‹ã‚‚ã®ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ â€¢ ç’°å¢ƒ â€“ åŸºæœ¬çš„ã«WebLogic Server (WLS) ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã¯ä¾å˜ã—ã¾ã›ã‚“ã€‚ â€¢ WLS 9.x ~ WLS 12c â€“ Oracle JDBC Thin Driverã®ã¿ â€¢ 10gä»¥é™ã®ãƒ‰ãƒ©ã‚¤ãƒ (11gä»¥é™ã®æœ€æ–°ã‚’æŽ¨å¥¨) â€¢ OC
y93 2015/05/23
oracle

jdbc

java
ãƒªãƒ³ã‚¯
Tomcatã¨Oracleé–“ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã«é–¢ã™ã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚° - æ—¥è¨˜ã®ã‚ˆã†ãªä½•ã‹
Tomcatã§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‚’ä½¿ç”¨ã—ã¦ã„ã¦ã€Tomcat <-> Oracleé–“ã®æŽ¥ç¶šãŒFINã‚„RSTãƒ‘ã‚±ãƒƒãƒˆã«ã‚ˆã‚‹é€šçŸ¥ãªã—ã«åˆ‡ã‚‰ã‚ŒãŸå ´åˆã€ãƒ—ãƒ¼ãƒ«ã—ã¦ã„ã‚‹æŽ¥ç¶šãŒå®Ÿéš›ã«ã¯æ»ã‚“ã§ã„ã‚‹çŠ¶æ…‹ãŒç™ºç”Ÿã™ã‚‹ã€‚ä¾‹ãˆã°ã€ä»¥ä¸‹ã®ã‚ˆã†ãªå ´åˆã«ç™ºç”Ÿã™ã‚‹ã€‚ APã‚µãƒ¼ãƒãƒ¼ <-> DBã‚µãƒ¼ãƒãƒ¼é–“ã®Firewallã«ã‚ˆã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³åˆ‡æ– DBã‚µãƒ¼ãƒãƒ¼ã®ãƒªãƒ–ãƒ¼ãƒˆ(Windows Server 2008ã®å ´åˆã€‚ä»–ã¯æœªç¢ºèª) ãªãŠã€Windows Server 2008ã§è©¦ã—ãŸé™ã‚Šã§ã¯Oracleã‚µãƒ¼ãƒ“ã‚¹ã®å†èµ·å‹•ã‚„shutdownã€startupã®å ´åˆã¯ç™ºç”Ÿã—ãªã‹ã£ãŸã€‚ãŠãã‚‰ãFINã¾ãŸã¯RSTãƒ‘ã‚±ãƒƒãƒˆãŒé£›ã‚“ã§ã„ã‚‹ã¨æ€ã‚ã‚Œã‚‹ã€‚ ä¸€åº¦ã€ã“ã®çŠ¶æ…‹ã«é™¥ã‚‹ã¨ã€ãã®å¾Œãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚„DBã‚µãƒ¼ãƒãƒ¼ãŒå¾©æ—§ã—ã¦ã‚‚æ»ã‚“ã æŽ¥ç¶šãŒãƒ—ãƒ¼ãƒ«ã«æ®‹ã‚Šç¶šã‘ã€ãã®æŽ¥ç¶šã‚’ä½¿ç”¨ã—ãŸTomcatã®ã‚¹ãƒ¬ãƒƒãƒ‰ã¯SQLã‚’å®Ÿè¡Œã™ã‚‹å‡¦ç†ã§Oracleã‹ã‚‰ã®å¿œç”ã‚’ãšã£ã¨å¾…
y93 2015/05/23
java

oracle

jdbc
ãƒªãƒ³ã‚¯
1