Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: AW: oracle XmlType
Date: Mon, 13 Nov 2006 08:20:09 +0100
Message-ID: <2720B176E7BC0E4F8AC94C5DD748030918ED69@nsd-comix.nsdcom.local>
Thread-Topic: oracle XmlType
Thread-Index: AccFqFl3N5dEGVbTSAWYeI4Ro1P5eQBS8KqA
References: <2720B176E7BC0E4F8AC94C5DD748030918ED66@nsd-comix.nsdcom.local>
 <a10a823c0611110739p78fa50f9na096012894ce5e6f@mail.gmail.com>
 <a10a823c0611110744g3ba769a6oe7bd20ef5b17840d@mail.gmail.com>
From: =?iso-8859-1?Q?Timo_Schn=F6lzer?= <tschnoelzer@nsdcom.de>
To: <user-java@ibatis.apache.org>,
	<lmeadors@apache.org>

Hi Larry,

thx for Info, I did it like u said!

Timo

-----Urspr=FCngliche Nachricht-----
Von: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] Im Auftrag =
von Larry Meadors
Gesendet: Samstag, 11. November 2006 16:45
An: user-java@ibatis.apache.org
Betreff: Re: oracle XmlType

That didn't take long. :-)

This method on the dbcp.DelegatingResultSet will get it's wrapped result =
set:

public ResultSet getDelegate()

So, now, you just have to look at the RS you get, and if it's dbcp's, =
call that. If it's the iB logging one, get it's "rs" field (which will =
most likely be the dbcp resultset).

Non-standard APIs can be a pain, and as much as I like Oracle, they seem =
to be masters of making them. :-(

Larry


On 11/11/06, Larry Meadors <lmeadors@apache.org> wrote:
> Hmm, this could be fun. ;-)
>
> The connection pool wraps the result set...and so does iBATIS (for=20
> logging), and depending upon the log level, you will see different=20
> result set objects.
>
> What you will need to do is look at the result set you get, and based=20
> on that, try to get the object it is wrapping.
>
> So, if it's the ResultSetLogProxy, there is a private field that has=20
> it (it's private, but you can still get that via reflection... and I=20
> just added a getter for it in SVN).
>
> I am looking for a copy of dbcp now..
>
> Larry
>
>
> On 11/11/06, Timo Schn=F6lzer <tschnoelzer@nsdcom.de> wrote:
> >
> >
> > Hi Jeff,
> >
> > I am getting a
> >
> > com.ibatis.common.jdbc.logging.ResultSetLogProxy
> >
> > when using DEBUG level and a apache dbcp.DelegatingResultSet when=20
> > going on ERROR for Resultset debugging.
> >
> > Any ideas welcome
> >
> >
> >
> > Timo
> >
> >  ________________________________
> >  Von: Jeff Butler [mailto:jeffgbutler@gmail.com]
> > Gesendet: Freitag, 10. November 2006 17:51
> > An: user-java@ibatis.apache.org
> > Betreff: Re: oracle XmlType
> >
> >
> >
> > What class is returned from getter.getResultSet()?
> >
> > If you have logging enabled, you might be getting iBATIS' result set =

> > proxy instead of the underlying result set.
> >
> > Does it work differently if you enable or disable logging?
> >
> > Jeff Butler
> >
> >
> >
> >
> > On 11/10/06, Timo Schn=F6lzer <tschnoelzer@nsdcom.de> wrote:
> > > Hi Folks,
> > >
> > > I am using the Ibatis mapping tool for long and want to map=20
> > > XmlType from
> > Oracle.
> > > I registerd the XMLTypeHandlerCallbackand the system is running=20
> > > into the
> > getResult Method
> > > returning the UnsupportedOperationException  error:
> > >
> > > if (getter.getResultSet() instanceof OracleResultSet) {
> > >                        OPAQUE opaqueValue =3D =
getOpaqueValue(getter);
> > >                        if (opaqueValue !=3D null) {
> > >                                XMLType xmlResult =3D
> > XMLType.createXML(opaqueValue);
> > >                                return xmlResult.getDOM();
> > >                        } else {
> > >                                return (Document) null;
> > >                        }
> > >                } else {
> > >                        throw new UnsupportedOperationException(
> > >                                        "XMLType mapping
> > only supported for Oracle RDBMS");
> > > }
> > >
> > > Has anyone out there running example with the mapping and Object ?
> > >
> > > I am using "SELECT 1 as id, xmlelement("Flat",=20
> > > xmlattributes(z.floors
> > ..... "
> > >
> > > With:
> > >
> > >        <resultMap id=3D"houseResult" class=3D"houseData">
> > >                <result property=3D"id" column=3D"id" />
> > >                <result property=3D"xmlValue" column=3D"xmlValue"/>
> > >        </resultMap>
> > >
> > >        <select id=3D"getHouseXML"
> > >                resultMap=3D" houseResult "> select ...
> > >
> > > and:
> > >
> > > import org.w3c.dom.Document;
> > >
> > > public class House {
> > >
> > >        private Integer id;
> > >
> > >        private Document xmlValue;
> > >
> > >        public Document getXmlValue() {
> > >                return xmlValue;
> > >        }
> > >
> > >        public void setXmlValue(Document xmlValue) {
> > >                this.xmlValue =3D xmlValue;
> > >        }
> > >
> > >        public Integer getId() {
> > >                return id;
> > >        }
> > >
> > >        public void setId(Integer id) {
> > >                this.id =3D id;
> > >        }
> > >
> > > }
> > >
> > >
> > > Thx a lot
> > >
> > > Timo Schn=F6lzer
> > >
> > >
> >
> >
> >
> > ____________
> > Virus checked by G DATA AntiVirusKit
> > Version: AVK 16.8873 from 02.08.2006 Virus news:=20
> > www.antiviruslab.com
> >
>