RE: Problems with OracleAdapter

From: Cris Daniluk (cris.danilu..laraview.com)
Date: Thu Mar 24 2005 - 14:27:42 EST

  • Next message: Cris Daniluk: "FW: Problems with OracleAdapter"

    Andrus,

    I think the problem here is that OracleAdapter is writing the LONG as a LOB
    type. LOB operations in OracleAdapter are always batches. See this except
    from OracleAdapter.shouldRunBatchQuery:

            // special handling for LOB updates
            if (isSupportsOracleLOB() &&
    BatchQueryUtils.updatesLOBColumns(query)
                && (node instanceof OracleDataNode)) {

                OracleDataNode oracleNode = (OracleDataNode) node;
                oracleNode.runBatchUpdateWithLOBColumns(con, query, delegate);

                return false;
            } else {
                return super.shouldRunBatchQuery(node, con, query, delegate);
            }

    The two-phased LOB operation necessitates this.

    Cris

    > Laila,
    >
    > I really don't recommend switching from OracleAdapter to generic
    > JdbcAdapter. Looking at your exception stack, it looks like a
    > problem is
    > with batch updates. So just turn off the batching:
    >
    > OracleAdapter adapter = ... extract this from DataNode
    > adapter.setSupportsBatchUpdates(false);
    >
    > Andrus
    >



    This archive was generated by hypermail 2.0.0 : Fri Mar 25 2005 - 09:59:27 EST