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

uxoru id:uxoru

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

${{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}}

S2JDBCã®iterate()ã§ OutOfMemoryError - ãƒã‚°æ—¥è¨˜
S2JDBCã‚’ä½¿ã£ã¦ DBã®ãƒ‡ãƒ¼ã‚¿æ•°åä¸‡ä»¶ã‚’ã¾ã¨ã‚ã¦DLã—ã‚ˆã†ã¨ã—ãŸã‚‰ã‚¨ãƒ©ãƒ¼ã«ãªã£ãŸã€‚ getResultList()ã˜ã‚ƒãªãã¦iterate()ä½¿ã£ãŸã‚‰çµæžœã‚’ã¾ã¨ã‚ã¦ä¿æŒã—ãªããªã‚‹ã‹ã‚‰ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã‚ãªããªã‚‹ã‚“ã˜ã‚ƒãªã„ã®ï¼Ÿã¨æ€ã£ãŸã‘ã©ãƒ€ãƒ¡ã€‚ Wicketã®ResourceStreamç³»ãŒã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ã‚‹ã®ã‹è‡ªåˆ†ã§æ›¸ã„ãŸã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ›¸ãå‡ºã™å‡¦ç†ãŒãƒŸã‚¹ã£ã¦ãŸã®ã‹ä½•ã‹ä½¿ã„æ–¹ãŒé–“é•ã£ã¦ãŸã®ã‹åˆ†ã‹ã‚‰ãšãƒãƒžã£ãŸã€‚ Eclipse Memory Analyzer ã§ãƒ€ãƒ³ãƒ—ã‚’è¦‹ãŸã‚‰ã€ã©ã“ã‹ã§ãƒ‡ãƒ¼ã‚¿ã‚’å…¨ä»¶ä¿æŒã—ã¦ã„ã‚‹æ¨¡æ§˜ã€‚ 2/29 ã“ã“ã‹ã‚‰è¿½è¨˜S2JDBC+PostgreSQLã ã¨s2jdbc.diconã®fetchSizeãƒ—ãƒãƒ‘ãƒ†ã‚£ã®è¨å®šï¼‹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ãã¡ã‚“ã¨é–‹å§‹ã™ã‚‹ã€ã§è§£æ±ºã—ãã†ã€‚(ã¨ã‚Šã‚ãˆãšãƒãƒ¼ã‚«ãƒ«ç’°å¢ƒã§ã‚¨ãƒ©ãƒ¼ã®å†ç¾ â†’ ã‚¨ãƒ©ãƒ¼ä¿®æ£ã®ç¢ºèªã¾ã§ã¯ã§ããŸ) PostgreSQL: http://o
uxoru 2020/08/14
postgresql

jdbc
ãƒªãƒ³ã‚¯
100ä¸‡ä»¶ãã‚‰ã„ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ‰±ã£ãŸã‚‰OOMEãŒå‡ºãŸè©±ã€‚ - è°·æœ¬ å¿ƒ in ã›ã‚éƒ¨å±‹
è¦ç´„ æŠ€è¡“çš„ãªè©±ã ã‘æ•™ãˆã¦ã€ã¨ã„ã†æ–¹ã®ãŸã‚ã«å…ˆã«çµè«–ã ã‘æ›¸ã„ã¦ãŠãã¾ã™ã¨ã€PostgreSQLã¯ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãŸæ™‚ç‚¹ã§å…¨ãƒ¬ã‚³ãƒ¼ãƒ‰ã®æƒ…å ±ã‚’ä¸€æ°—ã«èªã‚“ã§ãã¦ãƒ’ãƒ¼ãƒ—ã‚’åŸ‹ã‚ã¦ã—ã¾ã†å ´åˆãŒã‚ã‚‹ã€ã¨ã„ã†ã“ã¨è©±ã§ã™ã€‚ ãŸã¨ãˆã°ã€ResultSet#nextãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã„ãªãŒã‚‰å‡¦ç†ã‚’å›žã™ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã€å°‘ãªã„ãƒ’ãƒ¼ãƒ—ã§ã‚‚å‡¦ç†ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã®ã¯å¸¸å¥—æ‰‹æ®µã ã¨æ€ã„ã¾ã™ãŒã€ãã†ã„ã†ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã¦ã‚‚ä¸€æ°—ã«ãƒ’ãƒ¼ãƒ—ã‚’æ¶ˆè²»ã—ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚‹ã®ã§ã™ã€‚è©³ã—ãã¯ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’è¦‹ã¦ãã ã•ã„ã€‚ https://jdbc.postgresql.org/documentation/head/query.html#query-with-cursor ã“ã¨ã®ç™ºç«¯ ã¡ã‚‡ã£ã¨ä»•äº‹ã§Java + jOOQ + PostgreSQLã§ã€DBã®ãƒ‡ãƒ¼ã‚¿ã‚’é›†è¨ˆã™ã‚‹ã‚ˆã†ãªãƒãƒƒãƒå‡¦ç†ã‚’æ›¸ã„ã¦ã¾ã—ã¦ã€ã‚‚ã¡ã‚ã‚“ä¿ºæ§˜ã®æ›¸ã„ãŸã‚³ãƒ¼ãƒ‰ã«ãƒã‚°ãªã‚“ã¦ã‚ã‚‹
uxoru 2020/08/13
postgresql

jdbc
ãƒªãƒ³ã‚¯
ã€ãƒˆãƒ©ãƒ–ãƒ«å¤§æœæŸ»ç·šã€‘å¤±ã‚ã‚ŒãŸã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’è¿½ãˆï¼
ã€ãƒˆãƒ©ãƒ–ãƒ«å¤§æœæŸ»ç·šã€‘å¤±ã‚ã‚ŒãŸã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’è¿½ãˆï¼ï¼šç¾å ´ã‹ã‚‰å¦ã¶Webã‚¢ãƒ—ãƒªé–‹ç™ºã®ãƒˆãƒ©ãƒ–ãƒ«ãƒãƒƒã‚¯ï¼ˆ7ï¼‰ï¼ˆ3/3 ãƒšãƒ¼ã‚¸ï¼‰ ã€æœ€çµ‚è©±ã€‘ãã‚ŒãŒã€ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°å±‹ã®å‹™ã‚ ã‚¯ãƒãƒ¼ã‚ºæ¼ã‚Œã®å€‹æ‰€ã‚‚å¤§ä½“ã®è¦‹å½“ãŒä»˜ã„ãŸã®ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºãƒãƒ¼ãƒ ã«ç¢ºèªãƒ»ä¿®æ£ã‚’ä¾é ¼ã—ãŸã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç›´ã‚‹ã¾ã§ã®é–“ã€removeAbandonedã‚’ä»˜ã‘ãŸã¾ã¾ã§è² è·è©¦é¨“ã‚’ç¶™ç¶šã™ã‚‹ã“ã¨ã«ã—ãŸã€‚ç›®çš„ã¯removeAbandonedã®ã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ã‚’æ¸¬å®šã™ã‚‹ã“ã¨ã§ã‚ã‚‹ã€‚logAbandonedã‚’æŒ‡å®šã—ãªã‘ã‚Œã°stackTraceã¯ç”Ÿæˆã•ã‚Œãªã„ã€‚ãã®ãŸã‚ã€ã‚ã‚‹ç¨‹åº¦ã®æ€§èƒ½ã¯å‡ºã‚‹ã‚ˆã†ã«æ€ã‚ã‚ŒãŸã€‚ â– removeAbandonedã®åŒæœŸåŒ– ã—ã‹ã—ã€å®Ÿéš›ã«æ¸¬å®šã—ã¦ã¿ãŸã¨ã“ã‚ã€æ€ã£ãŸã‚ˆã†ã«æ€§èƒ½ã¯å‡ºãªã‹ã£ãŸã€‚CPUãŒã»ã¨ã‚“ã©ä½¿ã„åˆ‡ã‚Œãªã‹ã£ãŸã®ã ã€‚ ã“ã“ã¾ã§ããŸã‚‰ã€ã¤ã„ã§ã«è§£æžã—ã¦ã—ã¾ã†ã®ãŒã€ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°å±‹ã®å‹™ã‚ã ã‚ã†ã€‚è² è·
uxoru 2008/10/21
jdbc

DBCP

Java
ãƒªãƒ³ã‚¯
Log4J ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°å¯¾å¿œJDBCAppenderã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã™ã‚‹
ã¯ã˜ã‚ã« Apache Logging Services Projectã®Log4Jã¯ã€DBã«ãƒã‚°ã‚’å‡ºåŠ›ã™ã‚‹ãŸã‚ã®ã‚¯ãƒ©ã‚¹ã¨ã—ã¦JDBCAppenderã‚¯ãƒ©ã‚¹ã‚’ç”¨æ„ã—ã¦ã„ã¾ã™ã€‚ã“ã®ã‚¯ãƒ©ã‚¹ã¯ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã«å¯¾å¿œã—ã¦ã„ãªã„ãŸã‚ã€ãƒã‚°ã‚’å‡ºåŠ›ã™ã‚‹ãŸã³ã«ã€ŒDBã¸ã®æŽ¥ç¶šã€ã€ŒSQLå®Ÿè¡Œã€ã€ŒDBæŽ¥ç¶šã®ã‚¯ãƒãƒ¼ã‚ºã€ã‚’ç¹°ã‚Šè¿”ã—ã¾ã™ã€‚ãã®ãŸã‚ãƒã‚°ã®å‡ºåŠ›å›žæ•°ãŒå¢—ãˆã‚‹ã¨ã‚·ã‚¹ãƒ†ãƒ ã®è² è·ãŒé«˜ããªã£ã¦ã—ã¾ã„ã¾ã™ã€‚æœ¬ç¨¿ã§ã¯ã€JDBCAppenderã‚¯ãƒ©ã‚¹ã‚’æ‹¡å¼µã—ã¦ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã«å¯¾å¿œã•ã›ã‚‹ä¾‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚DBã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°æ©Ÿèƒ½ã¯ã€ŒJakarta commons DBCPã€ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ å¯¾è±¡èªè€… Javaã§ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã—ãŸã“ã¨ãŒã‚ã‚‹æ–¹ã‚’å¯¾è±¡ã¨ã—ã¾ã™ã€‚ å¿…è¦ãªç’°å¢ƒ J2SE5.0 Log4J 1.2.11 Jakarta Commons DBCP 1.2.1 Jakarta Commons Pool
uxoru 2008/10/21
log4j

jdbc

DBCP

Java
ãƒªãƒ³ã‚¯
Huge Database problem - ChemAxon Forum Archive
uxoru 2008/06/12
ã“ã‚Œã‚‚ã‚¢ãƒ—ãƒªã®OutOï½†Memoryâ†’"org.postgresql.util.PSQLException: Ran out of memory retrieving query results. "

Java

postgresql

jdbc
ãƒªãƒ³ã‚¯
pgpool-II 2.0.1ã¨jdbcã©ã‚‰ã„ã° - ä¼¼éžã€€ï¼ã€€è·¡åœ°
uxoru 2008/04/11
pgpool

jdbc
ãƒªãƒ³ã‚¯
Tomcat 5.0.* ç³»ã§ã® DataSource ( ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ ) ã®åˆ©ç”¨ - Context ãƒ•ã‚¡ã‚¤ãƒ« ç·¨-
æœ¬ãƒšãƒ¼ã‚¸ã§ã®ä½¿ç”¨ç’°å¢ƒ OSï¼šWindows XP SP 2 ( Linux ç³» OS ã®å ´åˆã‚‚æœ¬ãƒšãƒ¼ã‚¸ã¨æ‰‹é †ã¯åŒæ§˜ã§ã™ã€‚ ) Javaï¼šJDK 5.0 UPDATE 8 Tomcatï¼š5.0.28 ã“ã“ã§ã¯ã€JDK 5.0 UPDATE 8 ã€Tocmat 5.0.28 ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’å‰æã¨ã—ã¦èª¬æ˜Žã„ãŸã—ã¾ã™ã€‚ ã“ã‚Œã‚‰ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¤ã„ã¦ã¯ä¸‹è¨˜ã®ãƒšãƒ¼ã‚¸ã‚’å‚ç…§ãã ã•ã„ã€‚ JDK ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« -Windows ç·¨- Tomcat 5.0.* ç³»ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - Windows ç·¨ ( exe , zip ãƒ•ã‚¡ã‚¤ãƒ« ) - * ã“ã“ã§ã¯ zip ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ç”¨ã—ã¦ C:/jakarta-tomcat-5.0.28 ã« Tomcat ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå‰æã¨ã—ã¾ã™ã€‚ CATALINA_HOME ã¯ã€C:/jakarta-tomcat-5.0.28 ã§ã™ã€‚
uxoru 2007/09/21
Java

jdbc

DBCP
ãƒªãƒ³ã‚¯
Jakarta Commons DBCP
uxoru 2007/09/21
Java

jdbc

DBCP
ãƒªãƒ³ã‚¯
dfltweb1.onamae.com â€“ ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ãŠåå‰.comã§å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚
ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ ãŠåå‰.com ã‹ã‚‰å–å¾—ã•ã‚Œã¾ã—ãŸã€‚ ãŠåå‰.com ã¯ GMOã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚°ãƒ«ãƒ¼ãƒ—(æ ª) ãŒé‹å–¶ã™ã‚‹å›½å†…ã‚·ã‚§ã‚¢No.1ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ç™»éŒ²ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ â€»è¡¨ç¤ºä¾¡æ ¼ã¯ã€å…¨ã¦ç¨Žè¾¼ã§ã™ã€‚ â€»ã‚µãƒ¼ãƒ“ã‚¹å“è³ªç¶æŒã®ãŸã‚ã€ä¸€æ™‚çš„ã«å¯¾è±¡ã¨ãªã‚‹æ–™é‡‘ã¸ä¸€å®šå‰²åˆã®ã€Œã‚µãƒ¼ãƒ“ã‚¹ç¶æŒèª¿æ•´è²»ã€ã‚’åŠ ç®—ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚
uxoru 2007/09/21
Java

jdbc

DBCP
ãƒªãƒ³ã‚¯
ï¼ ITï¼šç¾å ´ã«æ´»ã‹ã™Jakarta Project ç¬¬6å›ž DBã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚’ç°¡å˜ã«å®Ÿç¾ã™ã‚‹
ä»Šå›žã‚‚ã€å‰å›žã€ŒCommonsã§ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‚’å®Ÿç¾ã€ã«å¼•ãç¶šãCommonsãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®æ´»ç”¨æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚å‰å›žã¯Poolã‚’åˆ©ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‚’å®Ÿç¾ã—ã¾ã—ãŸã€‚ä»Šå›žã¯DBCPã‚’ç”¨ã„ã¦ã€ã‚ˆã‚Šå®¹æ˜“ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‚’å®Ÿç¾ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ãªãŠã€ã“ã®åŽŸç¨¿åŸ·ç†æ™‚ç‚¹ã§ã®DBCPã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯1.0ã§ã™ã€‚ PoolingDriverã‚¯ãƒ©ã‚¹ã¨PoolingDataSourceã‚¯ãƒ©ã‚¹ é€šå¸¸JDBCã‚’ç”¨ã„ãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã§ã¯Connectionã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆï¼ˆjava.sql.Connectionï¼‰ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¾ã™ãŒã€Connectionã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’å–å¾—ã™ã‚‹ã«ã¯Driverã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆï¼ˆjava.sql.Driverï¼‰ã‚„DataSourceã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆï¼ˆjavax.sql.DataSourceï¼‰ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚DBC
uxoru 2007/09/20
Java

jdbc

DBCP
ãƒªãƒ³ã‚¯
2007-09-19
å‰å›žã«å¼•ãç¶šã„ã¦TextFieldãƒã‚¿ã‚’ã€‚ TextFieldWithHistory/TextFieldWithStoredHistoryã‚¯ãƒ©ã‚¹ã¨PropertiesComponentã‚¯ãƒ©ã‚¹ å±¥æ´æ©Ÿèƒ½ä»˜ããƒ†ã‚ã‚¹ãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã£ã¦ã®ã¯ï¼Œ...WithHistoryã‹ã‚‰å¯Ÿã™ã‚‹ã“ã¨ãŒã§ãã‚ˆã†ã€‚WithStoredHistoryã‚„PropertiesComponentã«ã¤ã„ã¦ã¯ï¼ŒãŠã„ãŠã„èª¬æ˜Žã™ã‚‹ã¨ã—ã¦ï¼Œã¾ãšã¯å¤–è¦³ã‚’ã”æŠ«éœ²ã€‚ ã“ã‚Œã‚‚ã‚ãƒ£ãƒ—ã‚·ãƒ§ãƒ³éƒ¨åˆ†ã¯JPanelã€‚å·¦ã®TextFieldWithHistoryã«ã€Œ...ã€ãƒœã‚¿ãƒ³ãŒä»˜ã„ã¦ã„ã‚‹ãŒï¼Œã“ã‚Œã¯å¾Œä»˜ã‘ã—ãŸã‚‚ã®ã§ï¼ŒTextFieldWithHistory/TextFieldWithHistoryå˜ä½“ã§ã®å¤–è¦³ã¯å³å´ã®ãªã‚“ã‹ã‚¢ã‚¤ã‚³ãƒ³ãŒä»˜ã„ã¦ã‚‹ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒãã†ã€‚ è¦‹ãŸç›®ã‹ã‚‰æ©Ÿèƒ½ã¯æŽ¨æ¸¬ã§ãã‚ˆã†ã€‚ã“ã‚“ãªå…·åˆã«å…¥åŠ›å±¥æ´ã‚’ä¿å˜ã§ãã‚‹ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒï¼ŒTe
uxoru 2007/09/20
Java

oracle

jdbc
ãƒªãƒ³ã‚¯
java:jdbc [paulownia.jp]
JDBC URLã®ãƒãƒ¼ãƒˆç•ªå·ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒãƒ¼ãƒˆç•ªå·ã§ã™ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã€å¤šãã®ãƒ‰ãƒ©ã‚¤ãƒã§ã¯URLã®ãƒãƒ¼ãƒˆç•ªå·ã‚’çœç•¥ã§ãã¾ã™ã€‚ ã“ã“ã«æŽ²è¼‰ã—ã¦ã„ã‚‹æƒ…å ±ã¯åŸºæœ¬çš„ã«RDBMSãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ»ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆå…¬å¼ã®ãƒ‰ãƒ©ã‚¤ãƒã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®è¨å®šã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã£ã¦ã¯ã‚µãƒ¼ãƒ‰ãƒ‘ãƒ¼ãƒ†ã‚£ã‚„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã‚‹ãƒ‰ãƒ©ã‚¤ãƒãŒå˜åœ¨ã—ã¾ã™ã€‚
uxoru 2007/09/10
ãƒ‰ãƒ©ã‚¤ãƒã‚¯ãƒ©ã‚¹&æŽ¥ç¶šURL

Java

jdbc
ãƒªãƒ³ã‚¯
hellohiro.com
DOMAIN SALE CLICK HERE TO BUY NOW +1 855-646-1390
uxoru 2007/07/08
tomcat

jndi

jdbc

Java
ãƒªãƒ³ã‚¯
DbUtilsã§çµæžœã‚»ãƒƒãƒˆã‚’JavaBeansã«ãƒžãƒƒãƒ”ãƒ³ã‚°ã™ã‚‹
åŸºæœ¬çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹æ–¹æ³•ã®å•é¡Œ Javaã‹ã‚‰ä¸€èˆ¬çš„ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨å‘¼ç§°ï¼‰ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã«ã¯ã€ä»¥ä¸‹ã«ç¤ºã™ã‚ˆã†ã«java.sqlãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®Connectionã€Statementã€ResultSetã‚’ä½¿ã†ã®ãŒåŸºæœ¬ã§ã™ã€‚ InitialContextÂ initÂ =Â newÂ InitialContext(Â ); DataSourceÂ dsÂ =Â (DataSource)init.lookup("java:comp/env/jdbc/TestDB"); ConnectionÂ conÂ =Â ds.getConnection(); StatementÂ stÂ =Â con.createStatement(); ResultSetÂ rsÂ =Â st.executeQuery("selectÂ *Â fromÂ it ems;"); â€¦â€¦// rsã‹ã‚‰çµæžœã‚’å–å¾— rs.close(
uxoru 2007/05/11
DbUtils

Java

JDBC
ãƒªãƒ³ã‚¯
Oracleã¨J2SE5ã§è‡´å‘½çš„ãªãƒã‚° - minghaiã®æ—¥è¨˜
02/22 ã¾ã ã“ã®è¨˜äº‹ã‚’è¦‹ã«æ¥ã‚‹äººãŒå¤šã„ã®ã§1ã¤è¿½åŠ ã€‚ ãƒ‘ãƒƒãƒã®ãƒªãƒªãƒ¼ã‚¹äºˆå®šæ—¥ã¯2007å¹´8æœˆã¨ã®ã“ã¨ã€‚ What effect does Oracle/Java5 bug have for comp... |Â Oracle Community Support just got back to me and told me: that a fix for this issue will be available in 10.2.0.4.0 JDBC Driver which is scheduled for august 2007. 01/12ã€€ä¿®æ£æƒ…å ±ãŒæŠ•ç¨¿ã•ã‚Œã¾ã—ãŸã€‚ http://forums.oracle.com/forums/thread.jspa?forumID=99&threadID=461701 ã¾ã è½ã¨ã›ã¾ã›ã‚“ãŒã€è¿‘ã„ã†ã¡ã«OTNã«æŠ•ç¨¿ã•ã‚Œã‚‹ã§ã‚ã‚ã†ã€ãƒ‰ãƒ©ã‚¤ãƒ10.2.
uxoru 2007/01/13
ã‚“ï¼ä»Šã®ä»•äº‹ã«é–¢é€£ã™ã‚‹ã‹ã‚‰ã¡ã‚ƒã‚“ã¨èªã‚€ã€‚

Java

Oracle

JDBC

ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
1