ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Vissers <Jan.Viss...@cumquat.nl>
Subject Re: problem retrieving xml results from oracle xmldb
Date Wed, 31 Aug 2005 14:28:08 GMT
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:

>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
>i) query to get name of the employee
>  <statement ....>
>  SELECT extractValue(value(x),'/employee/name') name 
>  </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.
>Start your day with Yahoo! - make it your home page 

Cumquat Information Technology
De Dreef 19
3706 BR Zeist
T +31 (0)30 - 6940490
F +31 (0)10 - 6940499

M +31 6 5 11 169 556

View raw message