{"id":10663,"date":"2012-07-20T21:00:08","date_gmt":"2012-07-20T12:00:08","guid":{"rendered":"http:\/\/www.sssg.org\/blogs\/hiro345\/?p=10663"},"modified":"2012-07-23T16:00:49","modified_gmt":"2012-07-23T07:00:49","slug":"jboss-as7-%e3%81%ab-mysql%e3%81%ae%e3%83%89%e3%83%a9%e3%82%a4%e3%83%90%e3%82%92%e8%bf%bd%e5%8a%a0","status":"publish","type":"post","link":"https:\/\/www.hiro345.net\/blogs\/hiro345\/archives\/10663.html","title":{"rendered":"JBoss AS7 \u306b MySQL\u306e\u30c9\u30e9\u30a4\u30d0\u3092\u8ffd\u52a0"},"content":{"rendered":"

JBoss AS7 \u306b MySQL\u306e\u30c9\u30e9\u30a4\u30d0\u3092\u8ffd\u52a0\u3059\u308b\u306b\u306f\u6b21\u306e\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n

\u307e\u305a\u306f\u300cMySQL :: Download Connector\/J<\/a>\u300d\u304b\u3089MySQL\u306e\u30c9\u30e9\u30a4\u30d0\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304a\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001mysql-connector-java-5.1.21.tar.gz \u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u3068\u3057\u307e\u3059\u3002\u5c55\u958b\u3059\u308b\u3068mysql-connector-java-5.1.21-bin.jar\u304c\u624b\u306b\u5165\u308a\u307e\u3059\u3002<\/p>\n

JBoss7\u306emodules\u3078\u914d\u5099\u3057\u307e\u3059\u3002<\/p>\n

\r\nexport MYSQL_DRIVER=${HOME}\/download\/mysql-connector-java-5.1.21\/mysql-connector-java-5.1.21-bin.jar\r\nexport JBOSS_HOME=${HOME}\/applications\/jboss-as-7.1.1.Final\r\ncd $JBOSS_HOME\r\nmkdir -p modules\/com\/mysql\/main\r\ncp $MYSQL_DRIVER $JBOSS_HOME\/modules\/com\/mysql\/main\r\ncd $JBOSS_HOME\/modules\/com\/mysql\/main\r\nvi module.xml\r\n<\/pre>\n
module.xml\u306e\u4e2d\u8eab\u306f\u6b21\u306e\u3068\u304a\u308a\u3002<\/p>\n
\r\n<?xml version="1.0" encoding="UTF-8"?>\r\n <module xmlns="urn:jboss:module:1.0" name="com.mysql">\r\n  <resources>\r\n    <resource-root path="mysql-connector-java-5.1.21-bin.jar"\/>\r\n  <\/resources>\r\n  <dependencies>\r\n    <module name="javax.api"\/>\r\n  <\/dependencies>\r\n<\/module>\r\n<\/pre>\n
$JBOSS_HOME\/standalone\/configuration\/standalone.xml \u3082\u4fee\u6b63\u3057\u307e\u3059\u3002MySQL\u3078\u306e\u30a2\u30af\u30bb\u30b9\u60c5\u5831\u306f root, secret \u3068\u3057\u3066\u3042\u308a\u307e\u3059\u304c\u3001\u4f7f\u3063\u3066\u3044\u308b\u7269\u306b\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\r\n<!-- \u7565 -->\r\n<datasource jndi-name="java:\/sampledb" pool-name="my_pool"\r\n            enabled="true" jta="true"\r\n            use-java-context="true" use-ccm="true">\r\n     <connection-url>jdbc:mysql:\/\/localhost:3306\/sampledb<\/connection-url>\r\n     <driver>mysql<\/driver>\r\n     <security>\r\n       <user-name>root<\/user-name>\r\n       <password>secret<\/password>\r\n     <\/security>\r\n     <statement>\r\n        <prepared-statement-cache-size>100<\/prepared-statement-cache-size>\r\n        <share-prepared-statements\/>\r\n     <\/statement>\r\n<\/datasource>\r\n<drivers>\r\n    <driver name="mysql" module="com.mysql"\/>\r\n    <driver name="h2" module="com.h2database.h2">\r\n        <xa-datasource-class>\r\n            org.h2.jdbcx.JdbcDataSource\r\n        <\/xa-datasource-class>\r\n    <\/driver>\r\n<\/drivers>\r\n<!-- \u7565 -->\r\n<\/pre>\n
\u5f8c\u306f\u8d77\u52d5\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/p>\n
\r\n$JBOSS_HOME\/bin\/standalone.sh\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
JBoss AS7 \u306b MySQL\u306e\u30c9\u30e9\u30a4\u30d0\u3092\u8ffd\u52a0\u3059\u308b\u306b\u306f\u6b21\u306e\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,6],"tags":[1207,246,1209,414],"class_list":["post-10663","post","type-post","status-publish","format-standard","hentry","category-java","category-linux","tag-java","tag-jboss","tag-linux","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/posts\/10663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/comments?post=10663"}],"version-history":[{"count":10,"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/posts\/10663\/revisions"}],"predecessor-version":[{"id":10696,"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/posts\/10663\/revisions\/10696"}],"wp:attachment":[{"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/media?parent=10663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/categories?post=10663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hiro345.net\/blogs\/hiro345\/wp-json\/wp\/v2\/tags?post=10663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}