I've figured it out using this code : public void init(ServletConfig config) throws ServletException { .. ds lookup ((BasicDataSource) ds).setAccessToUnderlyingConnectionAllowed(true); ... protected OracleConnection getConnection() throws SQLException ,NamingException { return ( (OracleConnection) ( (DelegatingConnection ) ds.getConnection() ).getInnermostDelegate());
>-----Original Message----- >From: Rob Augustinus [mailto:[EMAIL PROTECTED] >Sent: Sunday, January 18, 2004 2:04 PM >To: Tomcat Users List >Subject: Re: OracleConnection datasource CLOB.createTemporary > > > >how about typcasting the DBCP Connection to OracleConnection ? >afaik this is the proper way? > >Kahle, Pavel (CONS FIN) wrote: > >>somwehere in the CLOB.createTemporary is Connection retype to >>OracleConnection but Connection returned from DBCP >DataSource.getConnection >>is not assignable to that class. I can create clob in DB but I prefer >>CLOB.createTemporary is there any solution to use >CLOB.createTemporary with >>DBCP? >>Thank Pavel Kahle >> >> >> >>--------------------------------------------------------------------- >>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]