 can connection from javax.sql.DataSource be used for OracleXMLQuery..? [message #128726] |
Wed, 20 July 2005 05:46 |
jerrygo2
Messages: 1
Registered: July 2005
|
Junior Member |
|
|
hi, all...
I'm testing Oracle xdk package.. oracle version is 9i.
In my test, I got different result whether I use Connection Object from DriverManager or javax.sql.DataSource when I quried
ref-cursor query.
The detail is
my database query was like below...
select a, b, (select c from C) as intable from data_t....
and the result was like below when i use connection from DriverManager
<rowset>
<row num="1">
<a>value</a>
<b>value</b>
<intable>
<intable_row num="1">
<c>value</c>
</intable_row>
</intable>
</row>
....
</rowset>
But the result from using connection from javax.sql.DataSource was different like below..
<rowset>
<row num="1">
<a>value1</a>
<b>value2</b>
<intable>oracle.jdbc.driver.OracleResultSetImpl@3b5823</intable>
</row>
</rowset>
personally, i can't get the difference connection from DriverManager and DataSource.
I want to know how can I use javax.sql.DataSource for database connection source for OracleXMLQuery object.
my environment for test are oracle9i and IBM Websphere Server 5.1.
i'd appreciate for any idea or information about this problem..
thanks in advance...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
