[B! S2JDBC] katotakuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

katotaku id:katotaku

S2JDBCã«é–¢ã™ã‚‹katotakuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ã‚‚ã†ã²ã¨ã¤ã®åœ°çƒ
å¤©ä½¿ã®ã‚¹ã‚¿ã‚¹ã‚¿
katotaku 2009/06/10
S2JDBC

seasar
ãƒªãƒ³ã‚¯
CTOAæ—¥è¨˜:S2JDBCã®SQLãƒ•ã‚¡ã‚¤ãƒ«ã«å¤‰æ•°ã‚’ä½¿ã£ã¦SQLæ–‡ã‚’åŸ‹ã‚è¾¼ã‚€ - livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰
katotaku 2009/06/08
S2JDBC
ãƒªãƒ³ã‚¯
è»¢é€ä¸
katotaku 2009/04/20
seasar2

S2JDBC

mysql
ãƒªãƒ³ã‚¯
Dayanã®ãƒ–ãƒã‚° S2JDBCã‚’ä½¿ã£ã¦ã¿ã‚‹
å°è·ã¯ã€SEï¼ˆã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼‰ã‚’å°‚é–€ã¨ã—ã¦ãŠã‚Šã¾ã™ãŒã€æŠ€è¡“çš„ãªæƒ…å ±ã‚’ä¸å¿ƒã«ã€ãã‚Œä»¥å¤–ã«çµŒæ¸ˆé–¢é€£ã®æ—¥è¨˜ã€ãŸã‚ã„ã‚‚ãªã„æ—¥è¨˜ã‚‚è¼‰ã›ã¦ã„ãã¾ã™ã€‚ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ å…ˆæ—¥ã€J2EEå‹‰å¼·ä¼šã«å‡ºãŸã¨ãã«ã€ã¤ã„ã§ã«Seasarã®ã“ã¨ã«ã¤ã„ã¦ã‚‚ã„ã‚ã„ã‚ã¨èžã„ã¦ããŸã€‚ æ–°ã—ã„ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã¯ã€SAStruts + S2DAOã§è¡Œã“ã†ã¨æ€ã£ã¦ã„ãŸã®ã§ã™ãŒã€ä¸æ‘ã•ã‚“ï¼ˆtaediumã•ã‚“ï¼‰ã‹ã‚‰ã€é–¢é€£ã™ã‚‹ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’ä¸€ç·’ã«æŒã£ã¦ã“ã‚Œã‚‹S2JDBCã®æ–¹ãŒç”Ÿç”£æ€§ãŒé«˜ã„ã¨è¨€ã‚ã‚Œã€ã¾ãŸè‡ªå·±å‚ç…§ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚‚å¼•ã£å¼µã£ã¦ã“ã‚Œã‚‹ã¨èžã„ãŸã€‚ æ£ç›´ã€JPAè‡ªä½“ã‚ã¾ã‚Šå¥½ãã§ã¯ãªãã€æµã‚Œã‚‹ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã¨ã„ã£ã¦ã‚‚ã€ä½•ã‹æ“¬ä¼¼SQLã£ã½ã„ã‚³ãƒ¼ãƒ‰ã¨ã„ã†ã®ã¯ã©ã†ã‚‚ã¨ã„ã†å°è±¡ã‚’æŒã£ã¦ã„ãŸã€‚ãªã®ã§ã€LINQãªã‚“ã‹ã‚‚æ‡ç–‘çš„ãªç›®ã§è¦‹ã¦ã„ãŸã€‚Criteriaã¨ã„ã†ã®ã‚‚ã„ã¾ã„ã¡ã€‚ã©ã†ã›SQLã«ãƒžãƒƒãƒ”ãƒ³ã‚°ã•ã‚Œã‚‹ã‚“ã ã£ãŸã‚‰ã€SQLã§æ›¸ã„ãŸã‚‰ã¨æ€ã£ã¦ã„ãŸ
katotaku 2009/03/13
S2JDBC
ãƒªãƒ³ã‚¯
S2AbstractServiceã‚’ç”¨ã„ãŸAction-Service-Logicãƒ‘ã‚¿ãƒ¼ãƒ³ - å‡ºç¾½ãƒ–ãƒã‚°
ä»¥å‰ã«ã€Œ1.5éšŽå±¤ã®Action-Service-Logicãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã‚’ç´¹ä»‹ã•ã›ã¦é ‚ãã¾ã—ãŸã€‚ä»Šå›žã¯ã€ã“ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«S2AbstractService ã‚’å°Žå…¥ã—ãŸå ´åˆã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ã¤ã„ã¦æ¤œè¨Žã—ã¦ã¿ã¾ã—ãŸã€‚ ä¸»ãªå¤‰æ›´ç‚¹ã¨ã—ã¦ã€S2AbstractService ã‚’å°Žå…¥ã™ã‚‹å ´åˆã¯ã€ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒã‚¸ãƒƒã‚¯ã‹ã‚‰ç›´æŽ¥JdbcManagerã‚’ä½¿ã†ã“ã¨å¾—ç–ã§ã¯ãªã„ã¨è€ƒãˆã€ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚¸ãƒƒã‚¯ã¯å…¨ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµŒç”±ã™ã‚‹ã‚ˆã†ã«ãªã£ãŸç‚¹ã§ã™ã€‚ ã¾ãšã¯ã€ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å›³ç¤ºã—ãŸã‚‚ã®ã‚’ã”è¦§ãã ã•ã„ã€‚ç´°ã‹ã„è§£èª¬ã¯åˆ¥ã‚¨ãƒ³ãƒˆãƒªã«ã¦æ›¸ã‹ã›ã¦é ‚ãã¾ã™ãŒã€ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£å˜ä½ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æŽ¡ç”¨ã—ã¤ã¤ã‚‚ã€ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹å›ºæœ‰ã®ãƒã‚¸ãƒƒã‚¯ã¯ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã«è¨˜è¿°ã™ã‚‹æ–¹æ³•ã‚’æç¤ºã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ï¼ˆãƒ¬ã‚¤ãƒ¤æ§‹æˆå›³ï¼‰ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ï¼ˆãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ç›¸é–¢å›³ï¼‰
katotaku 2009/02/19
S2JDBC

SAStruts
ãƒªãƒ³ã‚¯
S2JDBCã§Hibernateã®iterate()ç›¸å½“ã®å‡¦ç† - taediumã®æ—¥è¨˜
S2Jdbc ã§1ä»¶ãšã¤ãƒ•ã‚§ãƒƒãƒã§ãã‚Œã°ã€ãã‚Œã§æ±ºå®šãªã®ã«ãªãã€‚ å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ã—ã¦å‡¦ç†ã—ãŸã„æ™‚ã«ã€Listã ã¨OutOfMemoryErrorãŒç™ºç”Ÿã•ã›ã¦ã—ã¾ã†å ´åˆãŒã‚ã‚‹ã€‚1è¡Œã¥ã¤ãƒ‡ãƒ¼ã‚¿ã‚’å–ã£ã¦ãã‚‹Iteratorã‚‚ã»ã—ã„æ°—ãŒã™ã‚‹ã€‚ä¾‹ãˆã°ã“ã‚“ãªæ„Ÿã˜ã€‚ S2JDBCã§Hibernateã®iterate()ã‚„scroll()ã®ã‚ˆã†ã«1ä»¶ãšã¤å‡¦ç†ã—ãŸã„å ´åˆã§ã™ãŒã€ãã†ã„ã†ã¨ãã¯æœ€åˆã«idã®ãƒªã‚¹ãƒˆã‚„é…åˆ—ã‚’å–å¾—ã—ã¦ã€ãã®ã‚ã¨1ä»¶ãšã¤å–å¾—ã—ã¦å‡¦ç†ã™ã‚‹ã¨ã„ã„ã¨æ€ã„ã¾ã™ã€‚ 1+Nã®SELECTãŒç™ºç”Ÿã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ‚ªã„ã‚“ã˜ã‚ƒã‚“ï¼Ÿã¨æ€ã†ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€S2JDBCã¯åŒã˜ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã§PreparedStatementã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ã„ã‚‹ã®ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯çµæ§‹ã„ã„ã§ã™ã€‚Nä»¶ã®SELECTã¯ã™ã¹ã¦åŒã˜PreparedStatementã§å‡¦ç†ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ã‚³ãƒ¼ãƒ‰ã¯ã“ã‚“ãªæ„Ÿã˜ã«ãªã‚Šã¾ã™ã€‚
katotaku 2007/12/20
seasar

S2JDBC
ãƒªãƒ³ã‚¯
1