{"id":396,"date":"2014-04-29T01:20:23","date_gmt":"2014-04-28T16:20:23","guid":{"rendered":"http:\/\/www.typea.info\/blog\/index.php\/2014\/04\/29\/java_ee_7_3_jpamysqlarquillian\/"},"modified":"2014-04-29T01:20:23","modified_gmt":"2014-04-28T16:20:23","slug":"java_ee_7_3_jpamysqlarquillian","status":"publish","type":"post","link":"https:\/\/www.typea.info\/blog\/index.php\/2014\/04\/29\/java_ee_7_3_jpamysqlarquillian\/","title":{"rendered":"Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(3) JPA\u304b\u3089MySQL\u306b\u63a5\u7d9a\u3059\u308b\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8\u3092Arquillian\u3067\u5b9f\u884c"},"content":{"rendered":"
    \n
  1. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(1) WildFly + JBoss Tools \u3067 EAR\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057 Arquillian \u3067 \u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8\u3092\u30b0\u30ea\u30fc\u30f3\u306b\u3059\u308b\u3068\u3053\u308d\u307e\u3067<\/a><\/li>\n
  2. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(2) WildFly \u306b DataSource\u3092\u4f5c\u6210<\/a><\/li>\n
  3. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(3) JPA\u304b\u3089MySQL\u306b\u63a5\u7d9a\u3059\u308b\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8\u3092Arquillian\u3067\u5b9f\u884c<\/a><\/li>\n
  4. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(4) Java EE \u3067\u306e DI(Dependency Injection) \u304a\u3088\u3073 CDI(Contexts and Dependency Injection)\u3092\u306a\u304c\u3081\u308b<\/a><\/li>\n
  5. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(5) JBoss Tools\u304c\u751f\u6210\u3057\u305f\u30b5\u30f3\u30d7\u30eb\u30bd\u30fc\u30b9\u306eCDI\u3092\u78ba\u8a8d\u3059\u308b<\/a><\/li>\n
  6. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(6) JPA \u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u306e\u4f5c\u6210\u3068\u633f\u5165<\/a><\/li>\n
  7. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(7) JPA \u554f\u3044\u5408\u308f\u305b(1) \u540d\u524d\u4ed8\u304d\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u3066\u307f\u308b\u3002\u30c6\u30b9\u30c8\u3067\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3082\u610f\u8b58\u3059\u308b<\/a><\/li>\n
  8. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(8) JPA \u554f\u3044\u5408\u308f\u305b(2) \u52d5\u7684\u30af\u30a8\u30ea\u3068Criteria API \u3092\u8a66\u3059<\/a><\/li>\n
  9. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(9) jBatch \u6982\u8981\u3092\u304a\u3055\u3048\u308b<\/a><\/li>\n
  10. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(10) JBoss Tools \u3067\u4f5c\u6210\u3057\u305f EAR\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092Java EE 6 \u304b\u3089 7 \u306b\u5909\u66f4\u3059\u308b<\/a><\/li>\n
  11. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(11) jBatch\u7528 \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u4f5c\u6210\u3092\u884c\u3046<\/a><\/li>\n
  12. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(12) jBatch \u7c21\u6613\u30b5\u30f3\u30d7\u30eb\u4f5c\u6210\u3068 Arquillian \u3067\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8<\/a><\/li>\n
  13. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(13) jBatch REST \u30b5\u30fc\u30d3\u30b9\u7d4c\u7531\u3067\u5b9f\u884c\u3059\u308b<\/a><\/li>\n
  14. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(14) WildFly \u306e\u7ba1\u7406\u3092GUI\u3067\u884c\u3046<\/a><\/li>\n
  15. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(15) WildFly \u3092 \u30b5\u30fc\u30d3\u30b9\u3068\u3057\u3066\u8a2d\u5b9a\u3059\u308b(Windows\/Linux)<\/a><\/li>\n
  16. Java EE 7 \u691c\u8a3c\u74b0\u5883\u69cb\u7bc9(16) WildFly \u3068 Apache \u3092 mod_jk \u3067\u9023\u643a\u3055\u305b\u308b(Widows)<\/a><\/li>\n<\/ol>\n

    \u3088\u3046\u3084\u304f\u3001\u5916\u5800\u304c\u57cb\u307e\u3063\u3066\u304d\u305f\u3002<\/p>\n

    Java EE 7 \u306e\u691c\u8a3c\u74b0\u5883\u3068\u8a00\u3063\u3066\u3044\u308b\u306e\u306f\u3001EAR\u306b\u3001JAX-RS \u3068 EJB \u3068 JSF\u3092\u307e\u3068\u3081\u305f\u3082\u306e\u3092\u30a4\u30e1\u30fc\u30b8\u3057\u3066\u3044\u305f\u306e\u3067\u3001JBoss Tools \u306e EAR \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3069\u3093\u3073\u3057\u3083\u3002<\/p>\n

    Arquilian \u3092\u4f7f\u3063\u3066\u3001\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8\u304c\u7dd1\u306b\u306a\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3001\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3082WildFly\u306b\u4f5c\u6210\u3067\u304d\u305f\u306e\u3067\u3001\u305d\u308c\u3092\u5229\u7528\u3057\u3066\u3001JPA\u306e\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8(\u3082\u3068\u3082\u3068\u7d44\u307f\u8fbc\u307e\u308c\u3066\u3044\u308b\u3082\u306e\u3060\u304c)\u3092\u6210\u529f\u3055\u305b\u305f\u3044\u3002<\/p>\n<\/p>\n

    1.\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8\u3092WildFly\u306b\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u69cb\u6210\u3057\u305fMySQL\u306b\u3064\u306a\u3050<\/h2>\n

    1.1 \u30c6\u30b9\u30c8\u7528 persistence.xml \u306e\u4fee\u6b63<\/h3>\n

    \u307e\u305a\u3001\/src\/test\/resource\/META-INF\/test-persistence.xml \u3092\u4fee\u6b63\u3059\u308b\u3002<\/p>\n

    (\u4ee5\u4e0b\u306e1.\u4ee5\u5916\u306f\u3001Hibernate \u306e\u52d5\u4f5c\u78ba\u8a8d)<\/p>\n

      \n
    1. jta-data-source \u3092<\/strong>\u4f5c\u6210\u3057\u305f DataSource<\/strong><\/a> \u306e JNDI\u540d\u306b\u5408\u308f\u305b\u308b<\/strong><\/li>\n
    2. hibernate.hbm2ddl.auto \u306e\u5024\u3092 create-drop \u304b\u3089 create \u306b\u3059\u308b(\u30c6\u30b9\u30c8\u5f8c\u30c6\u30fc\u30d6\u30eb\u7b49\u524a\u9664\u3055\u308c\u306a\u3044\u3088\u3046\u306b)<\/li>\n
    3. hibernate.show_sql \u306e\u5024\u3092 false \u304b\u3089 true \u306b\u3057\u3001SQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u51fa\u529b\u3055\u305b\u308b<\/li>\n<\/ol>\n
      \n

      Hibernate \u306e\u8a2d\u5b9a<\/a>\u5024\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u3092\u53c2\u7167<\/p>\n

      http:\/\/docs.jboss.org\/hibernate\/core\/3.3\/reference\/en\/html\/session-configuration.html<\/a><\/p>\n<\/blockquote>\n

      <?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<persistence version=\"2.0\"\r\n   xmlns=\"http:\/\/java.sun.com\/xml\/ns\/persistence\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n   xsi:schemaLocation=\"\r\n        http:\/\/java.sun.com\/xml\/ns\/persistence\r\n        http:\/\/java.sun.com\/xml\/ns\/persistence\/persistence_2_0.xsd\">\r\n   <persistence-unit name=\"primary\">\r\n      <jta-data-source>java:jboss\/datasources\/TallaricoDS<\/jta-data-source>\r\n      <properties>\r\n         <!-- Properties for Hibernate -->\r\n         <property name=\"hibernate.hbm2ddl.auto\" value=\"create\" \/>\r\n         <property name=\"hibernate.show_sql\" value=\"true\" \/>\r\n      <\/properties>\r\n   <\/persistence-unit>\r\n<\/persistence><\/pre>\n
      <\/h3>\n
      1.2 \u30c6\u30b9\u30c8\u30af\u30e9\u30b9\u306e\u4fee\u6b63<\/h3>\n
      MemberRegistrationTest \u30af\u30e9\u30b9\u3092\u958b\u3044\u3066\u3001@Deployment\u304c\u4ed8\u4e0e\u3055\u308c\u3066\u3044\u308b\u30e1\u30bd\u30c3\u30c9\u3092\u7de8\u96c6\u3059\u308b\u3002<\/p>\n
      @Deployment \u304c\u4ed8\u4e0e\u3055\u308c\u305f\u30e1\u30bd\u30c3\u30c9\u306f\u3001Arquillian\u304c\u3001\u30c6\u30b9\u30c8\u7528\u306e\u30a2\u30fc\u30ab\u30a4\u30d6(JAR\u3001WAR)\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u3001\u30c6\u30b9\u30c8\u5b9f\u65bd\u524d\u306b\u547c\u3073\u51fa\u3055\u308c\u308b\u3002<\/a><\/p>\n
      \u521d\u671f\u72b6\u614b\u3067\u306f\u3001\/src\/test\/resource\/test-ds.xml \u306b\u8a18\u8ff0\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u304c\u3001\u30c6\u30b9\u30c8\u5b9f\u884c\u6642\u306b\u3001META-INF\u914d\u4e0b\u306b\u304a\u304b\u308c\u3001\u8a18\u8ff0\u3055\u308c\u3066\u3044\u308bJNDI\u540d\u3067\u767b\u9332\u3055\u308c\u3001\u305d\u306eJNDI\u540d\u3092\u3001persistence.xml \u304b\u3089\u53c2\u7167\u3059\u308b\u3068\u3044\u3046\u30c6\u30b9\u30c8\u306e\u6d41\u308c\u306b\u306a\u3063\u3066\u3044\u308b\u3002persistence.xml \u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u540d\u306b\u3001WildFly\u306b\u767b\u9332\u3057\u305f\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9JNDI\u3092\u6307\u5b9a\u3057\u3001\u305d\u3061\u3089\u3092\u5229\u7528\u3059\u308b\u305f\u3081\u3001\u4ee5\u4e0b\u3092\u4fee\u6b63\u3059\u308b\u3002<\/p>\n
      \/\/ Deploy our test datasource \u306e\u6b21\u306e\u884c\u3001.addAsWebInfResource \u884c\u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3059\u308b\u3002<\/p>\n
      \u3053\u306e\u884c\u3067\u30c6\u30b9\u30c8\u7528\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u304c test-ds.xml\u304b\u3089\u3001\u8aad\u307f\u8fbc\u307e\u308c\u308b\u3001test-ds.xml \u306b\u306fH2\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u8a2d\u5b9a\u304c\u3042\u308a\u3001JNDI\u540d\u304c\u30b3\u30f3\u30c6\u30ca\u306b\u767b\u9332\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u3002<\/p>\n
      \u3057\u306a\u3057\u306a\u304c\u3089\u3001WildFly \u306b\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u69cb\u6210\u3057\u3001\u305d\u3061\u3089\u3092\u3064\u304b\u3046\u305f\u3081<\/a>\u3001\u4e0d\u8981\u3002<\/p>\n
      @Deployment\r\npublic static Archive<?> createTestArchive() {\r\n    return ShrinkWrap.create(WebArchive.class, \"test.war\")\r\n            .addClasses(Member.class, MemberRegistration.class, Resources.class)\r\n            .addAsResource(\"META-INF\/test-persistence.xml\", \"META-INF\/persistence.xml\")\r\n            .addAsWebInfResource(EmptyAsset.INSTANCE, \"beans.xml\")\r\n            \/\/ Deploy our test datasource\r\n            \/\/.addAsWebInfResource(\"test-ds.xml\", \"test-ds.xml\")\r\n            ;\r\n}<\/pre>\n<\/p>\n
      2.\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8\u5b9f\u884c<\/h2>\n
      \u6210\u529f\uff01managed \u3068 remote \u3044\u305a\u308c\u3067\u3082\u6210\u529f\u3059\u308b\u3053\u3068\u3092\u78ba\u8a8d<\/p>\n
      \"datasource_unit_test_success01\"<\/a><\/p>\n<\/p>\n
      3.MySQL\u3092\u78ba\u8a8d<\/h2>\n
      MySQL Workbench \u3067\u3001\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3002<\/p>\n
      \"jpa_create_scheme01\"<\/a><\/p>\n
      \u3088\u3057\u3088\u3057\u3002\u60f3\u5b9a\u901a\u308a\u60f3\u5b9a\u901a\u308a\u3002<\/p>\n
      \n