<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 12"><meta name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5Cwyang%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5Cwyang%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Cwyang%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>
<!--
/* Font Definitions */
@font-face
{font-family:宋体;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 680460288 22 0 262145 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:1;
mso-generic-font-family:roman;
mso-font-format:other;
mso-font-pitch:variable;
mso-font-signature:0 0 0 0 0 0;}
@font-face
{font-family:"\@宋体";
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 680460288 22 0 262145 0;}
@font-face
{font-family:"MS PGothic";
panose-1:2 11 6 0 7 2 5 8 2 4;
mso-font-charset:128;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536870145 1791491579 18 0 131231 0;}
@font-face
{font-family:"YaHei Consolas Hybrid";
panose-1:2 11 5 9 2 2 4 2 2 4;
mso-font-charset:134;
mso-generic-font-family:modern;
mso-font-pitch:fixed;
mso-font-signature:-2147483001 705641554 22 0 262175 0;}
@font-face
{font-family:"\@MS PGothic";
panose-1:2 11 6 0 7 2 5 8 2 4;
mso-font-charset:128;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536870145 1791491579 18 0 131231 0;}
@font-face
{font-family:"\@YaHei Consolas Hybrid";
panose-1:2 11 5 9 2 2 4 2 2 4;
mso-font-charset:134;
mso-generic-font-family:modern;
mso-font-pitch:fixed;
mso-font-signature:-2147483001 705641554 22 0 262175 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
text-align:justify;
text-justify:inter-ideograph;
mso-pagination:widow-orphan;
font-size:10.5pt;
font-family:"MS PGothic","sans-serif";
mso-bidi-font-family:宋体;}
p.mystyle000000, li.mystyle000000, div.mystyle000000
{mso-style-name:mystyle000000;
mso-style-unhide:no;
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"MS PGothic","sans-serif";
mso-bidi-font-family:宋体;
color:#244BAC;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
mso-ascii-font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";
mso-font-kerning:0pt;}
/* Page Definitions */
@page
{mso-page-border-surround-header:no;
mso-page-border-surround-footer:no;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<p class="mystyle000000" style="margin: 0cm 10.5pt 0.0001pt;"><span lang="EN-US">Hi, all:</span></p>
<p class="mystyle000000" style="margin: 0cm 10.5pt 0.0001pt;"><span lang="EN-US">
I try to use </span><span style="font-family: "Courier New";" lang="EN-US">DatabaseMetaData</span><span lang="EN-US"> to get all tables and views from a Oracle database. But exception is
thrown at the red line. You can see that I look up a remote DataSource and get
connection from the data source. But if I use </span><b><span style="font-family: "Courier New";" lang="EN-US">DriverManager.getConnection(url, user, pwd)</span></b><span lang="EN-US"> way to get connection. This issue does not exist. I can get all the
tables and views successfully</span>… <br></p>
<p class="mystyle000000" style="margin: 0cm 10.5pt 0.0001pt;"><span lang="EN-US">
Any help from you will be much appreciated!</span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span lang="EN-US"></span><b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(127, 0, 85);" lang="EN-US">public</span></b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> </span><b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(127, 0, 85);" lang="EN-US">class</span></b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> Test {</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> </span><b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(127, 0, 85);" lang="EN-US">public</span></b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> </span><b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(127, 0, 85);" lang="EN-US">static</span></b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> </span><b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(127, 0, 85);" lang="EN-US">void</span></b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> main(String[] args) </span><b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(127, 0, 85);" lang="EN-US">throws</span></b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> Exception {</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> Properties props = </span><b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(127, 0, 85);" lang="EN-US">new</span></b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> Properties();</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> props.put(Context.</span><i><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(0, 0, 192);" lang="EN-US">PROVIDER_URL</span></i><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US">, </span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(42, 0, 255);" lang="EN-US">"jnp://<a href="http://10.111.3.161:1099">10.111.3.161:1099</a>"</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US">);</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> props.put(Context.</span><i><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(0, 0, 192);" lang="EN-US">INITIAL_CONTEXT_FACTORY</span></i><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US">, </span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(42, 0, 255);" lang="EN-US">"org.jnp.interfaces.NamingContextFactory"</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US">);</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> Context ctx = </span><b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(127, 0, 85);" lang="EN-US">new</span></b><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> InitialContext(props);</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> DataSource ds = (DataSource)ctx.lookup(</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: rgb(42, 0, 255);" lang="EN-US">"OracleDS"</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US">);</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> Connection conn =
ds.getConnection();</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> <span style="background: silver none repeat scroll 0% 0%; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous;">DatabaseMetaData</span> dbmd = conn.getMetaData();</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> </span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: red;" lang="EN-US">ResultSet <u>rs</u> = dbmd.getTables(<b>null</b>, "%",
"%", <b>new</b> String[] { "TABLE", "VIEW" });</span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US"> }</span><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid";" lang="EN-US"></span></p>
<p class="mystyle000000" style="margin: 0cm 10.5pt 0.0001pt;"><span style="font-size: 11pt; font-family: "YaHei Consolas Hybrid"; color: black;" lang="EN-US">}</span></p>
<p class="mystyle000000" style="margin: 0cm 10.5pt 0.0001pt;"><span lang="EN-US">
Exception:</span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span lang="EN-US"> </span><span style="font-size: 10pt; font-family: "Courier New"; color: red;" lang="EN-US">Exception in
thread "main" </span><u><span style="font-size: 10pt; font-family: "Courier New"; color: navy;" lang="EN-US">java.lang.ClassCastException</span></u><span style="font-size: 10pt; font-family: "Courier New"; color: red;" lang="EN-US">:
$Proxy3</span><span style="font-size: 10pt; font-family: "Courier New";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 10pt; font-family: "Courier New"; color: red;" lang="EN-US">
at $Proxy2.getTables(Unknown Source)</span><span style="font-size: 10pt; font-family: "Courier New";" lang="EN-US"></span></p>
<p class="MsoNormal" style="margin: 0cm 10.5pt 0.0001pt; text-align: left;" align="left"><span style="font-size: 10pt; font-family: "Courier New"; color: red;" lang="EN-US">
at Test.main(</span><u><span style="font-size: 10pt; font-family: "Courier New"; color: navy;" lang="EN-US">Test.java:62</span></u><span style="font-size: 10pt; font-family: "Courier New"; color: red;" lang="EN-US">)</span><span style="font-size: 10pt; font-family: "Courier New";" lang="EN-US"></span></p>