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 Thu, 01 Sep 2005 21:36:42 GMT
Yep, this works. But basically what I'm looking for is to have the 
XMLType map to org.w3c.dom.Document in one go. Good suggestion though.

-J.

Mike Fagan wrote:

> 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 <Jan.Vissers@cumquat.nl> 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
>>>
>>>Jan.Vissers@cumquat.nl
>>>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 
>>
>>  
>>
>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.344 / Virus Database: 267.10.18/86 - Release Date: 8/31/2005
>  
>

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

Jan.Vissers@cumquat.nl
M +31 6 5 11 169 556



Mime
View raw message