📄 weblogic server中oracle的jdbc pool.htm
字号:
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_s1026" type="#_x0000_t75" alt=""
style='position:absolute;margin-left:0;margin-top:0;width:439.5pt;
height:348pt;z-index:1;mso-wrap-distance-left:0;
mso-wrap-distance-right:0;mso-position-horizontal:left;
mso-position-vertical-relative:line' o:allowoverlap="f">
<v:imagedata src="WebLogic%20Server中Oracle的JDBC%20Pool.files/image001.jpg"
o:title="CONN1"/>
<w:wrap type="square"/>
</v:shape><![endif]--><![if !vml]><img width=586 height=464
src="WebLogic%20Server中Oracle的JDBC%20Pool.files/image001.jpg" align=left
v:shapes="_x0000_s1026"><![endif]><span lang=EN-US style='mso-bidi-font-size:
10.5pt;line-height:140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;
mso-font-kerning:0pt'><br clear=left>
<b><br>
Connection</b></span><b><span style='mso-bidi-font-size:10.5pt;
line-height:140%;font-family:宋体;mso-ascii-font-family:\02CE\0325;
mso-hansi-font-family:\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:
0pt'>栏目：</span></b><b><span style='mso-bidi-font-size:10.5pt;line-height:
140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:
0pt'> </span></b><span lang=EN-US style='mso-bidi-font-size:10.5pt;
line-height:140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;
mso-font-kerning:0pt'><br>
<br>
<span class=SpellE>CapacityIncrement</span> = 50<br>
<span class=SpellE>MaxCapacity</span> = 100<br>
Capacity Increment: 5 <br>
Login Delay Seconds: 0 seconds <br>
Refresh Period: 10 minutes <br>
Supports Local Transaction </span><span style='mso-bidi-font-size:10.5pt;
line-height:140%;font-family:宋体;mso-ascii-font-family:\02CE\0325;
mso-hansi-font-family:\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:
0pt'>不要打勾</span><span lang=EN-US style='mso-bidi-font-size:10.5pt;
line-height:140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;
mso-font-kerning:0pt'> <br>
Allow Shrinking </span><span style='mso-bidi-font-size:10.5pt;line-height:
140%;font-family:宋体;mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'>打勾</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'> <br>
Shrink Period: 15 minutes <br>
Prepared Statement Cache Size: 5 <o:p></o:p></span></p>
<p class=MsoNormal align=left style='mso-margin-top-alt:auto;margin-bottom:
12.0pt;text-align:left;line-height:140%;mso-pagination:widow-orphan'><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>如图：</span><span lang=EN-US
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'><o:p></o:p></span></p>
<p class=MsoNormal align=left style='mso-margin-top-alt:auto;margin-bottom:
12.0pt;text-align:left;line-height:140%;mso-pagination:widow-orphan'><!--[if gte vml 1]><v:shape
id="_x0000_s1027" type="#_x0000_t75" alt="" style='position:absolute;
margin-left:-24.75pt;margin-top:-1308.75pt;width:401.25pt;height:337.5pt;
z-index:2;mso-wrap-distance-left:0;mso-wrap-distance-right:0;
mso-position-vertical-relative:line' o:allowoverlap="f">
<v:imagedata src="WebLogic%20Server中Oracle的JDBC%20Pool.files/image002.jpg"
o:title="CONN2"/>
<w:wrap type="square"/>
</v:shape><![endif]--><![if !vml]><img width=535 height=450
src="WebLogic%20Server中Oracle的JDBC%20Pool.files/image002.jpg" align=left
v:shapes="_x0000_s1027"><![endif]><span lang=EN-US style='mso-bidi-font-size:
10.5pt;line-height:140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;
mso-font-kerning:0pt'><br clear=left>
</span><span lang=EN-US style='font-size:13.5pt;line-height:140%;
font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt'><br>
</span><span lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:
140%;font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:
0pt'>Test栏目： <br>
<br>
<span class=SpellE>TestTableName</span>：SCOTT.EMP （这里需要改动，适应你自己的表，<span
class=SpellE>wls</span>用来做连接测试用的） <br>
<span class=SpellE>TestConnectionsOnReleasetrue</span> 打勾<br>
<span class=SpellE>TestConnectionsOnReservetrue</span> 打勾<br>
<br>
最后，点击Apply，然后去Targets，选中你的server，<span class=GramE>点右箭头</span>，使你的server进入Chosen栏目，最后Apply。（如图）
</span><span lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:
140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:
0pt'><o:p></o:p></span></p>
<p class=MsoNormal align=left style='mso-margin-top-alt:auto;text-align:
left;line-height:140%;mso-pagination:widow-orphan'><!--[if gte vml 1]><v:shape
id="_x0000_s1028" type="#_x0000_t75" alt="" style='position:absolute;
margin-left:-24.75pt;margin-top:-1833pt;width:386.25pt;height:225pt;
z-index:3;mso-wrap-distance-left:0;mso-wrap-distance-right:0;
mso-position-vertical-relative:line' o:allowoverlap="f">
<v:imagedata src="WebLogic%20Server中Oracle的JDBC%20Pool.files/image003.jpg"
o:title="CONN3"/>
<w:wrap type="square"/>
</v:shape><![endif]--><![if !vml]><img width=515 height=300
src="WebLogic%20Server中Oracle的JDBC%20Pool.files/image003.jpg" align=left
v:shapes="_x0000_s1028"><![endif]><span lang=EN-US style='mso-bidi-font-size:
10.5pt;line-height:140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;
mso-font-kerning:0pt'><br clear=left>
</span><span lang=EN-US style='font-size:13.5pt;line-height:140%;
font-family:宋体;mso-bidi-font-family:宋体;color:maroon;mso-font-kerning:
0pt'><br>
</span><span style='mso-bidi-font-size:10.5pt;line-height:140%;
font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt'>查看<span
lang=EN-US>dos窗口，是否有错误，如果没有则继续，如果有的话，自己查看填写的内容。</span></span><span
style='font-size:13.5pt;line-height:140%;font-family:宋体;mso-bidi-font-family:
宋体;color:maroon;mso-font-kerning:0pt'> </span><span lang=EN-US
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'><o:p></o:p></span></p>
<p class=MsoNormal align=left style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;text-align:left;line-height:140%;mso-pagination:widow-orphan'><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>至此，</span><span lang=EN-US
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>Connection Pool</span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>已经配置完毕。</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'> <br>
<br>
<br>
</span><span style='mso-bidi-font-size:10.5pt;line-height:140%;
font-family:宋体;mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'>接下来，该配置</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'>(TX)<span
class=SpellE>DataSource</span></span><span style='mso-bidi-font-size:
10.5pt;line-height:140%;font-family:宋体;mso-ascii-font-family:\02CE\0325;
mso-hansi-font-family:\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:
0pt'>了。</span><span lang=EN-US style='mso-bidi-font-size:10.5pt;
line-height:140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;
mso-font-kerning:0pt'> <o:p></o:p></span></p>
<p class=MsoNormal align=left style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;text-align:left;line-height:140%;mso-pagination:widow-orphan'><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>从昨天的</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'>panel</span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>里边，单击</span><span
class=SpellE><span lang=EN-US style='mso-bidi-font-size:10.5pt;
line-height:140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;
mso-font-kerning:0pt'>DataSources</span></span><span lang=EN-US
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>/TX <span class=SpellE>DataSources</span></span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>，进入配置界面。</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'><o:p></o:p></span></p>
<p class=MsoNormal align=left style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;text-align:left;line-height:140%;mso-pagination:widow-orphan'><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'>1</span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>。单击</span><span lang=EN-US
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>Configure a new JDBC <span
class=SpellE>Tx</span> Data Source..</span><span style='mso-bidi-font-size:
10.5pt;line-height:140%;font-family:宋体;mso-ascii-font-family:\02CE\0325;
mso-hansi-font-family:\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:
0pt'>配置新的</span><span class=SpellE><span lang=EN-US style='mso-bidi-font-size:
10.5pt;line-height:140%;font-family:\02CE\0325;mso-bidi-font-family:宋体;
mso-font-kerning:0pt'>datasource</span></span><span lang=EN-US
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'><br>
<br>
2</span><span style='mso-bidi-font-size:10.5pt;line-height:140%;
font-family:宋体;mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'>。填入以下数据：</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'><br>
Name: <span class=SpellE>MyDataSource</span> </span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>（自己随便起的）</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'><br>
JNDI: <span class=SpellE>jdbc/OracleDS</span> </span><span class=GramE><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>（</span></span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>这里就是你</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'>lookup</span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>的时候填入的名字，自己想吧。</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'><br>
Pool Name: <span class=SpellE>MyOracle_CP</span> </span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>（一定要对应你的</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'>Connection Pool</span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>的</span><span lang=EN-US
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'> Name</span><span
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:宋体;
mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'>）</span><span lang=EN-US
style='mso-bidi-font-size:10.5pt;line-height:140%;font-family:\02CE\0325;
mso-bidi-font-family:宋体;mso-font-kerning:0pt'><br>
<br>
</span><span style='mso-bidi-font-size:10.5pt;line-height:140%;
font-family:宋体;mso-ascii-font-family:\02CE\0325;mso-hansi-font-family:
\02CE\0325;mso-bidi-font-family:宋体;mso-font-kerning:0pt'>把后边两项打<span
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -