談笑有鴻儒,往來無白丁

          在恰當的時間、地點以恰當的方式表達給恰當的人...  閱讀的時候請注意分類,佛曰我日里面是談笑文章,其他是各個分類的文章,積極的熱情投入到寫博的隊伍中來,支持blogjava做大做強!向dudu站長致敬>> > 我的微博敬請收聽

          CAUSE

          The Oracle oracle.sql.BLOB OutputStream writes the data in chunks. Since autocommit defaults to true, the first chunk is committed. This results in the write operation for the next chunk of the Blob to fail since it appears to be in the next transaction.
          In those conditions, the ORA-22990 exception will occur with any version of Oracle JDBC driver.

          SOLUTION


          Issue the setAutoCommit(false) command. Then, explicitly commit the transaction after all of the Blob chunks have been written to the row and the stream.close() method has been executed.

          If using the Oracle 10g JDBC driver (or greater version), a second solution consists of using the standard JDBC api (setBinaryStream method of java.sql.PreparedStatement interface). And in this case, AutoCommit can be set to true.

          Here is an example:

          PreparedStatement stmt = conn.prepareStatement("INSERT INTO blobTest VALUES (?,?)"); 
          File fd = new File(testFile); 
          fis = new FileInputStream(fd); 
          stmt.setInt(1,1); 
          stmt.setBinaryStream(2,fis,(int)fd.length());



          where blobTest is a table defined as the following:

          SQL> create table blobTest (id number (4), data blob);
          posted on 2015-08-25 13:56 壞男孩 閱讀(1054) 評論(1)  編輯  收藏 所屬分類: ORACLE篇章

          FeedBack:
          # re: While inserting a large BLOB using JDBC, the application fails with:ORA-22990
          2015-08-25 14:03 | 壞男孩
          The following error occurs while inserting empty blob to return blob locators.

          ORA-22990: lob locator cannot span transaction

          DML statements were executed within a for loop to insert an empty BLOB and an attempt to fetch is made followed by commit within the loop.
          SOLUTION

          It is not advisable to use a COMMIT inside a loop. Use commit after the loop ends.
            回復  更多評論
            
          主站蜘蛛池模板: 汉中市| 侯马市| 汝南县| 尤溪县| 凤凰县| 崇义县| 麦盖提县| 辛集市| 温泉县| 临江市| 田东县| 普格县| 元江| 札达县| 巩义市| 镇坪县| 乐平市| 永仁县| 崇信县| 祥云县| 弥勒县| 江口县| 东乡族自治县| 钟祥市| 福安市| 翁牛特旗| 饶阳县| 青海省| 南宁市| 从化市| 广东省| 塘沽区| 杂多县| 开平市| 大宁县| 溧水县| 龙里县| 和林格尔县| 卓尼县| 南和县| 洪湖市|