ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Uma S Mudunuri <uma_...@yahoo.com>
Subject Re: problem retrieving xml results from oracle xmldb
Date Thu, 01 Sep 2005 18:47:10 GMT
Thanks Mike that solved my problem 

--- Mike Fagan <mfagan@tde.com> 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 
> >
> >  
> >
> 
> 


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

Mime
View raw message