About ORA-22990: LOB locators can not be extended transaction

2011-09-23  来源:本站原创  分类:Database  人气:94 

Print the following exception stack:

java.io.IOException: ORA-22990: LOB locators can not be extended transaction
at oracle.jdbc.driver.DatabaseError.SQLToIOException (DatabaseError.java: 764)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer (OracleBlobOutputStream.java: 296)
at oracle.jdbc.driver.OracleBlobOutputStream.close (OracleBlobOutputStream.java: 261)
at com.paradise.jdbc.WriteBlob.main (WriteBlob.java: 82)

This is because the source code for the out stream object caused by the closed position.
Oracle for "ORA-22990: LOB locators can not be extended transaction" exception explained as follows:
ORA-22990 LOB locators cannot span transactions
Cause A LOB locator selected in one transaction
cannot be used in a different transaction.
Action Re-select the LOB locator and retry the operation.

That is a LOB locator can not be used for different matters, in the above source code,
out object is obtained from the blob object is estimated with the LOB locator stream object out of a relationship,
So out stream object in the transaction should close before the end of the action is invoked, that commit () method executes before out.close ();

Because there may be implementation conn.commit (), this out stream object is automatically released,
So conn.commit (); then perform out.close (); will appear above the exception.
Therefore, the finally block above the out.close () moved to conn.commit () before the execution can be.

  • About ORA-22990: LOB locators can not be extended transaction 2011-09-23

    Print the following exception stack: java.io.IOException: ORA-22990: LOB locators can not be extended transaction at oracle.jdbc.driver.DatabaseError.SQLToIOException (DatabaseError.java: 764) at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer

  • LOB variable no longer valid after subsequent fetch 2010-12-01

    cx_oracle read oracle wm_concate function long after handling the text clob field when using fetchall or fetchmany read data, reported the fault of the above Refer to the following document, found only in the following 2 ways to operate any of the da

  • DB2 SQLCODE expressed the common meaning of a negative 2011-01-04

    Reproduced: http://longsy.iteye.com/blog/358390 SQL0007 SQLCODE -07 SQLSTATE 42601 Explanation: Character & 1 (HEX & 2) not valid in SQL statement. SQL0010 SQLCODE -10 SQLSTATE 42603 Explanation: String constant beginning & 1 not delimited. SQ

  • operation of large object type oracle: blob, clob, nclob, bfile 2011-03-14

    3-4 Lob type 13.4.1 Basic Introduction Oracle and plsql support lob (large object) type, used to store large amounts of data such as image files, sound files, etc. Oracle 9i realse2 support a maximum of 4g of data storage, oracle 10g realse1 support

  • Oracle10g configured tnsnames.ora and listener.ora method 2010-02-10

    File Location: oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN tnsnames.ora configuration server or local database EXTPROC_CONNECTION_DATA = \ \ install Oracle after the original configuration (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =

  • tnsname.ora in SOURCE_ROUTE, FAILOVER, LOAD_BALANCE 2010-02-22

    Reprinted Remember that E is the default Quote Table 13-1 Address List Parameters Parameter Description SOURCE_ROUTE (Source Routing) When set to on, instructs Oracle Net to use each address in the order presented until the destination is reached. Th

  • oracle network configuration (listener.ora / sqlnet.ora / tnsnames.ora) 2010-04-05

    Quote Reprinted: http://zjf365.javaeye.com/blog/265450 oracle network configuration of three configuration files listener.ora, sqlnet.ora, tnsnames.ora, are placed in $ ORACLE_HOME \ network \ admin directory. 1. Sqlnet.ora----- effect similar to lin

  • ora 600 error classification 2010-04-09

    Original: http://www.ningoo.net/html/2009/ora-600_internal_error_categories.html ora-600 is the Oracle error for some internal error of a single number (like there is ora-7445). Ora-600 error to determine the specific type, generally in accordance wi

  • Switch: java database manipulation of the main lob types of data 2010-04-11

    Blob Clob and is divided into three kinds of operations: insert, update, and reading. For insertion, can be divided into two categories. One is the normal field can handle, one must first insert a blank for the clob / blob and then update the actual

  • ORA: 01461 only allows binding LONG LONG column value 2010-04-14

    [ORA: 01461 only allows binding LONG LONG column value] Data in the table column type is not LONG, but save or insert the data with the Chinese when the above error. ORACLE version is due to mismatch caused by the driver. So to update the ORACLE driv

  • [Change] tnsnames.ora Configuration Summary 2010-04-23

    listener.ora, sqlnet.ora, tnsnames.ora, are placed in $ ORACLE_HOME \ network \ admin directory. Focus: the role of the three documents and the use of #----------------------- sqlnet.ora----- effect similar to linux or other unix's nsswitch.conf file

  • CRS-1019: Resource ora.rac02.ons (application) cannot run on rac01 problem solving 2010-04-25

    [Root @ rac01 bin] #. / Crs_stat-t Name Type Target State Host -------------------------------------------------- ---------- ora .... 01.lsnr application ONLINE ONLINE rac01 ora.rac01.gsd application ONLINE ONLINE rac01 ora.rac01.ons application ONLI

  • Spring has become easy to LOB data manipulation 2010-05-09

    Personally think that the gold content of this article quite high, recent and he himself was engaged in iBATIS (SSI framework, he has built himself), the first set up this framework, there are many problems to solve in one step. Blob on the types of

  • Simple configuration and sqlnet.ora listener.ora tnsname.ora Description 2010-05-25

    Get a test today, simple configuration a bit of a DBLINK My host is installed ORACLE 10.2 VISTA virtual machine inside ORACLE 10.2 Purpose is to host the SQLPLUS or through PL / SQL tool to connect to the database inside the virtual machine First of

  • 3.18.4 INITORA8.ORA file 2010-05-28

    In the ORACLE 8.0.5 version, the database initialization file is initora8.ora, its path is ORACLE HOME directory dbs directory. OPS when setting the following parameters in mind:  rollback_segments = (icd_rbs01, icd_rbs02, icd_rbs03, icd_rbs04, icd_

  • Oracle listener.ora tnsnames.ora sqlnet.ora 2010-05-31

    in its most basic form, Oracle uses threes files (listneres.ora, tnsnames.ora, sqlnet.ora) for network configuration. 1 listener.ora. This file contains the server side parameters configuration 2 tnsnames.ora, sqlnet.ora this file contains the client

  • Test tnsnames.ora inside configuration can resolve the client 2010-06-01

    In dos the following test: tnsnames.ora tnsping ORAS4.0_189 inside the configuration used to test the client can not resolve. Explained: tnsping fixed wording. ORAS4.0_189 name for the database

  • Convention and locators in the basePackage configuration 2010-06-06

    Abandoned in Struts2.1.6 Codebehind plug-in, switch to the Convention to achieve the so-called plug-0 configuration, Here are a few I know of several plug-ins configuration properties Convention: 1. struts.convention.package.locators.basePackage = co

  • oracle10g listener.ora configuration file 2010-06-24

    # listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) // Manually added (SID_NAME = PLSExtProc

  • SuSE 10 Enterprise under the Oracle 10g on initorcl.ora and control files can not find the problem 2010-07-12

    Since Saturday room blackout, causing problems with Oracle server, the re-start the server, Oracle can not start properly, after some study, finally solve the problem, make a note here, spare! The following: Using the Oracle User Login: > Sqlplus / n