Thanks Mike that solved my problem --- Mike Fagan <[EMAIL PROTECTED]> 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 <[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 > > > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
