CLOB/BLOB

[Dung Nguyen]

I thank so much for every advices !

I posted recently a message concerning of using clob/blob cmp mapping and I also
received some replies. But I could not figure out the problem.

Here the error messages when i tried to map a oracle clob to a cmp java String
:
java.rmi.RemoteException: EJB Exception:; nested exception is:
java.sql.SQLException: ORA-01002: fetch out of sequence

Start server side stack trace:
java.rmi.RemoteException: EJB Exception:; nested exception is:
java.sql.SQLException: ORA-01002: fetch out of sequence

java.sql.SQLException: ORA-01002: fetch out of sequence

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
at weblogic.jdbc.pool.PreparedStatement.executeQuery(PreparedStatement.java:51)
at weblogic.jdbc.rmi.internal.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:54)
at weblogic.jdbc.rmi.SerialPreparedStatement.executeQuery(SerialPreparedStatement.java:43)

I have the transaction isolation level is :
<transaction-isolation>
<isolation-level>TRANSACTION_READ_COMMITTED_FOR_UPDATE</isolation-level>
<method>
<description>...</description>
<ejb-name>OrderSpecificInfo</ejb-name>
<method-name>*</method-name>
</method>
</transaction-isolation>

Thanks so much !

[Dimitri Rakitine]

Are you using txdatasource (and not the regular jdbc connection pool) ?

Dung Nguyen <dun...@sdcgrp.com> wrote:

> Thanks so much !

--
Dimitri