You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
JPOUG Tech Talk Night #2 ã§è©±ããå 容ã«é£²ã¿ä¼ã§è³ªåãããå 容ãå ãã¦ãã¾ããRead less
ããã¯Java EE Advent Calendar 2013ã®21æ¥ç® æ¨æ¥ã¯[twitter:@Hachiro808]ããã®Thymeleafãæ¥åã§ä½¿ãããã§ããã çæ§ã¯JPAã®L2ãã£ãã·ã¥ã¨ãããã®ããåç¥ã§ããããã L2ãã£ãã·ã¥ã¨ã¯ ã¨ã³ãã£ãã£ããã£ãã·ã¥ããè¤æ°ã®ã¹ã¬ããéã§ã¨ã³ãã£ãã£ã使ã£ã¦ãã¼ã¿ãããã¨ãããå ´åã«ãã¡ãã¡ãã¼ã¿ãã¼ã¹ã«ã¢ã¯ã»ã¹ããªãã¦è¯ãããããã®ãã£ãã·ã¥ã§ãã æ®éã«ã¨ã³ãã£ãã£ã®ãã£ãã·ã¥ã§ããã¡ãªã¿ã«L1ãã£ãã·ã¥ã¨ããã®ãããã¾ãã¦ããã¡ãã¯åãã¹ã¬ããå ã§åãã¨ã³ãã£ãã£ãåå¾ããå ´åã«æ¯åDBã«ã¢ã¯ã»ã¹ãã«è¡ããªãã¦è¯ãããããã®ãã£ãã·ã¥ã§ãã 詳ããã¯Oracleã®äººãæ¸ããè³æããã£ãã®ã§ãã¡ããåç §ãã¦ãã ããã JPAã®ãã£ãã·ã¥ã使ã£ãã¢ããªã±ã¼ã·ã§ã³é«éåææ³ è¶ ã¯ã»ã¢ããªL2ãã£ãã·ã¥ ã¨ã¾ããåé¢ã ãè¦ãã¨é常ã«
ãããã¿ãJavaã¾ããã®ORMãç¥ãããä¼ - connpass Java ã® O/R ãããã¼ã¾ããã®è©±ãç¥ãããã£ãã®ã§ã6/14 ã«è¡ãããåå¼·ä¼ ããããã¿ã Java ã¾ããã® ORM ãç¥ãããä¼ã ã«åå ãã¦ãã¾ããã ä¼å ´ã¯å室ã§ããã Java ã¾ããã® O/R ãããã¼ãããã¾ã詳ãããªãã®ã§ããããç¥ãã¦è¯ãã£ãã§ãã ã¡ã¢ãæ®ãã¦ããã¾ãã çºè¡¨å 容 Java ã® ORMãDoma ã®è©± +α (@backpaper0 ãã) çºè¡¨è³æ: Javaã®ORMãDomaã®è©± +α â Javaã®ORMãDomaã®è©± 1.0 documentation ããã㪠O/R ãããã¼ã«ã¤ãã¦ã®ç°¡åãªç´¹ä»ã¨ãDoma ã®ç´¹ä»ã ç´¹ä»ããã O/R ãããã¼ã®ãã¡ã使ãã¨ããã JPA ã Iciql ã Doma ããªã¼ã¨ããæ°æã¡ã«ãªã£ãã (å人ã®ææ³ã§ãã) ã¡ãªã¿ã«ç´¹
ãã®ã¨ã³ããªã¯Java EE Advent Calendar 2013ã®13æ¥ç®ã®éææ¥ã§ãã æ¨æ¥ã¯@nagaseyasuhitoããã§ããã ã¡ã½ããããªãã¼ã·ã§ã³ã®ã¦ããããã¹ã | nagaseyasuhito Daily works. ææ¥ã¯@yamadamnããããã¼ãã®ç¥ããªãä¸çã®ãã¨ãæ¸ãã¦ããããã ã¨æãã¾ãã ãã®åã« Java EE 8ã«çãè¾¼ãã§æ¬²ããæ©è½ã®ã¢ã³ã±ã¼ããè¡ããã¦ãã¾ãã Jersey MVCãæ¨æºã«å ¥ããã¹ããã¨ããFaceletsãJSFããåãé¢ãã¹ããã¨ããCDIã®@Stereotypeãä»ã®ã¢ããã¼ã·ã§ã³ã«ãé©ç¨ããã¹ããã¨ããMVCã¯æ¬²ãããããã®MVCã¨JSFã¨ã§Faceletsãã³ãã¬ã¼ããå ±æãããã@Stereotypeã§ã¢ããã¼ã·ã§ã³ãã¾ã¨ãããã°ãã¢ããã¼ã·ã§ã³å°çãããªããªããã èå³ãªãé ç®ã¯ãNot sureãã«ããã°ã
HibernateãActiveObjectsãS2DaoãApache CayenneãiBATISãªã©ORMãã¬ã¼ã ã¯ã¼ã¯ã群éå²æ ç¶æ ãªJavaã§ããã使ãæ¹ãåå¼·ãããè¨å®ãã¡ã¤ã«æ¸ãããããã®ãå°ãé¢åããªã¨æã£ã¦ãã人ãããããããã¾ããã ç¹ã«ã¡ãã£ã¨ããã¢ããªã±ã¼ã·ã§ã³ãä½ããªãã°ãç´ ã®JDBCã使ãã®ã¯å«ã ãã©ãããã«è¿ãå½¢ã§ä½¿ããORãããã¼ã欲ããã¨æããã¨ããã³ãã³ããã¾ããã ã¨ãããã¨ã§ä»¥ä¸ã®æ¡ä»¶ã§JDBCãèãã©ããã³ã°ãã¦ããJavaã®ã©ã¤ãã©ãªãæ¢ãã¦çºè¦ãããã®ãç´¹ä»ãã¾ãã ã¬ã³ã¼ãããªãã¸ã§ã¯ãã«èªåçã«ãããã³ã°ãã¦ããã ã§ããã ãSQLãæ¸ãéãæ¸ãããã¨ãã§ãã ããã¨ãªã£ããçSQLãæ¸ããã¨ãã§ãã å°å ¥ãç°¡åã§ãã ä¾åã©ã¤ãã©ãªãå°ãªã 以ä¸ã«æ¿å ¥ãæ¤ç´¢ãæ´æ°ãåé¤ãå®è¡ããã³ã¼ããæ¸ãã¦ãã¾ãã ä»åã¯DBãMySQLã ã£ãã®ã§ãM
<< ç¡æã®DB2 Express-cã10.1 FP2ã«æ´æ°ãMac OS Xçã®DB2ãv10.1ã«æ´æ°ï¼ | main | #clubdb2 2013年第1åã¯1/25(é)ãpureScaleã®äºä¾ã¨ã³ã¬ã«ã©ã >> 2013å¹´ã«ãªãã¾ãããæãã¾ãã¦ããã§ã¨ããããã¾ãã ä»å¹´ãå°ãã¥ã¤ã§ãããblogãæ´æ°ãã¦ãããã¨æã£ã¦ãã¾ãã®ã§ãã©ãããããããé¡ããããã¾ãã æ°å¹´ä¸åç®ã®ã¨ã³ããªã¯ã以åã«ä»¥ä¸ã«æ¸ãããJavaè¨èªç¨ã®O/Rãããã³ã°ãªã¼ãã³ã½ã¼ã¹ãã¬ã¼ã ã¯ã¼ã¯ä¸è¦§ãã®æ´æ°ã§ãã - ãªã¼ãã³ã½ã¼ã¹Java O/Rãããã³ã°ã½ããä¸è¦§ï¼æ´æ°ï¼â»2008å¹´4æã®ã¨ã³ã㪠| Unofficial DB2 BLOG ãªã¹ãã«æãã¦ããã®ã¯ããªã¼ãã³ã½ã¼ã¹ã§ããã¤Javaç¨ã®O/Rãããã³ã°æ©è½ãæã¤ã½ããã§ããããããããã«ã¹ã¿ãã¯ãã¬ã¼ã ã¯ã¼ã¯ãã«ã¯O/Rãããã³ã°æ©è½
Javaã®ãã¬ã¼ã ã¯ã¼ã¯ã¯ãããã³ãé¨åã¯ãããã®ãããããããã¨æãã®ã§ãããDBã¢ã¯ã»ã¹å¨ãã¯HibernateãiBatisãæ£ç´å¾®å¦ã§ãããã決å®çï¼ã¨ãããã®ãããã¾ããã å人çã«ã¯S2JDBCã使ããããã¨æãã®ã§ãããSeasar2ã«ä¾åãã¦ãã¾ãï¼å®éã«ã¯S2Containerã使ããªãã¦ãåããã¾ãããSeasar2ã®ä¾åJARãå¿ è¦ã«ãªãã¾ãããç¾å®åé¡ã¨ãã¦S2Containerã使ããªãã±ã¼ã¹ã§ããã°S2JDBCãåè£ã«æãããã¨ãã¾ããªãã§ãããï¼ã ã¨ããããã§ãS2JDBCã®2WaySQLã使ããDBUtilsçãªã³ã³ãã¯ããªãã¼ã¿ãã¼ã¹ã¢ã¯ã»ã¹ã©ã¤ãã©ãªãä½ãå§ãã¾ããã 使ãæ¹ã¯ãããªæããJdbcManagerã®ä»£ããã«SqlManagerã¨ããã¯ã©ã¹ã使ãã¾ããã¾ããæµãããããªã¤ã³ã¿ã¼ãã§ã¼ã¹ã¯ä½¿ãããã¡ã½ããå¼ã³åºãä¸çºã§çµæãè¿ã£ã¦ããããã«ã
S2JDBCãããã©ã¼ãã³ã¹ãã¥ã¼ãã³ã°ãããã¨ãããã¨ãªã®ã§ãããä¸åº¦ããã©ã¼ãã³ã¹æ¯è¼ããã¦ã¿ã¾ããã測å®æ¹æ³ã¯ååã¨åæ§ã1ããã»ã¹å ã§åãå¦çã3åå®è¡ãã¦æå¾ã®å¤ãåãï¼æé©åãããç¶æ ã§è¨æ¸¬ããããã«ï¼ãã¨ãããã¨ãããããã®ãã¹ãã±ã¼ã¹ã§3åå®è¡ãã¦çãä¸ã®å¤ã使ã£ã¦ãã¾ãã ã³ã¼ãã使ç¨ãã¦ããã©ã¤ãã©ãªã¯ãªãã¸ããªã«ããã¾ãã https://www.seasar.org/svn/sandbox/doma/trunk/or-mapper-benchmark/ SQLãã¡ã¤ã«ã«è¨è¿°ãããSELECTæã使ã£ã¦10000件æ¤ç´¢ 19,364,522 (nanoTime) : DomaSqlFileSelectDtoTest 39,396,294 (nanoTime) : S2DaoSqlFileSelectDtoTest 12,013,783 (nanoTime) : S2J
ååã«ã¤ã¥ãã¦ããã©ã¼ãã³ã¹æ¯è¼ããã¦ã¿ã¾ããããã ããååã¨æ¸¬å®æ¹æ³å¤ãã¦ã¾ããæé©åãããç¶æ ã§è¨æ¸¬ãããã1ããã»ã¹å ã§åãå¦çã3åå®è¡ãã¦æå¾ã®å¤ãåããã¨ãããã¨ãããããã®ãã¹ãã±ã¼ã¹ã§3åå®è¡ãã¦çãä¸ã®å¤ã使ã£ã¦ãã¾ãã ã³ã¼ãã使ç¨ãã¦ããã©ã¤ãã©ãªã¯ãªãã¸ããªã«ããã¾ãã https://www.seasar.org/svn/sandbox/doma/trunk/or-mapper-benchmark/ SQLãã¡ã¤ã«ã«è¨è¿°ãããSELECTæã使ã£ã¦10000件æ¤ç´¢ 22,200,648 (nanoTime) : DomaSqlFileSelectDtoTest 39,252,773 (nanoTime) : S2DaoSqlFileSelectDtoTest 68,378,980 (nanoTime) : S2JdbcSqlFileSelectDtoTest èªå
ãã¼ã¿ãã¼ã¹ã«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ï¼
ãã®ã¨ã³ããªã§ã¯ãS2JDBC-Genã使ã£ã¦æ軽ã«ãã¼ã¿ãã¼ã¹ãªãã¡ã¯ã¿ãªã³ã°ãããæ¹æ³ãç´¹ä»ãã¾ããS2JDBC-Genã¯ãJavaã³ã¼ãï¼S2JDBCã®ã¨ã³ãã£ãã£ï¼ã®ä¿®æ£ããã¼ã¿ãã¼ã¹ã¹ãã¼ãã«åæ ããããã¼ã«ã§ãã S2JDBC-Genã®å®è¡ã«å¿ è¦ãªåä½ç°å¢ã¯ãEclipseãã©ã°ã¤ã³ã®Doltengã使ãã¨ç°¡åã«ç¨æã§ãã¾ããEclipseã¯ãã¼ã¸ã§ã³3.4ãDoltengã¯æ¨æ¥ãªãªã¼ã¹ãããã°ããã®0.33.0ã使ãã¾ãã é·ããªããããã®ã§è¦åºããããã Doltengã®ã¤ã³ã¹ãã¼ã« Doltengããã¸ã§ã¯ãã®ä½æ Antã®ã³ã³ã½ã¼ã«ã¨ã³ã³ã¼ãã£ã³ã°ã®è¨å® ï¼Windowsä¸ã§Eclipse3.4ãåããå ´åã«ã ãå¿ è¦ï¼ H2ã®èµ·åã¨ãã¼ã¿ã®ç¢ºèª ãã¼ã¿ãã¼ã¹ããã¨ã³ãã£ãã£ã®çæ ã¨ã³ãã£ãã£ããDDLã¨ãã³ããã¼ã¿ã®çæ DBãªãã¡ã¯ã¿ãªã³ã°ï¼æ°ããªã«ã©ã ã®å°å ¥ï¼ D
- The document discusses Domain-Oriented Mapping (DOM), which is a framework that maps objects to relational databases using domain models. - It describes how Doma can be used to define domain models (entities) and generate SQL from those models to perform data access operations like inserts and selects. - Benefits of using domain models include type safety, avoiding null checks, and reusability o
ã¯ããã«ãApache iBATISã¯SQLãå©ç¨ãããã¨ã«æ³¨åãããã¬ã¼ã ã¯ã¼ã¯ã§ããé«æ©è½ãªO/Rãããã³ã°ãã¬ã¼ã ã¯ã¼ã¯ã«æ¯ã¹ã¦ç°¡åã«ç解ã§ããã¬ã¬ã·ã¼ãªJDBCãResultSetã使ã£ãããã°ã©ãã³ã°ããç°¡åã«ä¹ãæãããã¾ããç¹ã«SQLãå¤ç¨ãã人ã«ã¯ä½¿ãããããã¬ã¼ã ã¯ã¼ã¯ã§ããããã®è¨äºã¯ååãåã åã®è¨äºã®ç¶ç·¨ã§ããä»åã¯iBATISã®æ©è½ãæ¡å¼µããæ¹æ³ã¨ãã¦ãæ¤ç´¢çµæãCSVãã¼ã¿ã¨ãã¦åºåããæ¹æ³ã¨ããã¼ã¿ãã¼ã¹ã®ãã¼ã¿ããä»»æã®ãã¼ã¿åã«äº¤æããæ¹æ³ãç´¹ä»ãã¾ãããiBATISã®åºæ¬çãªå 容ã¯ã以åã®è¨äºãåèã«ãã¦ããã ããã¨åãããããã¨æãã¾ããéå»ã®è¨äºiBATISã使ã£ãO/Rãããã³ã°ã«ããDBã¢ã¯ã»ã¹ã®å®ä¾iBATISã使ã£ãO/Rãããã³ã°ã«ããDBã¢ã¯ã»ã¹ã®å®ä¾ 2 対象èªè Javaã®åºæ¬ããã¹ã¿ã¼ãã¦ãã人SQLæãç解ãã¦ãã人 å¿ è¦ãªç°å¢ãi
Java | S2JDBC S2JDBC via ã²ããããblog ããã¥ã¡ã³ãã«ä¸éãç®ãéããããã°ããããã¶ã¤ã³ã®APIã ç¹ã«æ°ã«å ¥ã£ãã®ããæ¤ç´¢æ¡ä»¶ãã§èª¬æããã¦ããSimpleWhereã¯ã©ã¹ã使ã£ã¦Hibernateã§è¨ãã¨ããã®Criteriaãªãã¸ã§ã¯ããçµã¿ç«ã¦ãã¨ããããvalueãnullã®æã¯è¿½å ããã¾ããããããvaluesã®é åã®é·ãã0ã®æã¯è¿½å ããã¾ããã ãã¨ããæãããã®ãé°ã§å ¥åå¤ãnullãããªããã°ã¨ããåé·ãªæ¡ä»¶ç¯ãçããç¹ãã¦ãã¼ã¯ã§ä¾¿å©ãªæ©è½ã ã¨æããè¦ä»¶ããã¿ãªã¨åãã°ãç¸å½æ¥½ãã³ã«ãªãã¯ãã ãã æ¸ãã¦ãã¦æ°ä»ãããã©ãããããå ´åã«å㯠if (StringUtils.isNotBlank(departmentName)) ã¨ãnullã ããããªãã¦ç©ºæååããã¯ã¤ãã¹ãã¼ã¹ã ãã®æååãæ¤ç´¢æ¡ä»¶ããå¤ãã±ã¼ã¹ãå¤ãã®ã§ãSimp
ã¯ããã«ãiBATISã¯SQLãå©ç¨ãããã¨ã«æ³¨åãããã¬ã¼ã ã¯ã¼ã¯ã§ããé«æ©è½ãªO/Rãããã³ã°ãã¬ã¼ã ã¯ã¼ã¯ã«æ¯ã¹ã¦ç°¡åã«ç解ã§ããã¬ã¬ã·ã¼ãªJDBCãResultSetã使ã£ãããã°ã©ãã³ã°ããç°¡åã«ä¹ãæãããã¾ãããç¹ã«SQLãå¤ç¨ãã人ã«ã¯ä½¿ãããããã¬ã¼ã ã¯ã¼ã¯ã§ããããã®è¨äºã¯ååã®ãiBATISã使ã£ãO/Rãããã³ã°ã«ããDBã¢ã¯ã»ã¹ã®å®ä¾ãã®ç¶ç·¨ã§ããååã¯SELECTãINSERTãUPDATEãDELETEã®åºæ¬çãªè¨è¿°æ¹æ³ã«ã¤ãã¦ãµã³ãã«ãç´¹ä»ãã¾ãããä»åã¯SELECTæã«æ³¨ç®ããæ¤ç´¢çµæã®ãããã³ã°ã¨åçSQLã®è¨è¿°æ¹æ³ã«ã¤ãã¦èª¬æãã¾ãããiBATISã®åºæ¬çãªå 容ã¯ãååã®è¨äºãåèã«ãã¦ããã ããã¨ãåãããããã¨æãã¾ãã対象èªè Javaã®åºæ¬ããã¹ã¿ã¼ãã¦ãã人SQLæãç解ãã¦ãã人 å¿ è¦ãªç°å¢ãiBATIS 2.3.0ãJ2SE 5.0ã®ç°å¢ã
ãµã¼ãã¹çµäºã®ãç¥ãã ãã¤ãYahoo! JAPANã®ãµã¼ãã¹ããå©ç¨ããã ãèª ã«ãããã¨ããããã¾ãã ã客æ§ãã¢ã¯ã»ã¹ããããµã¼ãã¹ã¯æ¬æ¥ã¾ã§ã«ãµã¼ãã¹ãçµäºãããã¾ããã ä»å¾ã¨ãYahoo! JAPANã®ãµã¼ãã¹ããæ顧ãã ããã¾ãããããããããé¡ããããã¾ãã
The Apache OpenJPA Project Teamã¯ãåããã¸ã§ã¯ããApache Incubatorãåæ¥ãããããã¬ãã«ããã¸ã§ã¯ãã«ææ ¼ãããã¨ãçºè¡¨ãããApache OpenJPAã¯ãJSR-220 Java Persistence API (JPA)ã®å®è£ ç³»ã§ãããORM(Object Relational Mapping)ãã¼ã«ã«ä½ç½®ã¥ããããããã¨ãã¨ç±³BEA Systemsã«ãã£ã¦éçºããã¦ããKodo Java Persistence APIããã¼ã¹ã«ãããããã¯ãã§ã2006å¹´7æ25æ¥(ç±³å½æé)ã«Apache Incubatorã®ãã¨ã§ãOpenJPAãã¨ãã¦å¯è´ããã¦ããã åææç©ã®ææ°çã¯ãã§ã«JCP TCK for JSR-220ã«åæ ¼ãã¦ãããæ¨æºä»æ§ã¨äºææ§ããããã¨ã確èªããã¦ãããã¾ããEclipse IDEãNetBeans IDEã¨
iBATISã®Developer's Guideã®æ¥æ¬èªè¨³ããiBatisããã¥ã¢ã«æ¥æ¬èªè¨³ãã°ã«ã¼ãã®æ¹ã ãæ¥æ¬èªè¨³ãã¦ããã¾ããã ML:Japanese translation of iBATIS Developer's Guide. æ¬å®¶ã®ãµã¤ãã«ã¾ã ãªã³ã¯ã¯ãªãã§ããããã«ã¢ãããããããã§ãã JIRA:Japanese translation of iBATIS Developer's Guide. æè¬ã
iBATISã®Developer's Guideã®æ¥æ¬èªè¨³ããiBatisããã¥ã¢ã«æ¥æ¬èªè¨³ãã°ã«ã¼ãã®æ¹ã ãæ¥æ¬èªè¨³ãã¦ããã¾ããã ML:Japanese translation of iBATIS Developer's Guide. æ¬å®¶ã®ãµã¤ãã«ã¾ã ãªã³ã¯ã¯ãªãã§ããããã«ã¢ãããããããã§ãã JIRA:Japanese translation of iBATIS Developer's Guide. æè¬ã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}