{"id":41767,"date":"2023-05-05T10:40:06","date_gmt":"2023-08-20T04:52:49","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/"},"modified":"2024-04-30T02:43:55","modified_gmt":"2024-04-29T18:43:55","slug":"%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/","title":{"rendered":"\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5"},"content":{"rendered":"<h2>\u9996\u5148<\/h2>\n<p>\u5728TERASOLUNA Server Framework for Java (5.x)\u7684\u7a7a\u767d\u9879\u76ee\u7684\u521d\u59cb\u72b6\u6001\u4e0b\uff0c\u9ed8\u8ba4\u914d\u7f6e\u4f7f\u7528\u5185\u5b58\u6570\u636e\u5e93h2db\u3002\u4eca\u5929\u6211\u60f3\u7559\u4e0b\u4e2a\u4eba\u5907\u5fd8\u5f55\uff0c\u4ecb\u7ecd\u5982\u4f55\u5c06\u6570\u636e\u5e93\u66f4\u6539\u4e3aPostgreSQL\u7684\u65b9\u6cd5\u3002<\/p>\n<h3>1.1. \u9a8c\u8bc1\u73af\u5883<\/h3>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Java 1.8.0_131<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">TERASOLUNA Server Framework for Java 5.3.0<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">PostgreSQL 9.3<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Apache Tomcat 8.0.44<\/ul>\n<h3>1.2. PostgreSQL\u517c\u5bb9\u6027\u4fee\u6539\u7684\u6d41\u7a0b<\/h3>\n<p>\u4e0b\u9762\u5c55\u793a\u4e86\u5c06\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u5de5\u4f5c\u6d41\u7a0b\u3002\u8bf7\u6ce8\u610f\uff0c\u672c\u6b21\u5c06\u4f7f\u7528\u5e94\u7528\u7a0b\u5e8f\u5185\u51c6\u5907\u7684\u8fde\u63a5\u6c60\u800c\u4e0d\u662f\u5728\u5e94\u7528\u7a0b\u5e8f\u670d\u52a1\u5668\uff08Servlet\u5bb9\u5668\uff09\u7684\u6570\u636e\u6e90\u4e0a\u5b9a\u4e49\u7684\u8fde\u63a5\u6c60\u3002<\/p>\n<div>\n<div class=\"post-table\">\u9805\u756a\u4f5c\u696d\u6982\u89811<a href=\"#2-%E3%83%96%E3%83%A9%E3%83%B3%E3%82%AF%E3%83%97%E3%83%AD%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88%E3%81%AE%E4%BD%9C%E6%88%90\">\u30d6\u30e9\u30f3\u30af\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u4f5c\u6210<\/a>TERASOLUNA\u306e\u30ac\u30a4\u30c9\u30e9\u30a4\u30f3\u306b\u5f93\u3063\u3066\u30d6\u30e9\u30f3\u30af\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u30022<a href=\"#3-%E5%88%A9%E7%94%A8%E3%81%99%E3%82%8B%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%81%AE%E6%BA%96%E5%82%99\">\u5229\u7528\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6e96\u5099<\/a>localhost\u306b\u7acb\u3066\u305fPostgreSQL\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30e6\u30fc\u30b6\u3092\u4f5c\u6210\u3057\u307e\u3059\u30023<a href=\"#4-%E5%88%A9%E7%94%A8%E3%81%99%E3%82%8B%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%81%AE%E3%83%A9%E3%82%A4%E3%83%96%E3%83%A9%E3%83%AA%E3%82%92%E8%A6%AApom%E3%81%AE%E4%BE%9D%E5%AD%98%E9%96%A2%E4%BF%82%E3%81%AB%E8%BF%BD%E5%8A%A0\">\u5229\u7528\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u89aapom\u306e\u4f9d\u5b58\u95a2\u4fc2\u306b\u8ffd\u52a0<\/a>PostgreSQL\u306eJDBC\u30c9\u30e9\u30a4\u30d0\u3092\u8aad\u307f\u8fbc\u3080\u3088\u3046\u306b\u4f9d\u5b58\u95a2\u4fc2\u3092\u8ffd\u52a0\u3057\u307e\u3059\u30024<a href=\"#5-%E3%82%A2%E3%83%97%E3%83%AA%E3%82%B1%E3%83%BC%E3%82%B7%E3%83%A7%E3%83%B3%E8%B5%B7%E5%8B%95%E6%99%82%E3%81%AEdb%E5%88%9D%E6%9C%9F%E5%8C%96%E5%87%A6%E7%90%86%E3%82%92%E7%84%A1%E5%8A%B9\">\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8d77\u52d5\u6642\u306eDB\u521d\u671f\u5316\u51e6\u7406\u3092\u7121\u52b9<\/a>\u521d\u671f\u72b6\u614b\u3067\u306fh2db\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u521d\u671f\u5316\u51e6\u7406\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u3053\u308c\u3092\u7121\u52b9\u306b\u3057\u307e\u3059\u30025<a href=\"#6-%E3%82%AA%E3%83%97%E3%82%B7%E3%83%A7%E3%83%B3log4jdbc%E3%81%AB%E3%82%88%E3%82%8Bjdbc%E3%83%AD%E3%82%B0%E6%9B%B8%E3%81%8D%E8%BE%BC%E3%81%BF%E3%82%92%E7%84%A1%E5%8A%B9\">\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09log4jdbc\u306b\u3088\u308bJDBC\u30ed\u30b0\u66f8\u304d\u8fbc\u307f\u3092\u7121\u52b9<\/a>\u30c7\u30d0\u30c3\u30b0\u7528\u306elog4jdbc\u306e\u8a2d\u5b9a\u3092\u7121\u52b9\u306b\u3057\u307e\u3059\u30026<a href=\"#7-%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E6%8E%A5%E7%B6%9A%E5%85%88%E3%81%AE%E5%A4%89%E6%9B%B4\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u5148\u306e\u5909\u66f4<\/a>\u4eca\u56de\u7528\u610f\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3059\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u30027<a href=\"#8-%E5%88%A9%E7%94%A8%E3%81%99%E3%82%8B%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%81%AE%E3%83%A9%E3%82%A4%E3%83%96%E3%83%A9%E3%83%AA%E3%82%92domain%E3%83%97%E3%83%AD%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88%E3%81%AE%E4%BE%9D%E5%AD%98%E9%96%A2%E4%BF%82%E3%81%AB%E8%BF%BD%E5%8A%A0\">\u5229\u7528\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u3092domain\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u4f9d\u5b58\u95a2\u4fc2\u306b\u8ffd\u52a0<\/a>domain\u306e\u30c6\u30b9\u30c8\u6642\u306b\u3082JDBC\u30c9\u30e9\u30a4\u30d0\u3092\u8aad\u307f\u8fbc\u3080\u3088\u3046\u306b\u4f9d\u5b58\u95a2\u4fc2\u3092\u8ffd\u52a0\u3057\u307e\u3059\u30028<a href=\"#9-%E3%82%AA%E3%83%97%E3%82%B7%E3%83%A7%E3%83%B3initdb%E3%83%97%E3%83%AD%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88%E3%81%AE%E4%BF%AE%E6%AD%A3\">\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09initdb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u4fee\u6b63<\/a>initdb\u306b\u3082\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u63a5\u7d9a\u60c5\u5831\u306e\u8a2d\u5b9a\u7b87\u6240\u304c\u3042\u308b\u305f\u3081\u3053\u308c\u3092\u4fee\u6b63\u3057\u307e\u3059\u30029<a href=\"#10-%E3%82%AA%E3%83%97%E3%82%B7%E3%83%A7%E3%83%B3initdb%E3%83%97%E3%83%AD%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88%E3%82%92%E5%88%A9%E7%94%A8%E3%81%97%E3%81%9F%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%81%AE%E6%A7%8B%E7%AF%89\">\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09initdb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u5229\u7528\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u69cb\u7bc9<\/a>initdb\u3092\u5229\u7528\u3057\u30662\u3067\u6e96\u5099\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u69cb\u7bc9,\u521d\u671f\u5316\u51e6\u7406\u3092\u884c\u3044\u307e\u3059\u300210<a href=\"#11-%E3%81%8A%E8%A9%A6%E3%81%97%E3%83%93%E3%83%AB%E3%83%89\">\u304a\u8a66\u3057\u30d3\u30eb\u30c9<\/a>\u8a2d\u5b9a\u306b\u4e0d\u5099\u304c\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u304a\u8a66\u3057\u30d3\u30eb\u30c9\u3092\u884c\u3044\u307e\u3059\u300211<a href=\"#12-%E3%81%8A%E8%A9%A6%E3%81%97%E8%B5%B7%E5%8B%95\">\u304a\u8a66\u3057\u8d77\u52d5<\/a>\u8a2d\u5b9a\u306b\u4e0d\u5099\u304c\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u304a\u8a66\u3057\u8d77\u52d5\u3092\u884c\u3044\u307e\u3059\u3002<\/div>\n<\/div>\n<h2>2. \u521b\u5efa\u7a7a\u767d\u9879\u76ee<\/h2>\n<p>\u6839\u636e\u516c\u5f00\u7684\u6307\u5357\u4e2d\u7684\u201c3.1.2. \u5f00\u53d1\u9879\u76ee\u7684\u521b\u5efa\u201d\u90e8\u5206\u7684\u6b65\u9aa4\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u4e00\u4e2a\u7a7a\u767d\u9879\u76ee\u3002<br \/>\n\u672c\u6b21\u9879\u76ee\u7684\u8bbe\u7f6e\u5982\u4e0b\uff0c\u5728C:\\work\u4f5c\u4e3a\u5f53\u524d\u76ee\u5f55\u4e0b\u521b\u5efa\u7a7a\u767d\u9879\u76ee\u3002<\/p>\n<div>\n<div class=\"post-table\">\u9805\u756a\u9805\u76ee\u5024\u5099\u80031archetypeArtifactIdterasoluna-gfw-multi-web-blank-mybatis3-archetypeMyBatis\u3092\u5229\u7528\u3057\u305f\u30de\u30eb\u30c1\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u4f5c\u62102archetypeVersion5.3.0.RELEASE\u30d0\u30fc\u30b8\u30e7\u30f3\u306f5.3.03groupIdcom.example.demo.postgresql<br \/>\n4artifactIddemo-database-postgresql<\/div>\n<\/div>\n<pre class=\"post-pre\"><code><span class=\"go\">mvn archetype:generate -B^\r\n -DarchetypeGroupId=org.terasoluna.gfw.blank^\r\n -DarchetypeArtifactId=terasoluna-gfw-multi-web-blank-mybatis3-archetype^\r\n -DarchetypeVersion=5.3.0.RELEASE^\r\n -DgroupId=com.example.demo.postgresql^\r\n -DartifactId=demo-database-postgresql^\r\n -Dversion=1.0.0-SNAPSHOT\r\n<\/span><\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"go\">... \u7701\u7565 ...\r\n[INFO] Parameter: groupId, Value: com.example.demo.postgresql\r\n[INFO] Parameter: artifactId, Value: demo-database-postgresql\r\n[INFO] Parent element not overwritten in C:\\work\\demo-database-postgresql\\demo-database-postgresql-env\\pom.xml\r\n[INFO] Parent element not overwritten in C:\\work\\demo-database-postgresql\\demo-database-postgresql-domain\\pom.xml\r\n[INFO] Parent element not overwritten in C:\\work\\demo-database-postgresql\\demo-database-postgresql-web\\pom.xml\r\n[INFO] Parent element not overwritten in C:\\work\\demo-database-postgresql\\demo-database-postgresql-initdb\\pom.xml\r\n[INFO] Parent element not overwritten in C:\\work\\demo-database-postgresql\\demo-database-postgresql-selenium\\pom.xml\r\n[INFO] Project created from Archetype in dir: C:\\work\\demo-database-postgresql\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] BUILD SUCCESS\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] Total time: 26.941 s\r\n[INFO] Finished at: 2017-08-31T10:12:00+09:00\r\n[INFO] Final Memory: 10M\/48M\r\n[INFO] ------------------------------------------------------------------------\r\n\r\n<\/span><span class=\"gp\">C:\\work&gt;<\/span>\r\n<\/code><\/pre>\n<p>\u5982\u679c\u51fa\u73b0&#8221;BUILD SUCCESS&#8221;\u7684\u663e\u793a\uff0c\u5e76\u4e14\u5728C:\\work\u76ee\u5f55\u4e0b\u6210\u529f\u521b\u5efa\u4e86\u4ee5artifactId\u4e3a\u6307\u5b9a\u7684demo-database-postgresql\u76ee\u5f55\uff0c\u5219\u8868\u793a\u6210\u529f\u3002<\/p>\n<h2>3. \u6570\u636e\u5e93\u51c6\u5907\u5229\u7528<\/h2>\n<p>\u521b\u5efa\u5e76\u4f7f\u7528\u6570\u636e\u5e93\u548c\u7528\u6237\uff0c\u4ee5\u4fbf\u6267\u884cDDL\u8bed\u53e5\u3002<br \/>\n\u6211\u4eec\u5728\u672c\u5730\u4e3b\u673a\u4e0a\u4f7f\u7528\u4ee5\u4e0b\u8bbe\u7f6e\uff0c\u5728PostgreSQL\u4e0a\u51c6\u5907\u4e86\u6570\u636e\u5e93\u3002<\/p>\n<div>\n<div class=\"post-table\">\u9805\u756a\u9805\u76ee\u50241\u30dd\u30fc\u30c8\u756a\u53f754322\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540ddemodb3\u30e6\u30fc\u30b6IDdemoUser4\u30d1\u30b9\u30ef\u30fc\u30c9demoPass<\/div>\n<\/div>\n<h2>\u5728\u7236\u7ea7pom\u7684\u4f9d\u8d56\u5173\u7cfb\u4e2d\u6dfb\u52a0\u8981\u4f7f\u7528\u7684\u6570\u636e\u5e93\u5e93\u3002<\/h2>\n<p>\u5728\u6700\u521d\u7684\u72b6\u6001\u4e0b\uff0cOracle\u548cPostgreSQL\u7684\u8bbe\u7f6e\u662f\u4ee5\u6ce8\u91ca\u65b9\u5f0f\u8fdb\u884c\u63cf\u8ff0\u7684\u3002<br \/>\n\u53d6\u6d88PostgreSQL\u7684\u6ce8\u91ca\u5e76\u4f7f\u5176\u751f\u6548\u3002<\/p>\n<ul class=\"post-ul\">\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\uff1aC:\\work\\demo-database-postgresql\\pom.xml<\/ul>\n<pre class=\"post-pre\"><code>            <span class=\"c\">&lt;!-- == Begin Database == --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;dependency&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--                 &lt;groupId&gt;org.postgresql&lt;\/groupId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--                 &lt;artifactId&gt;postgresql&lt;\/artifactId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--                 &lt;version&gt;${postgresql.version}&lt;\/version&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;\/dependency&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;dependency&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--                 &lt;groupId&gt;com.oracle&lt;\/groupId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--                 &lt;artifactId&gt;ojdbc7&lt;\/artifactId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--                 &lt;version&gt;${ojdbc.version}&lt;\/version&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;\/dependency&gt; --&gt;<\/span>\r\n            <span class=\"c\">&lt;!-- == End Database == --&gt;<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>            <span class=\"c\">&lt;!-- == Begin Database == --&gt;<\/span>\r\n             <span class=\"nt\">&lt;dependency&gt;<\/span>\r\n                 <span class=\"nt\">&lt;groupId&gt;<\/span>org.postgresql<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n                 <span class=\"nt\">&lt;artifactId&gt;<\/span>postgresql<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n                 <span class=\"nt\">&lt;version&gt;<\/span>${postgresql.version}<span class=\"nt\">&lt;\/version&gt;<\/span>\r\n             <span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;dependency&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--                 &lt;groupId&gt;com.oracle&lt;\/groupId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--                 &lt;artifactId&gt;ojdbc7&lt;\/artifactId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--                 &lt;version&gt;${ojdbc.version}&lt;\/version&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;\/dependency&gt; --&gt;<\/span>\r\n            <span class=\"c\">&lt;!-- == End Database == --&gt;<\/span>\r\n<\/code><\/pre>\n<h2>5. \u7981\u7528\u5e94\u7528\u7a0b\u5e8f\u542f\u52a8\u65f6\u7684\u6570\u636e\u5e93\u521d\u59cb\u5316\u5904\u7406\u3002<\/h2>\n<p>\u5728\u7a7a\u767d\u9879\u76ee\u7684\u521d\u59cb\u72b6\u6001\u4e0b\uff0c\u5373DI\u5bb9\u5668\u542f\u52a8\u65f6\uff0c\u4e5f\u5c31\u662f\u5e94\u7528\u7a0b\u5e8f\u542f\u52a8\u65f6\uff0c\u4f1a\u6267\u884c\u6307\u5b9a\u7684DDL\u6587\u4ef6\uff0c\u8be5\u6587\u4ef6\u662f\u901a\u8fc7\u6307\u5b9a\u7684\u3002\u867d\u7136\u5728\u4f7f\u7528\u5185\u5b58\u6570\u636e\u5e93\u65f6\u662f\u5fc5\u8981\u7684\uff0c\u4f46\u5728\u4e00\u822c\u7684Web\u5e94\u7528\u7a0b\u5e8f\u4e2d\uff0c\u6211\u8ba4\u4e3a\u8fd9\u4e2a\u529f\u80fd\u662f\u4e0d\u9700\u8981\u7684\u3002\u6211\u4eec\u53ef\u4ee5\u5c06\u7684\u63cf\u8ff0\u6ce8\u91ca\u6389\u4ee5\u7981\u7528\u5b83\u3002<\/p>\n<ul class=\"post-ul\">\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\uff1aC:\\work\\demo-database-postgresql\\demo-database-postgresql-env\\src\\main\\resources\\META-INF\\spring\\demo-database-postgresql-env.xml<\/ul>\n<pre class=\"post-pre\"><code>    <span class=\"nt\">&lt;jdbc:initialize-database<\/span> <span class=\"na\">data-source=<\/span><span class=\"s\">\"dataSource\"<\/span>\r\n        <span class=\"na\">ignore-failures=<\/span><span class=\"s\">\"ALL\"<\/span><span class=\"nt\">&gt;<\/span>\r\n        <span class=\"nt\">&lt;jdbc:script<\/span> <span class=\"na\">location=<\/span><span class=\"s\">\"classpath:\/database\/${database}-schema.sql\"<\/span> <span class=\"na\">encoding=<\/span><span class=\"s\">\"UTF-8\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;jdbc:script<\/span> <span class=\"na\">location=<\/span><span class=\"s\">\"classpath:\/database\/${database}-dataload.sql\"<\/span> <span class=\"na\">encoding=<\/span><span class=\"s\">\"UTF-8\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/jdbc:initialize-database&gt;<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>    <span class=\"c\">&lt;!--\r\n    &lt;jdbc:initialize-database data-source=\"dataSource\"\r\n        ignore-failures=\"ALL\"&gt;\r\n        &lt;jdbc:script location=\"classpath:\/database\/${database}-schema.sql\" encoding=\"UTF-8\" \/&gt;\r\n        &lt;jdbc:script location=\"classpath:\/database\/${database}-dataload.sql\" encoding=\"UTF-8\" \/&gt;\r\n    &lt;\/jdbc:initialize-database&gt;\r\n    --&gt;<\/span>\r\n<\/code><\/pre>\n<h2>\uff08\u9009\u9879\uff09\u7981\u7528log4jdbc\u901a\u8fc7JDBC\u8fdb\u884c\u65e5\u5fd7\u8bb0\u5f55\u3002<\/h2>\n<p>\u5f53\u5728@Transactional(readOnly = true)\u4e2d\u5c06\u4e8b\u52a1\u8bbe\u7f6e\u4e3a\u53ea\u8bfb\u65f6\uff0c\u4f7f\u7528log4jdbc\u8bb0\u5f55\u65e5\u5fd7\u65f6\u4f1a\u51fa\u73b0\u9519\u8bef\u6d88\u606f\u7684\u65e5\u5fd7\u8f93\u51fa\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"go\">date:2017-08-31 20:04:25    thread:http-nio-8080-exec-2 X-Track:b67e7712dcc143f398f5e51b762e3dea    level:ERROR logger:jdbc.audit                                       message:2. Connection.setReadOnly(true)\r\norg.postgresql.util.PSQLException: \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u6700\u4e2d\u306b\u8aad\u307f\u51fa\u3057\u5c02\u7528\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u5909\u3048\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002\r\n    at org.postgresql.jdbc2.AbstractJdbc2Connection.setReadOnly(AbstractJdbc2Connection.java:741)\r\n    at org.apache.commons.dbcp2.DelegatingConnection.setReadOnly(DelegatingConnection.java:562)\r\n    at org.apache.commons.dbcp2.DelegatingConnection.setReadOnly(DelegatingConnection.java:562)\r\n    at net.sf.log4jdbc.ConnectionSpy.setReadOnly(ConnectionSpy.java:374)\r\n... \u7701\u7565 ...\r\n<\/span><\/code><\/pre>\n<p>\u867d\u7136\u5728\u5e94\u7528\u7a0b\u5e8f\u4e2d\u8bbe\u7f6e\u4e3a\u201c\u53ea\u8bfb\u201d\uff0c\u4f46\u7531\u4e8elog4jdbc\u9700\u8981\u201c\u53ef\u8bfb\u5199\u201d\u4e8b\u52a1\uff0c\u8fd9\u662f\u7406\u6240\u5f53\u7136\u7684\u3002<br \/>\n\u7531\u4e8e\u9519\u8bef\u6d88\u606f\u4ec5\u8f93\u51fa\u5230\u65e5\u5fd7\u4e2d\uff0c\u4e0d\u4f1a\u5f71\u54cd\u5e94\u7528\u7a0b\u5e8f\u7684\u5904\u7406\uff0c\u4f46\u7531\u4e8e\u4e2a\u4eba\u539f\u56e0\uff0c\u6211\u603b\u662f\u7981\u7528log4jdbc\uff0c\u8fd9\u8ba9\u6211\u6709\u4e9b\u4e0d\u5b89\u3002<\/p>\n<p>\u7981\u7528\u8be5\u529f\u80fd\u7684\u65b9\u6cd5\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u5220\u9664Log4jdbcProxyDataSource\u7684Bean\u5b9a\u4e49\uff0c\u5e76\u5c06dataSource\u7684BeanId\u66f4\u6539\u4e3adbcp2\u7684\u6570\u636e\u6e90\u5373\u53ef\u3002<\/p>\n<ul class=\"post-ul\">\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\uff1aC:\\work\\demo-database-postgresql\\demo-database-postgresql-env\\src\\main\\resources\\META-INF\\spring\\demo-database-postgresql-env.xml<\/ul>\n<pre class=\"post-pre\"><code>    <span class=\"nt\">&lt;bean<\/span> <span class=\"na\">id=<\/span><span class=\"s\">\"realDataSource\"<\/span> <span class=\"na\">class=<\/span><span class=\"s\">\"org.apache.commons.dbcp2.BasicDataSource\"<\/span>\r\n        <span class=\"na\">destroy-method=<\/span><span class=\"s\">\"close\"<\/span><span class=\"nt\">&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"driverClassName\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${database.driverClassName}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"url\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${database.url}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"username\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${database.username}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"password\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${database.password}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"defaultAutoCommit\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"false\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"maxTotal\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${cp.maxActive}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"maxIdle\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${cp.maxIdle}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"minIdle\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${cp.minIdle}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"maxWaitMillis\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${cp.maxWait}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/bean&gt;<\/span>\r\n\r\n\r\n    <span class=\"nt\">&lt;bean<\/span> <span class=\"na\">id=<\/span><span class=\"s\">\"dataSource\"<\/span> <span class=\"na\">class=<\/span><span class=\"s\">\"net.sf.log4jdbc.Log4jdbcProxyDataSource\"<\/span><span class=\"nt\">&gt;<\/span>\r\n        <span class=\"nt\">&lt;constructor-arg<\/span> <span class=\"na\">index=<\/span><span class=\"s\">\"0\"<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"realDataSource\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/bean&gt;<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>    <span class=\"nt\">&lt;bean<\/span> <span class=\"na\">id=<\/span><span class=\"s\">\"dataSource\"<\/span> <span class=\"na\">class=<\/span><span class=\"s\">\"org.apache.commons.dbcp2.BasicDataSource\"<\/span>\r\n        <span class=\"na\">destroy-method=<\/span><span class=\"s\">\"close\"<\/span><span class=\"nt\">&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"driverClassName\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${database.driverClassName}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"url\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${database.url}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"username\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${database.username}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"password\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${database.password}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"defaultAutoCommit\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"false\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"maxTotal\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${cp.maxActive}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"maxIdle\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${cp.maxIdle}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"minIdle\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${cp.minIdle}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"maxWaitMillis\"<\/span> <span class=\"na\">value=<\/span><span class=\"s\">\"${cp.maxWait}\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/bean&gt;<\/span>\r\n\r\n    <span class=\"c\">&lt;!--\r\n    &lt;bean id=\"dataSource\" class=\"net.sf.log4jdbc.Log4jdbcProxyDataSource\"&gt;\r\n        &lt;constructor-arg index=\"0\" ref=\"realDataSource\" \/&gt;\r\n    &lt;\/bean&gt;\r\n    --&gt;<\/span>\r\n<\/code><\/pre>\n<h2>7. \u6570\u636e\u5e93\u8fde\u63a5\u7684\u66f4\u6539<\/h2>\n<p>\u8fd9\u6b21\u6211\u4eec\u5c06\u4ecb\u7ecd\u5982\u4f55\u5728\u5e94\u7528\u7a0b\u5e8f\u4e2d\u4f7f\u7528dbcp2\u8fde\u63a5\u6c60\u3002\u56e0\u6b64\uff0c\u6570\u636e\u5e93\u7684\u8fde\u63a5\u4fe1\u606f\uff08URL\u3001\u7aef\u53e3\u53f7\u3001\u7528\u6237ID\u3001\u5bc6\u7801\u7b49\uff09\u9700\u8981\u5728\u5e94\u7528\u7a0b\u5e8f\u4e2d\u8fdb\u884c\u7ba1\u7406\u3002<br \/>\n\u5728TERASOLUNA5.x\u7684\u9ed8\u8ba4\u8bbe\u7f6e\u4e2d\uff0c\u8fd9\u4e9b\u4fe1\u606f\u53ef\u4ee5\u5b9a\u4e49\u5728***infra.properties\u6587\u4ef6\u4e2d\u3002<br \/>\n\u53e6\u5916\uff0c\u5982\u679c\u8981\u4f7f\u7528JNDI\u6765\u4f7f\u7528\u5e94\u7528\u7a0b\u5e8f\u670d\u52a1\u5668\u7684datasource\uff0c\u5c06\u5728\u53e6\u4e00\u4e2a\u673a\u4f1a\u8fdb\u884c\u8bf4\u660e\u3002<\/p>\n<ul class=\"post-ul\">\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\uff1aC:\\work\\demo-database-postgresql\\demo-database-postgresql-env\\src\\main\\resources\\META-INF\\spring\\demo-database-postgresql-infra.properties<\/ul>\n<pre class=\"post-pre\"><code><span class=\"py\">database<\/span><span class=\"p\">=<\/span><span class=\"s\">H2<\/span>\r\n<span class=\"py\">database.url<\/span><span class=\"p\">=<\/span><span class=\"s\">jdbc:h2:mem:demo-database-postgresql;DB_CLOSE_DELAY=-1<\/span>\r\n<span class=\"py\">database.username<\/span><span class=\"p\">=<\/span><span class=\"s\">sa<\/span>\r\n<span class=\"py\">database.password<\/span><span class=\"p\">=<\/span>\r\n<span class=\"py\">database.driverClassName<\/span><span class=\"p\">=<\/span><span class=\"s\">org.h2.Driver<\/span>\r\n<span class=\"c\"># connection pool\r\n<\/span><span class=\"py\">cp.maxActive<\/span><span class=\"p\">=<\/span><span class=\"s\">96<\/span>\r\n<span class=\"py\">cp.maxIdle<\/span><span class=\"p\">=<\/span><span class=\"s\">16<\/span>\r\n<span class=\"py\">cp.minIdle<\/span><span class=\"p\">=<\/span><span class=\"s\">0<\/span>\r\n<span class=\"py\">cp.maxWait<\/span><span class=\"p\">=<\/span><span class=\"s\">60000<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"c\">### default setting is H2\r\n# database=H2\r\n# database.url=jdbc:h2:mem:demo-database-postgresql;DB_CLOSE_DELAY=-1\r\n# database.username=sa\r\n# database.password=\r\n# database.driverClassName=org.h2.Driver\r\n<\/span>\r\n<span class=\"c\">### setting for postgreSQL\r\n<\/span><span class=\"py\">database<\/span><span class=\"p\">=<\/span><span class=\"s\">POSTGRESQL<\/span>\r\n<span class=\"py\">database.url<\/span><span class=\"p\">=<\/span><span class=\"s\">jdbc:postgresql:\/\/127.0.0.1:5432\/demodb<\/span>\r\n<span class=\"py\">database.username<\/span><span class=\"p\">=<\/span><span class=\"s\">demoUser<\/span>\r\n<span class=\"py\">database.password<\/span><span class=\"p\">=<\/span><span class=\"s\">demoPass<\/span>\r\n<span class=\"py\">database.driverClassName<\/span><span class=\"p\">=<\/span><span class=\"s\">org.postgresql.Driver<\/span>\r\n\r\n<span class=\"c\"># connection pool\r\n<\/span><span class=\"py\">cp.maxActive<\/span><span class=\"p\">=<\/span><span class=\"s\">96<\/span>\r\n<span class=\"py\">cp.maxIdle<\/span><span class=\"p\">=<\/span><span class=\"s\">16<\/span>\r\n<span class=\"py\">cp.minIdle<\/span><span class=\"p\">=<\/span><span class=\"s\">0<\/span>\r\n<span class=\"py\">cp.maxWait<\/span><span class=\"p\">=<\/span><span class=\"s\">60000<\/span>\r\n<\/code><\/pre>\n<h2>\u628a\u8981\u4f7f\u7528\u7684\u6570\u636e\u5e93\u5e93\u6dfb\u52a0\u5230domain\u9879\u76ee\u7684\u4f9d\u8d56\u5173\u7cfb\u4e2d\u3002<\/h2>\n<p>\u521d\u59cb\u72b6\u6001\u4e0b\uff0cOracle\u548cPostgreSQL\u7684\u8bbe\u7f6e\u88ab\u6ce8\u91ca\u6389\u4e86\u3002<br \/>\n\u53d6\u6d88\u6ce8\u91caPostgreSQL\u7684\u5185\u5bb9\u4f7f\u5176\u751f\u6548\u3002<\/p>\n<ul class=\"post-ul\">\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\uff1aC:\\work\\demo-database-postgresql\\demo-database-postgresql-domain\\pom.xml<\/ul>\n<pre class=\"post-pre\"><code>        <span class=\"c\">&lt;!-- == Begin Database == --&gt;<\/span>\r\n<span class=\"c\">&lt;!--         &lt;dependency&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;groupId&gt;org.postgresql&lt;\/groupId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;artifactId&gt;postgresql&lt;\/artifactId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;scope&gt;test&lt;\/scope&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--         &lt;\/dependency&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--         &lt;dependency&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;groupId&gt;com.oracle&lt;\/groupId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;artifactId&gt;ojdbc7&lt;\/artifactId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;scope&gt;test&lt;\/scope&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--         &lt;\/dependency&gt; --&gt;<\/span>\r\n        <span class=\"c\">&lt;!-- == End Database == --&gt;<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>        <span class=\"c\">&lt;!-- == Begin Database == --&gt;<\/span>\r\n         <span class=\"nt\">&lt;dependency&gt;<\/span>\r\n             <span class=\"nt\">&lt;groupId&gt;<\/span>org.postgresql<span class=\"nt\">&lt;\/groupId&gt;<\/span>\r\n             <span class=\"nt\">&lt;artifactId&gt;<\/span>postgresql<span class=\"nt\">&lt;\/artifactId&gt;<\/span>\r\n             <span class=\"nt\">&lt;scope&gt;<\/span>test<span class=\"nt\">&lt;\/scope&gt;<\/span>\r\n         <span class=\"nt\">&lt;\/dependency&gt;<\/span>\r\n<span class=\"c\">&lt;!--         &lt;dependency&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;groupId&gt;com.oracle&lt;\/groupId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;artifactId&gt;ojdbc7&lt;\/artifactId&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--             &lt;scope&gt;test&lt;\/scope&gt; --&gt;<\/span>\r\n<span class=\"c\">&lt;!--         &lt;\/dependency&gt; --&gt;<\/span>\r\n        <span class=\"c\">&lt;!-- == End Database == --&gt;<\/span>\r\n<\/code><\/pre>\n<h2>9. \uff08\u9009\u9879\uff09\u4fee\u590dinitdb\u9879\u76ee<\/h2>\n<p>initdb\u9879\u76ee\u4e2d\u4e5f\u4fdd\u5b58\u4e86\u6570\u636e\u5e93\u7684\u8fde\u63a5\u4fe1\u606f\u3002\u4e0d\u8fc7\uff0c\u7531\u4e8einitdb\u9879\u76ee\u672c\u8eab\u5c31\u662f\u7528\u6765\u8fdb\u884c\u6570\u636e\u5e93\u521d\u59cb\u6784\u5efa\u7684\uff0c\u6240\u4ee5\u5982\u679c\u4e0d\u4f7f\u7528initdb\uff0c\u5c31\u4e0d\u9700\u8981\u8fdb\u884c\u4efb\u4f55\u4fee\u6b63\u3002<br \/>\n\u9700\u8981\u8fdb\u884c\u4fee\u6b63\u7684\u5730\u65b9\u662f\u8bbe\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u7684\u3001\u548c\u3002<\/p>\n<ul class=\"post-ul\">\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\uff1aC:\\work\\demo-database-postgresql\\demo-database-postgresql-initdb\\pom.xml<\/ul>\n<pre class=\"post-pre\"><code>        <span class=\"nt\">&lt;profile&gt;<\/span>\r\n            <span class=\"nt\">&lt;id&gt;<\/span>local-postgres<span class=\"nt\">&lt;\/id&gt;<\/span>\r\n            <span class=\"nt\">&lt;activation&gt;<\/span>\r\n                <span class=\"nt\">&lt;activeByDefault&gt;<\/span>true<span class=\"nt\">&lt;\/activeByDefault&gt;<\/span>\r\n            <span class=\"nt\">&lt;\/activation&gt;<\/span>\r\n            <span class=\"nt\">&lt;properties&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.encoding&gt;<\/span>UTF8<span class=\"nt\">&lt;\/db.encoding&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.basedir&gt;<\/span>${project.basedir}\/src\/main\/sqls\/postgres<span class=\"nt\">&lt;\/db.basedir&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.url&gt;<\/span>jdbc:postgresql:\/\/127.0.0.1:5432\/projectName<span class=\"nt\">&lt;\/db.url&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.username&gt;<\/span>postgres<span class=\"nt\">&lt;\/db.username&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.password&gt;<\/span>P0stgres<span class=\"nt\">&lt;\/db.password&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.driver&gt;<\/span>org.postgresql.Driver<span class=\"nt\">&lt;\/db.driver&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.groupId&gt;<\/span>org.postgresql<span class=\"nt\">&lt;\/db.groupId&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.artifactId&gt;<\/span>postgresql<span class=\"nt\">&lt;\/db.artifactId&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.version&gt;<\/span>${postgresql.version}<span class=\"nt\">&lt;\/db.version&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.delimiterType&gt;<\/span>row<span class=\"nt\">&lt;\/db.delimiterType&gt;<\/span>\r\n            <span class=\"nt\">&lt;\/properties&gt;<\/span>\r\n        <span class=\"nt\">&lt;\/profile&gt;<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>        <span class=\"nt\">&lt;profile&gt;<\/span>\r\n            <span class=\"nt\">&lt;id&gt;<\/span>local-postgres<span class=\"nt\">&lt;\/id&gt;<\/span>\r\n            <span class=\"nt\">&lt;activation&gt;<\/span>\r\n                <span class=\"nt\">&lt;activeByDefault&gt;<\/span>true<span class=\"nt\">&lt;\/activeByDefault&gt;<\/span>\r\n            <span class=\"nt\">&lt;\/activation&gt;<\/span>\r\n            <span class=\"nt\">&lt;properties&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.encoding&gt;<\/span>UTF8<span class=\"nt\">&lt;\/db.encoding&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.basedir&gt;<\/span>${project.basedir}\/src\/main\/sqls\/postgres<span class=\"nt\">&lt;\/db.basedir&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.url&gt;<\/span>jdbc:postgresql:\/\/127.0.0.1:5432\/demodb<span class=\"nt\">&lt;\/db.url&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.username&gt;<\/span>demoUser<span class=\"nt\">&lt;\/db.username&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.password&gt;<\/span>demoPass<span class=\"nt\">&lt;\/db.password&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.driver&gt;<\/span>org.postgresql.Driver<span class=\"nt\">&lt;\/db.driver&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.groupId&gt;<\/span>org.postgresql<span class=\"nt\">&lt;\/db.groupId&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.artifactId&gt;<\/span>postgresql<span class=\"nt\">&lt;\/db.artifactId&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.version&gt;<\/span>${postgresql.version}<span class=\"nt\">&lt;\/db.version&gt;<\/span>\r\n                <span class=\"nt\">&lt;db.delimiterType&gt;<\/span>row<span class=\"nt\">&lt;\/db.delimiterType&gt;<\/span>\r\n            <span class=\"nt\">&lt;\/properties&gt;<\/span>\r\n        <span class=\"nt\">&lt;\/profile&gt;<\/span>\r\n<\/code><\/pre>\n<h2>10. \u4f7f\u7528initdb\u9879\u76ee\u6784\u5efa\u6570\u636e\u5e93\uff08\u9009\u9879\uff09\u3002<\/h2>\n<h3>10.1. \u521b\u5efa\u7528\u4e8e\u6570\u636e\u5e93\u6784\u5efa\u7684DDL<\/h3>\n<p>\u5728\u69cb\u5efa\u6570\u636e\u5e93\u65f6\uff0c\u4f7f\u7528\u7684DDL\u5c06\u5b58\u50a8\u5728\u524d\u8ff0\u7684\u6307\u5b9a\u7684\u76ee\u5f55\u4e2d\u3002\u5728\u672c\u4f8b\u4e2d\uff0c\u76ee\u5f55\u4e3aC:\\work\\demo-database-postgresql\\demo-database-postgresql-initdb\\src\\main\\sqls\\postgres\u3002\u7531\u4e8e\u8be5\u76ee\u5f55\u5728\u521d\u59cb\u72b6\u6001\u4e0b\u4e0d\u5b58\u5728\uff0c\u9700\u8981\u521b\u5efa\u8be5\u76ee\u5f55\u3002<\/p>\n<div>\n<div class=\"post-table\">\u9805\u756a\u30d5\u30a1\u30a4\u30eb\u540d\u5099\u8003100000_drop_all_tables.sql\u30c6\u30fc\u30d6\u30eb\u3092\u524a\u9664\u3059\u308bDDL\u3092\u8a18\u8ff0\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002200100_create_all_tables.sql\u5fc5\u8981\u306a\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308bDDL\u3092\u8a18\u8ff0\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002300200_insert_employee.sql\u7279\u5b9a\u30c6\u30fc\u30d6\u30eb\uff08employee\uff09\u306e\u521d\u671f\u30c7\u30fc\u30bf\u3092\u767b\u9332\u3059\u308bSQL\u3092\u8a18\u8ff0\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002<\/div>\n<\/div>\n<p>\u4e3a\u4e86\u6309\u7167\u6587\u4ef6\u540d\u6392\u5e8f\u5e76\u9010\u4e00\u6267\u884c\uff0c\u8bf7\u5728\u547d\u540d\u6587\u4ef6\u65f6\u6ce8\u610f\u6267\u884c\u987a\u5e8f\u3002<br \/>\n\u867d\u7136\u672c\u6b21\u672a\u521b\u5efa\uff0c\u4f46\u5982\u6709\u9700\u8981\uff0c\u8bf7\u51c6\u5907\u7528\u4e8e\u521b\u5efa\u987a\u5e8f\u6216\u7d22\u5f15\u7684DDL\u3002<\/p>\n<pre class=\"post-pre\"><code>\r\n<span class=\"k\">DROP<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">IF<\/span> <span class=\"k\">EXISTS<\/span> <span class=\"n\">employee<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>\r\n<span class=\"c1\">-- \u793e\u54e1\u30c6\u30fc\u30d6\u30eb --<\/span>\r\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">employee<\/span> <span class=\"p\">(<\/span>\r\n    <span class=\"c1\">-- \u793e\u54e1ID<\/span>\r\n    <span class=\"n\">employee_id<\/span>    <span class=\"nb\">varchar<\/span><span class=\"p\">(<\/span><span class=\"mi\">10<\/span><span class=\"p\">)<\/span>    <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"c1\">-- \u6c0f\u540d<\/span>\r\n    <span class=\"n\">name<\/span>           <span class=\"nb\">varchar<\/span><span class=\"p\">(<\/span><span class=\"mi\">30<\/span><span class=\"p\">)<\/span>    <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"c1\">-- \u5165\u793e\u65e5<\/span>\r\n    <span class=\"n\">register_date<\/span>  <span class=\"nb\">date<\/span>           <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"c1\">-- \u30dd\u30a4\u30f3\u30c8<\/span>\r\n    <span class=\"n\">point<\/span>          <span class=\"nb\">numeric<\/span><span class=\"p\">(<\/span><span class=\"mi\">3<\/span><span class=\"p\">,<\/span><span class=\"mi\">0<\/span><span class=\"p\">)<\/span>   <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"c1\">-- \u4e3b\u30ad\u30fc\u5236\u7d04<\/span>\r\n    <span class=\"k\">CONSTRAINT<\/span> <span class=\"n\">EMPLOYEE_PK<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">(<\/span><span class=\"n\">employee_id<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">);<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>\r\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">employee<\/span> <span class=\"p\">(<\/span><span class=\"n\">employee_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"n\">register_date<\/span><span class=\"p\">,<\/span> <span class=\"n\">point<\/span><span class=\"p\">)<\/span> <span class=\"k\">VALUES<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'0000000777'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'\u8a66\u9a13 \u592a\u90ce'<\/span><span class=\"p\">,<\/span> <span class=\"n\">to_date<\/span><span class=\"p\">(<\/span><span class=\"s1\">'2016\/04\/01'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'yyyy\/MM\/dd'<\/span><span class=\"p\">),<\/span> <span class=\"mi\">10<\/span><span class=\"p\">);<\/span>\r\n<span class=\"k\">COMMIT<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<h3>10.2. \u4f7f\u7528mvn sql:execute\u547d\u4ee4\u6765\u6784\u5efa\u6570\u636e\u5e93\u3002<\/h3>\n<p>\u5728initdb\u9879\u76ee\u4e2d\u8fd0\u884cmvn sql:execute\u547d\u4ee4\u65f6\uff0c\u5c06\u6267\u884c\u524d\u8ff0\u51c6\u5907\u7684DDL\uff0c\u5b8c\u6210\u6570\u636e\u5e93\u7684\u6784\u5efa\u548c\u521d\u59cb\u5316\u64cd\u4f5c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">C:\\work\\demo-database-postgresql\\demo-database-postgresql-initdb&gt;<\/span>mvn sql:execute\r\n<span class=\"go\">[INFO] Scanning for projects...\r\n[INFO]\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] Building demo-database-postgresql-initdb 1.0.0-SNAPSHOT\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO]\r\n[INFO] --- sql-maven-plugin:1.5:execute (default-cli) @ demo-database-postgresql-initdb ---\r\n[INFO] Executing file: C:\\work\\demo-database-postgresql\\demo-database-postgresql-initdb\\src\\main\\sqls\\postgres\\00000_dro\r\np_all_tables.sql\r\n[INFO] Executing file: C:\\work\\demo-database-postgresql\\demo-database-postgresql-initdb\\src\\main\\sqls\\postgres\\00100_cre\r\nate_all_tables.sql\r\n[INFO] Executing file: C:\\work\\demo-database-postgresql\\demo-database-postgresql-initdb\\src\\main\\sqls\\postgres\\00200_ins\r\nert_employee.sql\r\n[INFO] 3 of 3 SQL statements executed successfully\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] BUILD SUCCESS\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] Total time: 1.217 s\r\n[INFO] Finished at: 2017-08-31T10:56:24+09:00\r\n[INFO] Final Memory: 8M\/20M\r\n[INFO] ------------------------------------------------------------------------\r\n\r\n<\/span><span class=\"gp\">C:\\work\\demo-database-postgresql\\demo-database-postgresql-initdb&gt;<\/span>\r\n<\/code><\/pre>\n<p>\u8bf7\u786e\u8ba4\u5df2\u6210\u529f\u6267\u884c\u4e863\u4e2aSQL\u8bed\u53e5\u5e76\u4e14\u5df2\u7ecf\u987a\u5229\u7ed3\u675f\uff0c\u4e5f\u786e\u8ba4\u4e86BUILD SUCCESS\u3002<\/p>\n<h2>11. \u8bd5\u7528\u7248\u672c\u5efa\u9020<\/h2>\n<p>\u4e3a\u4e86\u652f\u6301PostgreSQL\uff0c\u6211\u4eec\u4fee\u6539\u4e86\u8bb8\u591a\u914d\u7f6e\u6587\u4ef6\u3002\u4e3a\u4e86\u786e\u8ba4\u6ca1\u6709\u4efb\u4f55\u95ee\u9898\uff0c\u6211\u4eec\u5c06\u8fdb\u884c\u8bd5\u9a8c\u6027\u6784\u5efa\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">C:\\work\\demo-database-postgresql&gt;<\/span>mvn package\r\n<span class=\"go\">[INFO] Scanning for projects...\r\n\r\n... \u7701\u7565 ...\r\n\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] Reactor Summary:\r\n[INFO]\r\n[INFO] TERASOLUNA Server Framework for Java (5.x) Web Blank Multi Project (MyBatis3) SUCCESS [  0.015 s]\r\n[INFO] demo-database-postgresql-env ....................... SUCCESS [  1.248 s]\r\n[INFO] demo-database-postgresql-domain .................... SUCCESS [  0.359 s]\r\n[INFO] demo-database-postgresql-web ....................... SUCCESS [  4.883 s]\r\n[INFO] demo-database-postgresql-initdb .................... SUCCESS [  0.031 s]\r\n[INFO] demo-database-postgresql-selenium .................. SUCCESS [  2.090 s]\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] BUILD SUCCESS\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] Total time: 9.048 s\r\n[INFO] Finished at: 2017-08-31T10:57:46+09:00\r\n[INFO] Final Memory: 35M\/84M\r\n[INFO] ------------------------------------------------------------------------\r\n\r\n<\/span><span class=\"gp\">C:\\work\\demo-database-postgresql&gt;<\/span>\r\n<\/code><\/pre>\n<p>\u53ea\u8981\u51fa\u73b0\u201c\u6784\u5efa\u6210\u529f\u201d\uff0c\u5c31\u53ef\u4ee5\u786e\u8ba4\u5728\u6784\u5efa\u8fc7\u7a0b\u4e2d\u6ca1\u6709\u53d1\u73b0\u4efb\u4f55\u95ee\u9898\u6240\u5728\u3002<\/p>\n<h2>\u8bd5\u542f\u52a8<\/h2>\n<p>\u5982\u679c\u8bd5\u7528\u7248\u672c\u7684\u6784\u5efa\u6b63\u5e38\u5b8c\u6210\uff0c\u5219\u4f1a\u6709C:\\work\\demo-database-postgresql\\demo-database-postgresql-web\\target\\demo-database-postgresql-web.war\u6587\u4ef6\u5b58\u5728\u3002\u6211\u4eec\u5c06\u628ademo-database-postgresql-web.war\u6587\u4ef6\u590d\u5236\u5230Tomcat\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684\/webapps\u76ee\u5f55\u4e2d\u8fdb\u884c\u90e8\u7f72\u3002<\/p>\n<p>\u8fd0\u884cTomcat\u5b89\u88c5\u76ee\u5f55\/bin\/startup.bat\uff0c\u542f\u52a8Tomcat\u3002<br \/>\n\u4f7f\u7528Web\u6d4f\u89c8\u5668\u8bbf\u95eehttp:\/\/localhost:8080\/demo-database-postgresql-web\/\uff0c\u5982\u679c\u663e\u793a\u9ed8\u8ba4\u9875\u9762\u4e0a\u7684\u201cHello world!\u201d\uff0c\u5219\u8868\u793a\u6210\u529f\u3002<\/p>\n<h2>13. \u6700\u540e<\/h2>\n<p>\u672c\u6b21\u8bb2\u89e3\u4e86\u5982\u4f55\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5\u3002\u901a\u5e38\u60c5\u51b5\u4e0b\uff0c\u53ea\u9700\u8981\u5728\u521b\u5efa\u9879\u76ee\u65f6\u8fdb\u884c\u4e00\u6b21\u6570\u636e\u5e93\u8bbe\u7f6e\uff0c\u56e0\u6b64\u673a\u4f1a\u5e76\u4e0d\u591a\u3002\u7136\u800c\uff0c\u5982\u679c\u9879\u76ee\u7684\u521d\u59cb\u8bbe\u7f6e\u672a\u5b8c\u6210\uff0c\u5c31\u65e0\u6cd5\u8fdb\u884c\u5e94\u7528\u7a0b\u5e8f\uff08\u4e1a\u52a1\u5904\u7406\uff09\u7684\u5f00\u53d1\uff0c\u56e0\u6b64\u5e0c\u671b\u80fd\u8fc5\u901f\u5e94\u5bf9\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148 \u5728TERASOLUNA Server Framework for Java (5.x)\u7684\u7a7a\u767d\u9879\u76ee\u7684\u521d\u59cb\u72b6 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41767","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06terasoluna5-x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301postgresql\u7684\u65b9\u6cd5\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u5728TERASOLUNA Server Framework for Java (5.x)\u7684\u7a7a\u767d\u9879\u76ee\u7684\u521d\u59cb\u72b6 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06terasoluna5-x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301postgresql\u7684\u65b9\u6cd5\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-20T04:52:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T18:43:55+00:00\" \/>\n<meta name=\"author\" content=\"\u79d1, \u9896\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u9896\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/\",\"name\":\"\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-08-20T04:52:49+00:00\",\"dateModified\":\"2024-04-29T18:43:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\",\"name\":\"\u79d1, \u9896\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u9896\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06terasoluna5-x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301postgresql\u7684\u65b9\u6cd5\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5","og_description":"\u9996\u5148 \u5728TERASOLUNA Server Framework for Java (5.x)\u7684\u7a7a\u767d\u9879\u76ee\u7684\u521d\u59cb\u72b6 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06terasoluna5-x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301postgresql\u7684\u65b9\u6cd5\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-08-20T04:52:49+00:00","article_modified_time":"2024-04-29T18:43:55+00:00","author":"\u79d1, \u9896","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u9896","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"9 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/","name":"\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-08-20T04:52:49+00:00","dateModified":"2024-04-29T18:43:55+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5c06TERASOLUNA5.x\u7684\u7a7a\u767d\u9879\u76ee\u66f4\u6539\u4e3a\u652f\u6301PostgreSQL\u7684\u65b9\u6cd5"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e","name":"\u79d1, \u9896","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","caption":"\u79d1, \u9896"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86terasoluna5-x%e7%9a%84%e7%a9%ba%e7%99%bd%e9%a1%b9%e7%9b%ae%e6%9b%b4%e6%94%b9%e4%b8%ba%e6%94%af%e6%8c%81postgresql%e7%9a%84%e6%96%b9%e6%b3%95\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41767"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41767\/revisions"}],"predecessor-version":[{"id":89203,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41767\/revisions\/89203"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}