{"id":129,"date":"2020-03-13T18:15:07","date_gmt":"2020-03-13T09:15:07","guid":{"rendered":"http:\/\/www.skyer9.pe.kr\/wordpress\/?p=129"},"modified":"2020-03-29T12:09:30","modified_gmt":"2020-03-29T03:09:30","slug":"from-hello-to-querydsl-use-mariadb-6-12","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=129","title":{"rendered":"[From Hello To QueryDSL] Use MariaDB (6\/12)"},"content":{"rendered":"<h1>Use MariaDB<\/h1>\n<p>h2 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \ub300\uc2e0 MariaDB \ub97c \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/p>\n<h2>\uac1c\ubc1c\ud658\uacbd<\/h2>\n<ul>\n<li>Spring Boot 2.1.x<\/li>\n<li>Gradle 4.10.2<\/li>\n<\/ul>\n<p>\ud504\ub85c\uc81d\ud2b8\ub294 \uc774\uc804 \uae00\uc5d0\uc11c \uc791\uc131\ub41c \ud504\ub85c\uc81d\ud2b8\uc5d0 \ud30c\uc77c\uc744 \ucd94\uac00 \ub610\ub294 \uc218\uc815\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4. \uc774\uc804 \uae00\uc744 \ub530\ub77c \ud558\uc9c0 \uc54a\uc740 \uacbd\uc6b0, \uba3c\uc800 \uc774\uc804 \uae00\ub300\ub85c \ud504\ub85c\uc81d\ud2b8\ub97c \uad6c\uc131\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n<h2>\ud30c\uc77c\ucd94\uac00 \ubc0f \uc218\uc815<\/h2>\n<p>build.gradle<\/p>\n<pre><code class=\"language-gradle\">\/\/ ......\ndependencies {\n    \/\/ ......\n    compile(&quot;org.mariadb.jdbc:mariadb-java-client&quot;)\n    \/\/ ......\n}\n\/\/ ......<\/code><\/pre>\n<p>h2 \ub294 \ud14c\uc774\ube14\uc744 \uc790\ub3d9\uc0dd\uc131 \ud558\uc9c0\ub9cc, <code>MariaDB<\/code> \ub294 \ub514\ud3f4\ud2b8\ub85c \ud14c\uc774\ube14\uc744 \uc218\ub3d9\uc0dd\uc131\ud558\ub3c4\ub85d \ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc6b4\uc601\ud658\uacbd\uc5d0\uc11c \uc0ac\uc6a9\ud558\uae30\uc5d0 \ud14c\uc774\ube14 \uc790\ub3d9\uc0dd\uc131 \uae30\ub2a5\uc740 \uc704\ud5d8\uc131\uc774 \ud06c\ubbc0\ub85c \uc218\ub3d9\uc73c\ub85c \uc0dd\uc131\ud574\uc90d\ub2c8\ub2e4.<\/p>\n<p>src\/main\/resources\/schema.sql.sample<\/p>\n<pre><code class=\"language-sql\">CREATE TABLE `spring_session` (\n  `PRIMARY_ID` char(36) NOT NULL,\n  `SESSION_ID` char(36) NOT NULL,\n  `CREATION_TIME` bigint(20) NOT NULL,\n  `LAST_ACCESS_TIME` bigint(20) NOT NULL,\n  `MAX_INACTIVE_INTERVAL` int(11) NOT NULL,\n  `EXPIRY_TIME` bigint(20) NOT NULL,\n  `PRINCIPAL_NAME` varchar(100) DEFAULT NULL,\n  PRIMARY KEY (`PRIMARY_ID`),\n  UNIQUE KEY `SPRING_SESSION_IX1` (`SESSION_ID`),\n  KEY `SPRING_SESSION_IX2` (`EXPIRY_TIME`),\n  KEY `SPRING_SESSION_IX3` (`PRINCIPAL_NAME`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;\n\nCREATE TABLE `spring_session_attributes` (\n  `SESSION_PRIMARY_ID` char(36) NOT NULL,\n  `ATTRIBUTE_NAME` varchar(200) NOT NULL,\n  `ATTRIBUTE_BYTES` blob NOT NULL,\n  PRIMARY KEY (`SESSION_PRIMARY_ID`,`ATTRIBUTE_NAME`),\n  CONSTRAINT `SPRING_SESSION_ATTRIBUTES_FK` FOREIGN KEY (`SESSION_PRIMARY_ID`) REFERENCES `spring_session` (`PRIMARY_ID`) ON DELETE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;\n\nCREATE TABLE `posts` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT,\n  `created_date` datetime DEFAULT NULL,\n  `modified_date` datetime DEFAULT NULL,\n  `author` varchar(255) DEFAULT NULL,\n  `content` text NOT NULL,\n  `title` varchar(500) NOT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nCREATE TABLE `user` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT,\n  `email` varchar(255) NOT NULL,\n  `name` varchar(255) NOT NULL,\n  `picture` varchar(255) DEFAULT NULL,\n  `role` varchar(255) NOT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/code><\/pre>\n<p>\uc544\ub798 \uc124\uc815\uc73c\ub85c \ub514\ube44\uc5d0 \uc138\uc158\uc744 \uc800\uc7a5\ud558\ub3c4\ub85d \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/p>\n<p>\ud1b0\ucea3\uc744 \uc7ac\uac00\ub3d9\ud574\ub3c4 \uc138\uc158 \ub85c\uadf8\uc778\uc774 \uc720\uc9c0\ub429\ub2c8\ub2e4.<\/p>\n<p>src\/main\/resources\/application.properties<\/p>\n<pre><code class=\"language-properties\">spring.jpa.show_sql=true\n# spring.jpa.properties.hibernate.format_sql=true\nspring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect\nspring.h2.console.enabled=false\n\n# \ub514\ube44\uc5d0 \uc138\uc158 \uc800\uc7a5\nspring.session.store-type=jdbc\n\n# =========================================================\n# FOR MariaDB\n# =========================================================\nspring.datasource.url=jdbc:mariadb:\/\/localhost:3306\/db_test\nspring.datasource.username=\nspring.datasource.password=\nspring.datasource.driver-class-name=org.mariadb.jdbc.Driver\n# spring.session.jdbc.initialize-schema=always<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>h2 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \ub300\uc2e0 MariaDB \ub97c \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-129","post","type-post","status-publish","format-standard","hentry","category-spring-boot-2-1"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=129"}],"version-history":[{"count":7,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/129\/revisions"}],"predecessor-version":[{"id":359,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/129\/revisions\/359"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}