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 <[EMAIL PROTECTED]> wrote:
Hmm, this could be fun. ;-) The connection pool wraps the result set...and so does iBATIS (for logging), and depending upon the log level, you will see different result set objects. What you will need to do is look at the result set you get, and based on that, try to get the object it is wrapping. So, if it's the ResultSetLogProxy, there is a private field that has it (it's private, but you can still get that via reflection... and I just added a getter for it in SVN). I am looking for a copy of dbcp now.. Larry On 11/11/06, Timo Schnölzer <[EMAIL PROTECTED]> wrote: > > > Hi Jeff, > > I am getting a > > com.ibatis.common.jdbc.logging.ResultSetLogProxy > > when using DEBUG level and a apache dbcp.DelegatingResultSet when going on > ERROR for Resultset debugging. > > Any ideas welcome > > > > Timo > > ________________________________ > Von: Jeff Butler [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 10. November 2006 17:51 > An: [email protected] > 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ölzer <[EMAIL PROTECTED]> wrote: > > Hi Folks, > > > > I am using the Ibatis mapping tool for long and want to map XmlType from > Oracle. > > I registerd the XMLTypeHandlerCallbackand the system is running into the > getResult Method > > returning the UnsupportedOperationException error: > > > > if (getter.getResultSet() instanceof OracleResultSet) { > > OPAQUE opaqueValue = getOpaqueValue(getter); > > if (opaqueValue != null) { > > XMLType xmlResult = > 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", xmlattributes(z.floors > ..... " > > > > With: > > > > <resultMap id="houseResult" class="houseData"> > > <result property="id" column="id" /> > > <result property="xmlValue" column="xmlValue"/> > > </resultMap> > > > > <select id="getHouseXML" > > resultMap=" 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 = xmlValue; > > } > > > > public Integer getId() { > > return id; > > } > > > > public void setId(Integer id) { > > this.id = id; > > } > > > > } > > > > > > Thx a lot > > > > Timo Schnölzer > > > > > > > > ____________ > Virus checked by G DATA AntiVirusKit > Version: AVK 16.8873 from 02.08.2006 > Virus news: www.antiviruslab.com >
