tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hume, John - NA US HQ Delray" <john.h...@cruisesonly.com>
Subject RE: OracleConnection datasource CLOB.createTemporary
Date Mon, 19 Jan 2004 13:59:12 GMT
Note that you MUST NOT close the Connection returned by
DelegatingConnection.getInnermostDelegate, and you MUST close (i.e., return
to the pool) the DelegatingConnection from which you got the delegate
OracleConnection once you're finished with the OracleConnection.  

-john.


-----Original Message-----
From: Kahle, Pavel (GE Consumer Finance) [mailto:Pavel.Kahle@ge.com]
Sent: Monday, January 19, 2004 6:54 AM
To: Tomcat Users List
Subject: RE: OracleConnection datasource CLOB.createTemporary


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:devious@siulintao.net]
>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: tomcat-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>  
>>
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message