datasource.html 12.6 KB

Raw Blame History Permalink

<!DOCTYPE html>
<html>
<head>
<title>datasource.md</title>
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">

<style>
/*---------------------------------------------------------------------------------------------
 *  Copyright (c) Microsoft Corporation. All rights reserved.
 *  Licensed under the MIT License. See License.txt in the project root for license information.
 *--------------------------------------------------------------------------------------------*/

body {
	font-family: "Segoe WPC", "Segoe UI", "SFUIText-Light", "HelveticaNeue-Light", sans-serif, "Droid Sans Fallback";
	font-size: 14px;
	padding: 0 12px;
	line-height: 22px;
	word-wrap: break-word;
}

#code-csp-warning {
	position: fixed;
	top: 0;
	right: 0;
	color: white;
	margin: 16px;
	text-align: center;
	font-size: 12px;
	font-family: sans-serif;
	background-color:#444444;
	cursor: pointer;
	padding: 6px;
	box-shadow: 1px 1px 1px rgba(0,0,0,.25);
}

#code-csp-warning:hover {
	text-decoration: none;
	background-color:#007acc;
	box-shadow: 2px 2px 2px rgba(0,0,0,.25);
}


body.scrollBeyondLastLine {
	margin-bottom: calc(100vh - 22px);
}

body.showEditorSelection .code-line {
	position: relative;
}

body.showEditorSelection .code-active-line:before,
body.showEditorSelection .code-line:hover:before {
	content: "";
	display: block;
	position: absolute;
	top: 0;
	left: -12px;
	height: 100%;
}

body.showEditorSelection li.code-active-line:before,
body.showEditorSelection li.code-line:hover:before {
	left: -30px;
}

.vscode-light.showEditorSelection .code-active-line:before {
	border-left: 3px solid rgba(0, 0, 0, 0.15);
}

.vscode-light.showEditorSelection .code-line:hover:before {
	border-left: 3px solid rgba(0, 0, 0, 0.40);
}

.vscode-dark.showEditorSelection .code-active-line:before {
	border-left: 3px solid rgba(255, 255, 255, 0.4);
}

.vscode-dark.showEditorSelection .code-line:hover:before {
	border-left: 3px solid rgba(255, 255, 255, 0.60);
}

.vscode-high-contrast.showEditorSelection .code-active-line:before {
	border-left: 3px solid rgba(255, 160, 0, 0.7);
}

.vscode-high-contrast.showEditorSelection .code-line:hover:before {
	border-left: 3px solid rgba(255, 160, 0, 1);
}

img {
	max-width: 100%;
	max-height: 100%;
}

a {
	color: #4080D0;
	text-decoration: none;
}

a:focus,
input:focus,
select:focus,
textarea:focus {
	outline: 1px solid -webkit-focus-ring-color;
	outline-offset: -1px;
}

hr {
	border: 0;
	height: 2px;
	border-bottom: 2px solid;
}

h1 {
	padding-bottom: 0.3em;
	line-height: 1.2;
	border-bottom-width: 1px;
	border-bottom-style: solid;
}

h1, h2, h3 {
	font-weight: normal;
}

h1 code,
h2 code,
h3 code,
h4 code,
h5 code,
h6 code {
	font-size: inherit;
	line-height: auto;
}

a:hover {
	color: #4080D0;
	text-decoration: underline;
}

table {
	border-collapse: collapse;
}

table > thead > tr > th {
	text-align: left;
	border-bottom: 1px solid;
}

table > thead > tr > th,
table > thead > tr > td,
table > tbody > tr > th,
table > tbody > tr > td {
	padding: 5px 10px;
}

table > tbody > tr + tr > td {
	border-top: 1px solid;
}

blockquote {
	margin: 0 7px 0 5px;
	padding: 0 16px 0 10px;
	border-left: 5px solid;
}

code {
	font-family: Menlo, Monaco, Consolas, "Droid Sans Mono", "Courier New", monospace, "Droid Sans Fallback";
	font-size: 14px;
	line-height: 19px;
}

body.wordWrap pre {
	white-space: pre-wrap;
}

.mac code {
	font-size: 12px;
	line-height: 18px;
}

pre:not(.hljs),
pre.hljs code > div {
	padding: 16px;
	border-radius: 3px;
	overflow: auto;
}

/** Theming */

.vscode-light,
.vscode-light pre code {
	color: rgb(30, 30, 30);
}

.vscode-dark,
.vscode-dark pre code {
	color: #DDD;
}

.vscode-high-contrast,
.vscode-high-contrast pre code {
	color: white;
}

.vscode-light code {
	color: #A31515;
}

.vscode-dark code {
	color: #D7BA7D;
}

.vscode-light pre:not(.hljs),
.vscode-light code > div {
	background-color: rgba(220, 220, 220, 0.4);
}

.vscode-dark pre:not(.hljs),
.vscode-dark code > div {
	background-color: rgba(10, 10, 10, 0.4);
}

.vscode-high-contrast pre:not(.hljs),
.vscode-high-contrast code > div {
	background-color: rgb(0, 0, 0);
}

.vscode-high-contrast h1 {
	border-color: rgb(0, 0, 0);
}

.vscode-light table > thead > tr > th {
	border-color: rgba(0, 0, 0, 0.69);
}

.vscode-dark table > thead > tr > th {
	border-color: rgba(255, 255, 255, 0.69);
}

.vscode-light h1,
.vscode-light hr,
.vscode-light table > tbody > tr + tr > td {
	border-color: rgba(0, 0, 0, 0.18);
}

.vscode-dark h1,
.vscode-dark hr,
.vscode-dark table > tbody > tr + tr > td {
	border-color: rgba(255, 255, 255, 0.18);
}

.vscode-light blockquote,
.vscode-dark blockquote {
	background: rgba(127, 127, 127, 0.1);
	border-color: rgba(0, 122, 204, 0.5);
}

.vscode-high-contrast blockquote {
	background: transparent;
	border-color: #fff;
}
</style>
<link rel="stylesheet" href="file:///file%3A///D%3A/Program%20Files/Microsoft%20VS%20Code/css/def.css" type="text/css">
<style>
/* Tomorrow Theme */
/* http://jmblog.github.com/color-themes-for-google-code-highlightjs */
/* Original theme - https://github.com/chriskempson/tomorrow-theme */

/* Tomorrow Comment */
.hljs-comment,
.hljs-quote {
	color: #8e908c;
}

/* Tomorrow Red */
.hljs-variable,
.hljs-template-variable,
.hljs-tag,
.hljs-name,
.hljs-selector-id,
.hljs-selector-class,
.hljs-regexp,
.hljs-deletion {
	color: #c82829;
}

/* Tomorrow Orange */
.hljs-number,
.hljs-built_in,
.hljs-builtin-name,
.hljs-literal,
.hljs-type,
.hljs-params,
.hljs-meta,
.hljs-link {
	color: #f5871f;
}

/* Tomorrow Yellow */
.hljs-attribute {
	color: #eab700;
}

/* Tomorrow Green */
.hljs-string,
.hljs-symbol,
.hljs-bullet,
.hljs-addition {
	color: #718c00;
}

/* Tomorrow Blue */
.hljs-title,
.hljs-section {
	color: #4271ae;
}

/* Tomorrow Purple */
.hljs-keyword,
.hljs-selector-tag {
	color: #8959a8;
}

.hljs {
	display: block;
	overflow-x: auto;
	color: #4d4d4c;
	padding: 0.5em;
}

.hljs-emphasis {
	font-style: italic;
}

.hljs-strong {
	font-weight: bold;
}
</style>

<style>
/*
 * Markdown PDF CSS
 */

 body {
	font-family:  "Meiryo", "Segoe WPC", "Segoe UI", "SFUIText-Light", "HelveticaNeue-Light", sans-serif, "Droid Sans Fallback";
}

pre {
	background-color: #f8f8f8;
	border: 1px solid #cccccc;
	border-radius: 3px;
	overflow-x: auto;
	white-space: pre-wrap;
	overflow-wrap: break-word;
}

pre:not(.hljs) {
	padding: 23px;
	line-height: 19px;
}

blockquote {
	background: rgba(127, 127, 127, 0.1);
	border-color: rgba(0, 122, 204, 0.5);
}

.emoji {
	height: 1.4em;
}

/* for inline code */
:not(pre):not(.hljs) > code {
	color: #C9AE75; /* Change the old color so it seems less like an error */
	font-size: inherit;
}

/* Page Break : use <div class="page"/> to insert page break
-------------------------------------------------------- */
.page {
	page-break-after: always;
}

</style>
<link rel="stylesheet" href="file:///e%3A/%E8%B5%84%E6%96%99/%E9%9B%86%E6%88%90%E4%B8%AD%E5%BF%83/table.css" type="text/css">
</head>
<body>
<p><font color=#666666 size=5 face="PingFangSC-Regular">数据源设置</font></p>
<ul>
<li><a href="#0">使用场景</a></li>
<li><a href="#1">操作说明</a></li>
<li><a href="#2">开发相关</a></li>
<li><a href="#3">常见问题</a></li>
</ul>
<H3 id=0 style="border-left: 4px solid #3677D5;height:42px;line-height:42px;background:#F4F4F4"><font color=#08C size=4 face="PingFangSC-Semibold" >&emsp;使用场景</font></H3>
<p><strong>数据源设置</strong> 是管理数据库连接信息，方便开发人员和系统使用人员使用所管理的数据库</p>
<H3 id=1 style="border-left: 4px solid #3677D5;height:42px;line-height:42px;background:#F4F4F4"><font color=#08C size=4 face="PingFangSC-Semibold" >&emsp;操作说明</font></H3>
<p>在 <strong>集成中心 - 数据源设置</strong> 中<br>
<img src="image/ds01.png" alt="数据源设置"><br>
点击 <strong>新建</strong> 按钮，弹出 <strong>新建数据源</strong> 页面<br>
<img src="image/ds02.png" alt="数据源设置"><br>
需要填写 <strong>数据源名称</strong>、选择 <strong>数据库类型</strong><br>
目前支持的 <strong>数据库类型</strong> 包括：<strong>sqlserver2000、sqlserver2005、sqlserver2008、oracle、oracle12c、mysql、db2、sybase、informix、hana</strong><br>
<img src="image/ds03.png" alt="数据源设置"></p>
<p>当 <strong>集群/多实例</strong> <strong>未被勾选</strong>  时，需要设置 <strong>服务器IP、端口号、数据库名称</strong><br>
<img src="image/ds04.png" alt="数据源设置"><br>
当 <strong>集群/多实例</strong> <strong>被勾选</strong> 时，需要设置 <strong>连接字符串</strong><br>
<img src="image/ds05.png" alt="数据源设置"></p>
<p><strong>几种常见的数据库连接字符串写法：</strong></p>
<table>
<thead>
<tr>
<th>数据库类型</th>
<th>连接字符串</th>
</tr>
</thead>
<tbody>
<tr>
<td>Oracle</td>
<td>jdbc:oracle:thin:@localhost:1521:orcl</td>
</tr>
<tr>
<td>Sql Server</td>
<td>jdbc:sqlserver://localhost:1433;DatabaseName=ecology</td>
</tr>
<tr>
<td>MySQL</td>
<td>jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=utf8</td>
</tr>
<tr>
<td>DB2</td>
<td>jdbc:db2://localhost:5000/sample</td>
</tr>
<tr>
<td>Sybase</td>
<td>jdbc:sybase:Tds:localhost:5000/mydb?charset=cp936</td>
</tr>
<tr>
<td>Informix</td>
<td>jdbc:informix-sqli://localhost:1533/myDB:INFORMIXSERVER=myserver</td>
</tr>
</tbody>
</table>
<p>当 <strong>数据库不是集群</strong> 时，如下两图的设置都是可以的：<br>
图一<br>
<img src="image/ds06.png" alt="数据源设置"><br>
图二<br>
<img src="image/ds07.png" alt="数据源设置"></p>
<H3 id=2 style="border-left: 4px solid #3677D5;height:42px;line-height:42px;background:#F4F4F4"><font color=#08C size=4 face="PingFangSC-Semibold" >&emsp;开发相关</font></H3>
<ol>
<li><strong>数据库相关</strong><br>
数据源设置数据表： <strong>datasourcesetting</strong></li>
<li><strong>代码相关</strong><br>
数据源设置列表页面： <strong>/servicesetting/datasourcesetting.jsp</strong><br>
数据源接口类： <strong>weaver.interfaces.datasource.DataSource</strong></li>
<li><strong>代码中使用数据源有以下两种方法</strong>：</li>
</ol>
<pre class="hljs"><code><div><span class="hljs-comment">//使用名称为ds的数据源</span>
weaver.conn.RecordSetDataSource rsds = <span class="hljs-keyword">new</span> weaver.conn.RecordSetDataSource(<span class="hljs-string">"数据源名称"</span>);
<span class="hljs-comment">//执行sql语句</span>
rsds.execute(<span class="hljs-string">"select * from tablename"</span>);
</div></code></pre>
<pre class="hljs"><code><div>weaver.interfaces.datasource.DataSource ds = (weaver.interfaces.datasource.DataSource)
    weaver.general.StaticObj.getServiceByFullname((<span class="hljs-string">"datasource.数据源名城"</span>),
        weaver.interfaces.datasource.DataSource.class);
java.sql.Connection conn = ds.getConnection();
<span class="hljs-keyword">try</span> {
    java.sql.PreparedStatement ps = conn.prepareStatement(<span class="hljs-string">"select * from hrmresource"</span>);
    ps.execute();
} <span class="hljs-keyword">catch</span> (Exception e) {
    (<span class="hljs-keyword">new</span> weaver.general.BaseBean()).writeLog(e.getMessage());
}
</div></code></pre>
<H3 id=3 style="border-left: 4px solid #3677D5;height:42px;line-height:42px;background:#F4F4F4"><font color=#08C size=4 face="PingFangSC-Semibold" >&emsp;常见问题</font></H3>
<ol>
<li>Mysql数据库测试不通过<br>
<strong>解决方案：</strong> 检查 <strong>resin\lib</strong>下的mysql的jar包版本，如果是 mysql-connector-java-3.1.11-bin.jar，替换成 mysql-connector-java-5.1.X-bin.jar 版本即可</li>
<li>KB1610之前的版本，datasource.xml配置正确，数据源测试通过，但是实际使用中数据源提示有问题<br>
<strong>解决方案：</strong> 检查 <strong>WEB-INF\service</strong>下 是否存在datasource.xml的备份文件，删除备份文件，重启resin</li>
<li>KB1702之后的版本，数据源中 <strong>Oracle数据库</strong> 添加失败<br>
<strong>解决方案：</strong> 数据库执行以下脚本：</li>
</ol>
<pre class="hljs"><code><div><span class="hljs-keyword">create</span> <span class="hljs-keyword">or</span> <span class="hljs-keyword">replace</span> <span class="hljs-keyword">trigger</span> datasourcesetting_Tri
<span class="hljs-keyword">before</span> <span class="hljs-keyword">insert</span> <span class="hljs-keyword">on</span> datasourcesetting
<span class="hljs-keyword">for</span> <span class="hljs-keyword">each</span> <span class="hljs-keyword">row</span>
<span class="hljs-keyword">begin</span>
    <span class="hljs-keyword">select</span> datasourcesetting_id.nextval <span class="hljs-keyword">into</span> :new.id <span class="hljs-keyword">from</span> dual;
<span class="hljs-keyword">end</span>;
</div></code></pre>

</body>
</html>