救命啊!~关于CLOB的问题!!

Question

有没有人啊~~~~~~~~~帮帮忙哦!!!!分不够在开贴给啊!!!!!或者有没有其他的方法啊!!!
我这样写了 if (rs.next()) {
          /* 取出此CLOB对象 */
           weblogic.jdbc.vendor.oracle.OracleThinClob clob = (OracleThinClob)rs.getClob(1);
          /* 向CLOB对象中写入数据 */
           Writer  out1 = clob.getCharacterOutputStream();
         //   System.out.print(infile);
            out1.write(infile); 
          out1.flush();
          out1.close();        
          }结果还是一样走到flush()的时候就不报链接已关闭!

Answer 1

1.
     /* 向CLOB对象中写入数据 */
      BufferedWriter out = new BufferedWriter(clob.getCharacterOutputStream());
应该是
BufferedWriter out = new BufferedWriter(new OutputStreamWriter(clob.getCharacterOutputStream()));2.
          while ((c=inwdnr.read())!=-1) {
            System.out.println(c);
                    
            }
应该是
          while ((c=inwdnr.read())!=-1) {
            out.println(c);
                    
            }

Answer 2

to:： launch401(乌兰巴托的夜 那么静 那么静) 这里while ((c=inwdnr.read())!=-1) {            System.out.println(c);                    
            }
是我刚才拷错了的:          while ((c=inwdnr.read())!=-1) {
            //System.out.println(c);
            out2.write(c);
            }还有就是我试着写成你说的这样BufferedWriter out = new BufferedWriter(new OutputStreamWriter(clob.getCharacterOutputStream()));
本身编译就过不了啊,"ll_db.java": cannot resolve symbol: constructor OutputStreamWriter (java.io.Writer)in class java.io.OutputStreamWriter at line 1024, column 48

Answer 3

我试着将 weblogic.jdbc.vendor.oracle.OracleThinClob clob = (OracleThinClob)rs.getClob(1);换成oracle.sql.CLOB clob=( oracle.sql.CLOB)rs.getClob(1);运行到这句wb上面又报:java.lang.ClassCastException

Answer 4

clob.getCharacterOutputStream()返回的是什么类型？

Answer 5

clob.getCharacterOutputStream() 返回的是Writer类型啊

Answer 6

你允许updata了吗？ pubstmt = pubcon.prepareStatement(sqlstr,ResultSet.TYPE_SCROLL_INSENSITIVE,                                          ResultSet.CONCUR_UPDATABLE);

Answer 7

我按照你这样 pubstmt = pubcon.prepareStatement(sqlstr,ResultSet.TYPE_SCROLL_INSENSITIVE,                                          ResultSet.CONCUR_UPDATABLE);
写了还是不行啊,pubcon.commit();了就执行不下去了,过N长时间了wb提示"连接已关闭"!

Answer 8

我用oracle.sql.CLOB clob=( oracle.sql.CLOB)rs.getClob(1);为啥会报:java.lang.ClassCastException错误啊,是不是我引入的oracle的classes包的版本不对啊,正确的应该用那个包呐??或怎么样正确引入
我的oracle版本是:
Oracle8i Release 8.1.5.0.0 - Production

Answer 9

BEA的驱动问题：
把weblogic 的连接池改为：
bea's Oracle Driver(Type4)