Hi. My name's Dave, and this is my first post to your mailing list. I did a quick search of the archives and didn't see any message on the same subject, but please pardon me if there is one and I just missed it.
My issue is well stated by someone else on the IBM dW forums, so I'll paste that here: >From http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14049784 >>> On Jan 13, 2008 09:16:20 AM azamew posted: How can use SQLXML type with DataSource in Tomcat and JDBC4 Hi, I'm trying to use SQLXML type with DataSource interface and Tomcat. My environment is: Windows XP SP2 Apache Tomcat 6.0.14 DB2 V9.5 Sun JDK 1.6.0_03 When I trying to use SQLXML type by DataSource, I encountered following error: javax.servlet.ServletException: java.lang.AbstractMethodError: org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getSQLXML(I)Ljava/sql/SQLXML; On the other hand, I can successfully use SQLXML type with DriverManager interface. Are there any limitation for using SQLXML type with DataSource interface? Or how can I use SQLXML type with DataSource interface? On Feb 20, 2008 08:43:09 AM joeymacao posted: Re: How can use SQLXML type with DataSource in Tomcat and JDBC4 Attachment lingtren-tomcat-dbcp.jar (773.4 K) Hi there, The dbcp library in Tomcat must have been compiled against a previous JDK version which doesn't support XML related methods in the SQL classes. I've recompiled the dbcp classes against jdk1.6.0_04, refactored the package layout and implemented the org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getSQLXML(int columnIndex) method as this is the only one I currently need. lingtren-tomcat-dbcp.jar (see att.) should replace tomcat-dbcp.jar in the lib directory. I'm sure an update of the dbcp libraries on the Apache site will be available soon. Cheers, B. PS. Same for JBoss. Their datasource classes don't implement the new XML related methods. >>> So there you have it. There is interest in getting DBCP to support these SQLXML methods. http://java.sun.com/javase/6/docs/api/java/sql/SQLXML.html The jar file that joeymacao posted doesn't include any source, so I haven't included it in this message. Cheers, --Dave Loyall Omaha, Nebraska, USA --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
