?? 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 + -