ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Fagan <mfa...@tde.com>
Subject Re: problem retrieving xml results from oracle xmldb
Date Thu, 01 Sep 2005 17:59:38 GMT
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 
>
>  
>


Mime
View raw message