Apache Tomcat/ 5 . 5 . 9 

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release  10 . 2 . 0 . 1 . 0  - Prod
PL/SQL Release  10 . 2 . 0 . 1 . 0  - Production
CORE     10 . 2 . 0 . 1 . 0       Production
TNS  for  Linux: Version  10 . 2 . 0 . 1 . 0  - Production
NLSRTL Version  10 . 2 . 0 . 1 . 0  - Production

       <Resource driverClassName="oracle.jdbc.driver.OracleDriver" 
              maxActive="100" 
              maxIdle="10" 
              maxWait="5000" 
              name="jdbc/TEST"
              username="test"
              password="xxx"
              type="javax.sql.DataSource"
              url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ora-host)(PORT = 1521)))(CONNECT_DATA =(SID = FLY)(SERVER = SHARED)))"
              validationQuery="select * from dual" />

...
CLOB myClob = CLOB.createTemporary(conn, true, CLOB.DURATION_SESSION);
...

org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/app].[action]  37895  ERROR [http- 8084 -Processor24]     - Servlet.service()  for  servlet action threw exception
java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper
        at oracle.sql.CLOB.createTemporary(CLOB.java: 754 )
        at oracle.sql.CLOB.createTemporary(CLOB.java: 716 )

       <Resource auth="Container"
              type="oracle.jdbc.pool.OracleDataSource"
              factory="oracle.jdbc.pool.OracleDataSourceFactory"
                
              url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ora-host)(PORT = 1521)))(CONNECT_DATA =(SID = FLY)(SERVER = SHARED)))"
              user="test"
              password="xxx"

              name="jdbc/TEST"

              connectionProperties="SetBigStringTryClob=true"

              connectionCachingEnabled="true"
              connectionCacheProperties="MinLimit=1, MaxLimit=5, InitialLimit=1, AbandonedConnectionTimeout=300, ValidateConnection=true, TimeToLiveTimeout=300, InactivityTimeout=300"
              />

url="jdbc:oracle:thin:@ora-host:1521:FLY"