{"id":390,"date":"2014-04-09T22:59:12","date_gmt":"2014-04-09T13:59:12","guid":{"rendered":"http:\/\/www.typea.info\/blog\/index.php\/2014\/04\/09\/java_ee_7_mysql_jdbcglassfish_v4\/"},"modified":"2014-04-09T22:59:12","modified_gmt":"2014-04-09T13:59:12","slug":"java_ee_7_mysql_jdbcglassfish_v4","status":"publish","type":"post","link":"https:\/\/www.typea.info\/blog\/index.php\/2014\/04\/09\/java_ee_7_mysql_jdbcglassfish_v4\/","title":{"rendered":"Java EE 7 \u691c\u8a3c\u74b0\u5883\u3092\u3064\u304f\u308b MySQL \u3078\u306ejdbc\u63a5\u7d9a\u3092GlassFish v4 \u306b\u4f5c\u6210"},"content":{"rendered":"
    \n
  1. Java EE 7 \u3092\u8a66\u3059\u305f\u3081\u306b CentOS \u306b GlassFish \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/a>\n
  2. Ubuntu \u306b GlassFish v4 \u306b\u3088\u308b Java EE 7 \u691c\u8a3c\u74b0\u5883\u3092\u3064\u304f\u308b<\/a>\n
  3. Ubuntu \u306b Spring Tool Suite \u3092\u5165\u308c\u3066 Java EE 7 \u691c\u8a3c\u74b0\u5883\u3092\u3064\u304f\u308b<\/a>\n
  4. Java EE 7 \u691c\u8a3c\u74b0\u5883\u3092\u3064\u304f\u308b REST Web\u30b5\u30fc\u30d3\u30b9<\/a>\n
  5. Java EE 7 \u691c\u8a3c\u74b0\u5883\u3092\u3064\u304f\u308b EJB\u7de8<\/a><\/li>\n<\/ol>\n

    \u3053\u3093\u306a\u611f\u3058\u3067\u9032\u3093\u3067\u304d\u305f\u306e\u3067\u3001\u6b21\u306fJPA\u306b\u3001\u3001\u3001\u5165\u308b\u524d\u306b\u3001JDBC\u3092\u69cb\u6210\u3059\u308b\u3002<\/p>\n

    1.MySQL<\/a>\"\" \u74b0\u5883\u3092\u3064\u304f\u308b<\/h2>\n

    1.1 Ubuntu\u306bMySQL<\/a>\"\" \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n

    CentOS\u306a\u3069\u3078\u306f\u3053\u3061\u3089\u53c2\u7167<\/a>\u3002<\/p>\n

    $ sudo apt-get install mysql-server<\/pre>\n
    \u9014\u4e2d\u3067\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u5165\u529b\u3092\u6c42\u3081\u3089\u308c\u307e\u3059\u3002<\/p>\n
    \"mysql_password\"<\/a> <\/p>\n
    \u8d77\u52d5\u3068\u505c\u6b62\u3068\u518d\u8d77\u52d5<\/strong><\/p>\n<\/p>\n
    $ sudo \/etc\/init.d\/mysql\u3000start\r\n$ sudo \/etc\/init.d\/mysql\u3000stop\r\n$ sudo \/etc\/init.d\/mysql\u3000restart\r\n<\/pre>\n
    \u63a5\u7d9a<\/strong><\/p>\n
    $ mysql -u root mysql\r\n<\/pre>\n
    1.2 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u3068\u78ba\u8a8d<\/h3>\n
    mysql> create database tallarico default character set utf8;\r\nQuery OK, 1 row affected (0.00 sec)\r\n\r\nmysql> show create database tallarico;\r\n+-----------+--------------------------------------------------------------------+\r\n| Database  | Create Database                                                    |\r\n+-----------+--------------------------------------------------------------------+\r\n| tallarico | CREATE DATABASE `tallarico` \/*!40100 DEFAULT CHARACTER SET utf8 *\/ |\r\n+-----------+--------------------------------------------------------------------+\r\n1 row in set (0.02 sec)\r\n<\/pre>\n
    MySQL<\/a>\"\" \u306e\u305d\u306e\u4ed6\u60c5\u5831<\/a><\/p>\n
    1.3 MySQL JDBC \u30c9\u30e9\u30a4\u30d0\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h3>\n
    http:\/\/dev.mysql.com\/downloads\/connector\/<\/a><\/p>\n
    MySQL<\/a>\"\" Connectors \u304b\u3089 Connector\/J \u3092\u9078\u629e<\/p>\n
    \"mysql_jdbc_driver01\"<\/a><\/p>\n
    Download Now<\/p>\n
    \"mysql_jdbc_driver02\"<\/a> <\/p>\n
    \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u89e3\u51cd\u3059\u308b\u3068\u3001\u4e2d\u306b mysql-connector-java <Version> \u2013bin.jar \u304c<\/p>\n
    \u542b\u307e\u308c\u308b\u306e\u3067\u3001\u305d\u3044\u3064\u3092\u53d6\u308a\u51fa\u3057\u3066\u304a\u304f\u3002<\/p>\n
     \"mysql_jdbc_driver03\"<\/a> <\/p>\n
    2.GlassFish JDBC\u306e\u69cb\u6210\u3092\u884c\u3046<\/h2>\n
    2.1 JDBC \u30c9\u30e9\u30a4\u30d0\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n
    \u4e0a\u8a181.3\u3067\u5165\u624b\u3057\u305fJDBC\u30c9\u30e9\u30a4\u30d0\u30fc\u3092\u3001\u4ee5\u4e0b\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u7f6e\u304f\u3053\u3068\u3067\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5b8c\u4e86\u3002<\/p>\n
    <GlassFish\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30c7\u30a3\u30ec\u30af\u30c8\u30ea>glassfish\/domains\/<\u5bfe\u8c61\u30c9\u30e1\u30a4\u30f3>\/lib\/ext<\/p>\n
    GlassFish  Application Development Guide Release 4.0<\/a><\/p>\n
    \n
    Using the Java Optional Package Mechanism <\/p>\n
    Optional packages are packages of Java classes and associated native code that
    application developers can use to extend the functionality of the core platform.
    To use the Java optional package mechanism, copy the JAR files into the
    domain-dir\/lib\/ext directory, or use the asadmin add-library command with the
    –type ext option, then restart the server. For more information about the asadmin
    add-library command, see the GlassFish Server Open Source Edition Reference Manual.<\/p>\n<\/blockquote>\n
    \"mysql_jdbc_driver_install_gf\"<\/a> <\/p>\n
    2.2 JDBC\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u8a2d\u5b9a<\/h3>\n
    \u7ba1\u7406\u30b3\u30f3\u30bd\u30fc\u30eb\u3092\u7acb\u3061\u4e0a\u3052\u3001\u5de6\u5074\u306e\u30c4\u30ea\u30fc\u304b\u3089\u3001JDBC\u63a5\u7d9a\u30d7\u30fc\u30eb\u3092\u9078\u629e\u3057\u3001\u65b0\u898f\u30dc\u30bf\u30f3\u3092\u62bc\u4e0b<\/p>\n
    \"gf_jdbc_pool_new\"<\/a> <\/p>\n
    \u9069\u5f53\u306b\u30d7\u30fc\u30eb\u540d\u3092\u540d\u4ed8\u3051\u3001\u30ea\u30bd\u30fc\u30b9\u30bf\u30a4\u30d7\u3092\u9078\u629e\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c9\u30e9\u30a4\u30d0\u30fc\u306e\u30d9\u30f3\u30c0\u30fc\u306bMySQL<\/a>\"\" \u3092\u6307\u5b9a\u3057\u3001\u6b21\u3078\u3002<\/p>\n
    \"gf_jdbc_pool_step2\"<\/a> <\/p>\n
    Ping \u3092\u6709\u52b9\u306b\u3057\u3001\u6700\u4f4e\u4ee5\u4e0b\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u8a2d\u5b9a\u3002<\/a><\/p>\n\n\n\n\n\n\n\n\n\n
    \u30d7\u30ed\u30d1\u30c6\u30a3<\/td>\n\u8a2d\u5b9a\u5024<\/td>\n<\/tr>\n
    user<\/td>\nroot<\/td>\n<\/tr>\n
    password<\/td>\n\u4e0a\u8a181.1\u3067\u8a2d\u5b9a\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9<\/td>\n<\/tr>\n
    DatabaseName<\/td>\n\u4e0a\u8a181.2\u3067\u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d<\/td>\n<\/tr>\n
    ServerName<\/td>\nlocalhost (\u9069\u5b9c)<\/td>\n<\/tr>\n
    port<\/td>\n3306<\/td>\n<\/tr>\n
    URL<\/td>\njdbc:mysql:\/\/localhost:3306\/<\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \"gf_jdbc_pool_step3\"<\/a> <\/p>\n
    \u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u8a2d\u5b9a<\/p>\n
    \"gf_jdbc_pool_properties\"<\/a> <\/p>\n
    \u5b8c\u4e86\u3001ping \u6210\u529f\uff01\uff01<\/p>\n
    \"gf_jdbc_pool_success\"<\/a> <\/p>\n
    2.2 JDBC\u30ea\u30bd\u30fc\u30b9\u306e\u8a2d\u5b9a<\/h3>\n
    \u5de6\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u3001JDBC\u30ea\u30bd\u30fc\u30b9\u3092\u9078\u629e\u3057\u3001\u65b0\u898f\u30dc\u30bf\u30f3\u62bc\u4e0b<\/p>\n
    \"gf_jdbc_resource_new\"<\/a> <\/p>\n
    JNDI\u540d\u3092\u8a2d\u5b9a\u3001\u4f5c\u6210\u3057\u305fJDBC\u30d7\u30fc\u30eb\u3092\u6307\u5b9a\u3057\u3066\u5b8c\u4e86<\/p>\n
    \"gf_jdbc_resource_new02\"<\/a> <\/p>\n
    \u3042\u3068\u306f\u3001\u3053\u306eJNDI\u540d\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u306f\u305a\u3002<\/p>\n