写Clob字段

BufferedReader r = (BufferedReader)paras[i];
                        CLOB newClob = CLOB.createTemporary(conn, false, CLOB.DURATION_CALL);
                        newClob.open(CLOB.MODE_READWRITE);
                        String temp = null;
                        long mark = 1;
                        while ((temp = r.readLine()) != null)
                        {
                            newClob.putString(mark, temp);
                            mark += temp.length();
                        }
                        stmt.setClob(i + 1, newClob);                   //写入数据;
                        r.close();



[2009-11-20 19:50:55,437][ERROR][http-8080-Processor22][ErrorHandleFilter.java131]
java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper
	at oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnection.java:5198)
	at oracle.sql.CLOB.createTemporary(CLOB.java:1009)
	at oracle.sql.CLOB.createTemporary(CLOB.java:956)
	at com.huawei.wad.ups.common.db.ADMDBSource.executeUpdateWithClobOrBlob(ADMDBSource.java:403)
	at com.huawei.wad.ups.platform.service.datametamanage.LabelRuleService.createBatch(LabelRuleService.java:168)
	at com.huawei.wad.ups.platform.service.datametamanage.LabelRule.createBatch(LabelRule.java:214)
	at com.huawei.wad.ups.platform.servlet.datameta.LabelRuleServlet.createBatch(LabelRuleServlet.java:285)
	at com.huawei.wad.ups.platform.servlet.datameta.LabelRuleServlet.create(LabelRuleServlet.java:161)
	at com.huawei.wad.ups.platform.servlet.BaseServlet.doPost(BaseServlet.java:157)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at com.huawei.wad.ups.platform.servlet.BaseServlet.service(BaseServlet.java:82)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at com.huawei.wad.ups.platform.servlet.filter.AbstractFilter.doFilter(AbstractFilter.java:113)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at com.huawei.wad.ups.platform.servlet.filter.PowerFilter.doFilter(PowerFilter.java:138)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at com.huawei.wad.ups.platform.servlet.filter.ErrorHandleFilter.doFilter(ErrorHandleFilter.java:78)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
	at java.lang.Thread.run(Thread.java:595)

终于看到了一个有用的：

This is a known problem with the Oracle API. It has been fixed in 11g.

The problem is that you have to pass a connection to the createTemporary method and that connection must be an instance of an Oracle concrete implementation class. Apache gives you a wrapped connection instead.

When using the 11g drivers and JDBC 4.0 (JSE 6.0) you can write

Clob c = conn.createClob();

This is standard JDBC 4.0 and just works. It is also highly recommended.

If you are not using 11g, JSE 6.0, JDBC 4.0 then you have to unwrap the connection you get from Apache until you get something that you can cast to oracle.jdbc.OracleConnection. Once you get that object you can pass it to createTemporary and you won't get the ClassCastException.

This has been a long standing problem in the Oracle JDBC API and I'm glad that it is fixed. In JDBC 4.0/11g there are many factory methods on java.sql.Connection and oracle.jdbc.OracleConnection. Oracle very strongly encourages you to use them instead of calling the constructors. We will desupport the constructors.