Now it's working!! Thanks guys! >I'm sorry, but i think to have an old release of commons-dbcp.jar, and i don't' find >the getDelegate() method. It's in org.apache.commons.dbcp.PoolableConnection class?? > >>In my tomcat common/lib; apparently it is the debug version of Oracle's >>jdbc implentation. Download classes12.zip ( and rename to classes12.jar >>) from Oracle site. >> >>Sundar >> >>-----Original Message----- >>From: Marco Rossi [mailto:[EMAIL PROTECTED] >>Sent: Monday, March 31, 2003 11:25 AM >>To: Tomcat Users List >>Subject: RE: Casting DBCP Connection to OracleConnection - Solved IT! >> >>Where do you find ojdbc_g.jar? >> >>>I was using ojdbc_g.jar instead of classes12.zip ( i.e classes12.jar ) >>> >>>Sundar >>> >>>-----Original Message----- >>>From: Chakravarthy, Sundar >>>Sent: Monday, March 31, 2003 11:11 AM >>>To: Tomcat Users List >>>Subject: RE: Casting DBCP Connection to OracleConnection >>> >>>Strange .. the getDelegate().getClass().getName() returns >>>"oracle.jdbc.driver.OracleConnection" . But the cast fails at runtime. >>> >>>Sundar >>> >>>-----Original Message----- >>>From: Filip Hanik [mailto:[EMAIL PROTECTED] >>>Sent: Monday, March 31, 2003 11:05 AM >>>To: Tomcat Users List >>>Subject: RE: Casting DBCP Connection to OracleConnection >>> >>>hi Sundar, >>>as an alternative, why don't you print the class names to know what you >>>are >>>doing >>> >>>for example >>> >>>System.out.println("delegate="+conn.getDelegate().getClass().getName()) >>; >>> >>>and do that for all of the things you try to cast, that way you can see >>>what >>>you are accessing before you try to cast it >>> >>>Filip >>> >>>> -----Original Message----- >>>> From: Chakravarthy, Sundar [mailto:[EMAIL PROTECTED] >>>> Sent: Monday, March 31, 2003 7:57 AM >>>> To: Tomcat Users List >>>> Subject: RE: Casting DBCP Connection to OracleConnection >>>> >>>> >>>> >>>> Run-time failure using both getInnermostDelegate() and getDelegate(). >>>> Any other alternatives ? >>>> >>>> -Sundar >>>> >>>> -----Original Message----- >>>> From: Tim Funk [mailto:[EMAIL PROTECTED] >>>> Sent: Monday, March 31, 2003 10:49 AM >>>> To: Tomcat Users List >>>> Subject: Re: Casting DBCP Connection to OracleConnection >>>> >>>> Compile fail or run-time fail? >>>> >>>> If compile fail - you need a nightly of dbcp. >>>> If run-time fail, you may need to use getInnermostDelegate() instead >>>> >>>> -Tim >>>> >>>> Chakravarthy, Sundar wrote: >>>> > I tried the following with no success, >>>> > >>>> > 1. PoolableConnection pc = (PoolableConnection)conn; >>>> > 2. OracleConnection oc = (OracleConnection)pc.getDelegate(); >>>> > >>>> > Fails in line 2 >>>> > >>>> > -Sundar >>>> > >>>> > >>>> > -----Original Message----- >>>> > From: Tim Funk [mailto:[EMAIL PROTECTED] >>>> > Sent: Monday, March 31, 2003 10:34 AM >>>> > To: Tomcat Users List >>>> > Subject: Re: Casting DBCP Connection to OracleConnection >>>> > >>>> > All dbcp objects have a getDelegate() method (I think). But you'll >>>> need >>>> > to do 2 casts. >>>> > - dbcpConn = (DBCPClassCast)conn--> The dbcp connection >>>> > - myOraConn = (OraClassCast)dbcpConn.getDelegate() --> Get the >>>> > underlying implementation >>>> > >>>> > Look at the DBCP javadocs for the correct class names. >>>> > >>>> > BUT you'll need to use a nightly build of dbcp to do this since the >>>> > version shipped with tomcat doesn't have the getDeletgate() >>methods. >>>> > >>>> > -Tim >>>> > >>>> > Marco Rossi wrote: >>>> > >>>> >>I have the same problem. If you find a solution, please reply >>>> >> >>>> >> >>>> >> >>>> >>>HI, >>>> >>> >>>> >>>I am using Tomcat 4.1.18 with Oracle 9i. When I try to cast the >>>> >>>Connection returned from DBCP to OracleConnection I get a >>>> >>>ClassCastException . >>>> >>> >>>> >>>Anyone here know how to cast correctly ? >>>> >>> >>>> >>>Thanks >>>> >>> >>>> > >>>> > >>>> > >>>> > >>>--------------------------------------------------------------------- >>>> > 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] >>>> > >>>> > >>>> > >>>> >>>> >>>> --------------------------------------------------------------------- >>>> 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] >>>> >>>> >>> >>> >>>--------------------------------------------------------------------- >>>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] >>> >>> >>>--------------------------------------------------------------------- >>>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] >> >> >>--------------------------------------------------------------------- >>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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
