Re: problem retrieving xml results from oracle xmldb

[Mike Fagan]

When returning a oracle XMLType to ibatis use the getClobVal()/getStringVal()  function and it work fine.
That is why your extractValue works because it returns varchar2.

so try

<statement ....>
  SELECT extract(value(x),'/employee').getClobVal() xml
  FROM employees
</statement>

Mike Fagan

Uma S Mudunuri wrote:

Thanks for the reply. Guess I have to go with the JDBC
implementation atleast for now.

--- Jan Vissers <[EMAIL PROTECTED]> wrote:

  

I'm guessing this has to do with the fact that
iBatis doesn't support 
the Oracle XMLType datatype. I've also been looking
for a way to deal 
with this, but more in the area of Custom Type
Handling. Would be 
interested if someone has actually managed to do
this. In my situation, 
due to time constraints we decided to implement
XMLType operations as 
JDBC implemenation behind the iBatis DAO framework
and do the rest with 
sqlMap implemantions.

Uma S Mudunuri wrote:

    

Hi,

I am trying to use iBATIS to retrieve results from
Oracle's XML DB database(which stores whole xml
documents). It works fine when the results are the
text value of an element but when I try to use
functions to get whole or part of the xml document
      

it
    

does not return any results. The query works fine
      

when
    

executed directly in oracle. I am new to iBATIS and
have searched the archives and faq's but did not
      

find
    

anything related. 

An example xml file in the database

<employee>
<name>Scott</name>
<department>1</department>
</employee>

i) query to get name of the employee
 <statement ....>
 SELECT extractValue(value(x),'/employee/name')
      

name 
    

 FROM EMPLOYEES
 </statement>
 This query works fine and the result is 'Scott'

ii) query to get the whole xml document
  <statement ....>
  SELECT extract(value(x),'/employee') xml
  FROM employees
  </statement>

  does not return anything 


I am guessing that the problem is because of the
      

fact
    

that the result is an xml document and I would like
      

to
    

know if there's any way to handle these queries in
iBATIS. Any help would be greatly appreciated.

Thanks,
Uma


		
      

____________________________________________________
    

Start your day with Yahoo! - make it your home page
      

http://www.yahoo.com/r/hs 


 

      

-- 
Cumquat Information Technology
De Dreef 19
3706 BR Zeist
T +31 (0)30 - 6940490
F +31 (0)10 - 6940499
http://www.cumquat.nl

[EMAIL PROTECTED]
M +31 6 5 11 169 556



    

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com