Hi, The getDelegate call would return a ResultSet that you can cast for oracle's ResultSet impl as you have been doing in the past. You're right that QM's suggestion requires DBCP-specific code and is thus undesirable in your scenario. I saw your original message, and I wonder if it's possible for you to use just the java.sql.ResultSet methods to work with the Blobs, not the oracle-specific ones. If not, you will have a couple of options: - Don't use container-provided connection pooling, but your own, so that you can use the same provider (e.g. DBCP) across all your application server. - Do some fancy (or ugly, depends on your mood ;)) reflection work to figure out how to get the oracle result set impl class from the result set provided by the container.
Yoav Shapira Millennium Research Informatics >-----Original Message----- >From: Carey Boldenow [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 19, 2004 11:37 AM >To: 'Tomcat Users List' >Subject: RE: problem inserting Blob into database > >I'm somewhat confused. The api doc info for this is pretty vague. I'm >not really sure what this method does for me other than return me a >ResultSet instance. Also, it seems as though you're suggesting I >implement apache specific code here, this code is also deployed in >weblogic and/or jrun. I just want to work with generic java.sql objects >or at worse dbms specific objects. > >Regards, >Carey > >-----Original Message----- >From: QM [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 19, 2004 9:08 AM >To: Tomcat Users List >Subject: Re: problem inserting Blob into database > >On Thu, Aug 19, 2004 at 09:10:58AM -0500, Carey Boldenow wrote: >: I have some code that works fine in weblogic, but throws a >: ClassCastException in Tomcat (v5.0.19). The code snippet below is >where >: it is failing >: [snip] >: The ResultSet instance apparently is of type >: org.apache.commons.dbcp.DelegatingResultSet. I don't want to code to >: that type since that is not too portable to other app servers. > >http://jakarta.apache.org/commons/dbcp/apidocs/org/apache/commons/dbcp/ D >elegatingResultSet.html > >getDelegate() > >-QM > >-- > >software -- http://www.brandxdev.net >tech news -- http://www.RoarNetworX.com > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
