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
