{"id":291,"date":"2021-08-10T21:19:16","date_gmt":"2021-08-10T13:19:16","guid":{"rendered":"http:\/\/www.moon2bird.com\/?p=291"},"modified":"2021-09-20T21:36:31","modified_gmt":"2021-09-20T13:36:31","slug":"spring-jpa-%e9%92%88%e5%af%b9oracle%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%8d%e5%90%8c%e7%9a%84schema","status":"publish","type":"post","link":"http:\/\/www.hotelos.cn\/?p=291","title":{"rendered":"Spring jpa \u9488\u5bf9oracle\u6570\u636e\u5e93\u4e0d\u540c\u7684schema"},"content":{"rendered":"\n<p>Oracle\u6570\u636e\u5e93\u4e2d\u6709schema\u8fd9\u4e00\u8bbe\u5b9a\uff0c\u7528\u6237\u767b\u5f55\u540eschema\u53ef\u80fd\u5b58\u5728\u4e0d\u540c\uff0c\u56e0\u6b64\u9700\u8981\u6839\u636e\u4e0d\u540c\u7684\u73af\u5883\u914d\u7f6e\u4e0d\u540c\u7684\u9ed8\u8ba4schema\uff0c\u5177\u4f53\u914d\u7f6e\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>\u5728spring boot \u7684\u9ed8\u8ba4\u914d\u7f6e\u6587\u4ef6 application.properties\u4e2d\u914d\u7f6e\u5982\u4e0b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>spring.profiles.active=dev<\/code><\/pre>\n\n\n\n<p>\u5e76\u5728pom.xml\u4e2d\u914d\u7f6e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;profiles>\n\t\t&lt;profile>\n\t\t\t&lt;id>dev&lt;\/id>\n\t\t\t&lt;properties>\n\t\t\t\t&lt;profileActive>dev&lt;\/profileActive>\n\t\t\t&lt;\/properties>\n\t\t\t&lt;activation>\n\t\t\t\t&lt;activeByDefault>true&lt;\/activeByDefault>\n\t\t\t&lt;\/activation>\n\t\t&lt;\/profile>\n\t\t&lt;profile>\n\t\t\t&lt;id>prod&lt;\/id>\n\t\t\t&lt;properties>\n\t\t\t\t&lt;profileActive>prod&lt;\/profileActive>\n\t\t\t&lt;\/properties>\n\t\t&lt;\/profile>\n\t&lt;\/profiles><\/code><\/pre>\n\n\n\n<p>\u5728pom\u6587\u4ef6\u4e2d\u914d\u7f6e\u53ef\u80fd\u9700\u8981\u5b58\u5728\u7684\u4e0d\u540c\u7684\u73af\u5883\u540d\u79f0\u3002\u7136\u540e\u65b0\u5efaapplication-dev.properties, application-prod.properties.\u5206\u522b\u5728\u4e24\u4e2a\u6587\u4ef6\u4e2d\u914d\u7f6e\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>application-dev.properties<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>server.port = 50703\nspring.datasource.driver-class-name=oracle.jdbc.OracleDriver\n#\u586b\u5199\u5b9e\u9645oracle\u6570\u636e\u5e93\u5730\u5740\u548c\u7aef\u53e3\u53f7\u8fd8\u6709sid\nspring.datasource.url=jdbc:oracle:thin:@192.168.1.26:1521:XE\n#\u586b\u5199\u5b9e\u9645\u7528\u6237\u540d\nspring.datasource.username = username \n#\u586b\u5199\u5b9e\u9645\u5bc6\u7801\nspring.datasource.password = password \n#\u586b\u5199\u672c\u73af\u5883\u4e0b\u7684\u9ed8\u8ba4schema\nspring.jpa.properties.hibernate.default_schema=lp<\/code><\/pre>\n\n\n\n<p>application-prod.properties<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>server.port = 50703\nspring.datasource.driver-class-name=oracle.jdbc.OracleDriver\n#\u586b\u5199\u5b9e\u9645oracle\u6570\u636e\u5e93\u5730\u5740\u548c\u7aef\u53e3\u53f7\u8fd8\u6709sid\nspring.datasource.url=jdbc:oracle:thin:@10.16.11.22:1521:XE\n#\u586b\u5199\u5b9e\u9645\u7528\u6237\u540d\nspring.datasource.username = username \n#\u586b\u5199\u5b9e\u9645\u5bc6\u7801\nspring.datasource.password = password \n#\u586b\u5199\u672c\u73af\u5883\u4e0b\u7684\u9ed8\u8ba4schema\nspring.jpa.properties.hibernate.default_schema=default_schema<\/code><\/pre>\n\n\n\n<p>\u914d\u7f6e\u540e\uff0c\u53ef\u4ee5\u5728application.propertise\u4e2d\u4fee\u6539\u73af\u5883\u53c2\u6570\u8fdb\u884c\u914d\u7f6e\u53d8\u66f4<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle\u6570\u636e\u5e93\u4e2d\u6709schema\u8fd9\u4e00\u8bbe\u5b9a\uff0c\u7528\u6237\u767b\u5f55\u540eschema\u53ef\u80fd\u5b58\u5728\u4e0d\u540c\uff0c\u56e0\u6b64\u9700\u8981\u6839\u636e\u4e0d\u540c\u7684\u73af\u5883\u914d\u7f6e\u4e0d\u540c &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"http:\/\/www.hotelos.cn\/?p=291\"> <span class=\"screen-reader-text\">Spring jpa \u9488\u5bf9oracle\u6570\u636e\u5e93\u4e0d\u540c\u7684schema<\/span> \u67e5\u770b\u5168\u6587 &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[5],"tags":[],"_links":{"self":[{"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=\/wp\/v2\/posts\/291"}],"collection":[{"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=291"}],"version-history":[{"count":1,"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=\/wp\/v2\/posts\/291\/revisions"}],"predecessor-version":[{"id":292,"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=\/wp\/v2\/posts\/291\/revisions\/292"}],"wp:attachment":[{"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.hotelos.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}