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

hiro360 id:hiro360

jdbcã«é–¢ã™ã‚‹hiro360ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

2WaySQLãŒä½¿ãˆã‚‹DBã‚¢ã‚¯ã‚»ã‚¹ãƒ©ã‚¤ãƒ–ãƒ©ãƒª - ãŸã‘ãžã†ç€•æ»ãƒ–ãƒã‚°
Javaã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã¯ã€ãƒ•ãƒãƒ³ãƒˆéƒ¨åˆ†ã¯ã„ã„ã‚‚ã®ãŒã„ã‚ã„ã‚ã‚ã‚‹ã¨æ€ã†ã®ã§ã™ãŒã€DBã‚¢ã‚¯ã‚»ã‚¹å‘¨ã‚Šã¯Hibernateã‚‚iBatisã‚‚æ£ç›´å¾®å¦™ã§ã€ã“ã‚ŒãŒæ±ºå®šç‰ˆï¼ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ å€‹äººçš„ã«ã¯S2JDBCãŒä½¿ã„ã‚„ã™ã„ã¨æ€ã†ã®ã§ã™ãŒã€Seasar2ã«ä¾å˜ã—ã¦ã„ã¾ã™ï¼ˆå®Ÿéš›ã«ã¯S2Containerã‚’ä½¿ã‚ãªãã¦ã‚‚å‹•ã‹ã›ã¾ã™ãŒã€Seasar2ã®ä¾å˜JARãŒå¿…è¦ã«ãªã‚Šã¾ã™ã—ã€ç¾å®Ÿå•é¡Œã¨ã—ã¦S2Containerã‚’ä½¿ã‚ãªã„ã‚±ãƒ¼ã‚¹ã§ã‚ã‚Œã°S2JDBCãŒå€™è£œã«æŒ™ãŒã‚‹ã“ã¨ã‚‚ã¾ãšãªã„ã§ã—ã‚‡ã†ï¼‰ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€S2JDBCã®2WaySQLãŒä½¿ãˆã‚‹DBUtilsçš„ãªã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½œã‚Šå§‹ã‚ã¾ã—ãŸã€‚ ä½¿ã„æ–¹ã¯ã“ã‚“ãªæ„Ÿã˜ã€‚JdbcManagerã®ä»£ã‚ã‚Šã«SqlManagerã¨ã„ã†ã‚¯ãƒ©ã‚¹ã‚’ä½¿ã„ã¾ã™ã€‚ã¾ãŸã€æµã‚Œã‚‹ã‚ˆã†ãªã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã¯ä½¿ã‚ãšã€ãƒ¡ã‚½ãƒƒãƒ‰å‘¼ã³å‡ºã—ä¸€ç™ºã§çµæžœãŒè¿”ã£ã¦ãã‚‹ã‚ˆã†ã«ã—
hiro360 2010/04/19
java

orm

jdbc
ãƒªãƒ³ã‚¯
JDBCã€S2JDBCã€S2Daoã€JPAï¼ˆHibernateï¼‰ã€Domaã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ ãã®3 - taediumã®æ—¥è¨˜
S2JDBCãŒãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ãŸã¨ã„ã†ã“ã¨ãªã®ã§ã€ã‚‚ã†ä¸€åº¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚æ¸¬å®šæ–¹æ³•ã¯å‰å›žã¨åŒæ§˜ã€1ãƒ—ãƒã‚»ã‚¹å†…ã§åŒã˜å‡¦ç†ã‚’3å›žå®Ÿè¡Œã—ã¦æœ€å¾Œã®å€¤ã‚’å–ã‚‹ï¼ˆæœ€é©åŒ–ã•ã‚ŒãŸçŠ¶æ…‹ã§è¨ˆæ¸¬ã™ã‚‹ãŸã‚ã«ï¼‰ã€ã¨ã„ã†ã“ã¨ã‚’ãã‚Œãžã‚Œã®ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ã§3å›žå®Ÿè¡Œã—ã¦çœŸã‚“ä¸ã®å€¤ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ ã‚³ãƒ¼ãƒ‰ã‚„ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯ãƒªãƒã‚¸ãƒˆãƒªã«ã‚ã‚Šã¾ã™ã€‚ https://www.seasar.org/svn/sandbox/doma/trunk/or-mapper-benchmark/ SQLãƒ•ã‚¡ã‚¤ãƒ«ã«è¨˜è¿°ã•ã‚ŒãŸSELECTæ–‡ã‚’ä½¿ã£ã¦10000ä»¶æ¤œç´¢ 19,364,522 (nanoTime) : Doma SqlFileSelectDtoTest 39,396,294 (nanoTime) : S2DaoSqlFileSelectDtoTest 12,013,783 (nanoTime) : S2J
hiro360 2010/01/12
seasar

java

performance

orm

jdbc

hibernate

s2dao

s2jdbc
ãƒªãƒ³ã‚¯
JDBCã€S2JDBCã€S2Daoã€JPAï¼ˆHibernateï¼‰ã€Domaã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ ãã®2 - taediumã®æ—¥è¨˜
å‰å›žã«ã¤ã¥ã„ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚ãŸã ã—ã€å‰å›žã¨æ¸¬å®šæ–¹æ³•å¤‰ãˆã¦ã¾ã™ã€‚æœ€é©åŒ–ã•ã‚ŒãŸçŠ¶æ…‹ã§è¨ˆæ¸¬ã™ã‚‹ãŸã‚1ãƒ—ãƒã‚»ã‚¹å†…ã§åŒã˜å‡¦ç†ã‚’3å›žå®Ÿè¡Œã—ã¦æœ€å¾Œã®å€¤ã‚’å–ã‚‹ã€ã¨ã„ã†ã“ã¨ã‚’ãã‚Œãžã‚Œã®ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ã§3å›žå®Ÿè¡Œã—ã¦çœŸã‚“ä¸ã®å€¤ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ ã‚³ãƒ¼ãƒ‰ã‚„ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯ãƒªãƒã‚¸ãƒˆãƒªã«ã‚ã‚Šã¾ã™ã€‚ https://www.seasar.org/svn/sandbox/doma/trunk/or-mapper-benchmark/ SQLãƒ•ã‚¡ã‚¤ãƒ«ã«è¨˜è¿°ã•ã‚ŒãŸSELECTæ–‡ã‚’ä½¿ã£ã¦10000ä»¶æ¤œç´¢ 22,200,648 (nanoTime) : Doma SqlFileSelectDtoTest 39,252,773 (nanoTime) : S2DaoSqlFileSelectDtoTest 68,378,980 (nanoTime) : S2JdbcSqlFileSelectDtoTest è‡ªå‹•
hiro360 2010/01/12
seasar

java

performance

orm

jdbc

hibernate

s2dao

s2jdbc
ãƒªãƒ³ã‚¯
JDBCã€S2JDBCã€S2Daoã€JPAï¼ˆHibernateï¼‰ã€Domaã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ - taediumã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«H2ã‚’ä½¿ã£ã¦CRUDã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚ãã‚Œãžã‚Œ3å›žå®Ÿè¡Œã—ã¦çœŸã‚“ä¸ã®å€¤ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ã‚³ãƒ¼ãƒ‰ã‚„ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯ãƒªãƒã‚¸ãƒˆãƒªã«ã‚ã‚Šã¾ã™ã€‚ https://www.seasar.org/svn/doma/trunk/or-mapper-benchmark/ 10000ä»¶SELECT 529,419,874 (nanoTime) : DomaSelectOwnerTest 137,686,988 (nanoTime) : JdbcSelectOwnerTest 1,048,970,551 (nanoTime) : JpaSelectOwnerTest 303,612,949 (nanoTime) : S2DaoSelectOwnerTest 750,473,864 (nanoTime) : S2JdbcSelectOwnerTest 10000ä»¶INSERTï¼ˆ
hiro360 2010/01/12
seasar

java

performance

orm

jdbc

hibernate

s2dao

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

db

java

tips
ãƒªãƒ³ã‚¯
JDBC 4.0 - ã“ã‚Œã§ä½•ãŒå¤‰ã‚ã‚‹ï¼Ÿã©ã†ãªã‚‹ã®ï¼Ÿ
ã¨ã„ã†ã®ã®æ¦‚è¦ãŒç¬¬3ç« ã«æ›¸ã„ã¦ã‚ã£ãŸã‚“ã§ã™ãŒï¼Œä»¥ä¸‹ãã®å’Œè¨³ã‚’è²¼ã‚Šä»˜ã‘ã¨ãã¾ã™ï¼Ž http://ikda.net/fswiki/wiki.cgi?page=JDBC+4%2E0+%BB%C5%CD%CD%BD%F1 ã‚¢ãƒŽãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã®åˆ©ç”¨ã£ã¦ã®ã¯ã¾ã‚JavaEE5å…¨èˆ¬çš„ã«ãã†ã ã‹ã‚‰è‰¯ã„ã¨ã—ã¦ï¼Œæ—¥æœ¬äººçš„ã«ã¯ã€Œå›½åˆ¥ã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã®å¤‰æ›ã‚’ã‚µãƒãƒ¼ãƒˆã€ï¼ˆNational Character Set Conversion Supportï¼‰ãŒæ°—ã«ãªã‚Šã¾ã™ãï¼ŽMySQLãƒ¦ãƒ¼ã‚¶çš„ã«ã¯ROWIDãŒJDBCä»•æ§˜ã«å…¥ã£ã¡ã‚ƒã£ãŸã®ãŒæ°—ã«ãªã‚Šã¾ã™ãï¼ŽMySQLã«ã¯ROWIDã£ã¦ç„¡ã„ã—ï¼ŽNotSupportedExceptionæŠ•ã’ã‚‹ã—ã‹ãªã„ã‹ï¼Ÿï½— 3. æ–°æ©Ÿèƒ½ã®æ¦‚è¦ 3.1. å¤‰æ›´ç‚¹ã®æ¦‚è¦ JDBC 4.0 APIã¯ä»¥ä¸‹ã®è¿½åŠ å¤‰æ›´ã‚’å«ã‚“ã§ã„ã¾ã™ï¼š ã€java.sql.Driverã‚’è‡ªå‹•çš„ã«ãƒãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã€‘ Driver
hiro360 2006/01/18
java

jdbc
ãƒªãƒ³ã‚¯
1