I have applied this patch, and when I try to read a CLOB I get this exception:
java.sql.SQLException: operation not allowed: streams type cannot be used in
batching
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at
oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java
:3249)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.ojb.broker.util.batch.PreparedStatementInvocationHandler.doExecute(Pr
eparedStatementInvocationHandler.java:166)
at
org.apache.ojb.broker.util.batch.PreparedStatementInvocationHandler.invoke(Prepa
redStatementInvocationHandler.java:131)
at $Proxy9.doExecute(Unknown Source)
at
org.apache.ojb.broker.util.batch.BatchConnection.executeBatch(BatchConnection.ja
va:178)
at
org.apache.ojb.broker.accesslayer.ConnectionManager.executeBatch(ConnectionManag
er.java:301)
at
org.apache.ojb.odmg.ObjectEnvelopeTable.commit(ObjectEnvelopeTable.java:210)
at
org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(TransactionImpl.java:317)
at org.apache.ojb.odmg.TransactionImpl.prepare(TransactionImpl.java:566)
at org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:516)
at gov.doi.cap.activity.SimpleActivity.apply(SimpleActivity.java:48)
Any ideas?
thanks,
-steve
Steve Clark
Technology Applications Team
Natural Resources Research Center/USGS
[EMAIL PROTECTED]
(970)226-9291
>From: "Rajeev Kaul" <[EMAIL PROTECTED]>
>To: "OJB Users List" <[EMAIL PROTECTED]>, "sclark"
<[EMAIL PROTECTED]>
>Subject: Re: CLOBs vs. Oracle!
>
>CLOBs do not work out of the box with Oracle and 0.9.8. However, I have
>managed to make them work for me with Oracle 8.1.7 and OJB 0.9.8. with the
>attached modifications. I have also included my repository settings if they
>are of any help.
>
>
>----- Original Message -----
>From: "sclark" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, January 27, 2003 4:33 PM
>Subject: CLOBs vs. Oracle!
>
>
>> I'm having trouble getting CLOBs to work with Oracle (9.0.1, OJB 0.9.8),
>and in
>> truth I'm not clear whether they are expected to. I have tried with and
>without
>> various pieces of Rajeev's patch from last November
>> (http://archives.apache.org/eyebrowse/ReadMsg?listId=107&msgNo=3610),
>which has
>> not been committed to CVS, and I get a variety of exceptions during read,
>write,
>> or both.
>>
>> Can somebody confirm whether CLOBs work out of the box with Oracle and
>0.9.8?
>>
>> thanks,
>> -steve
>>
>>
>> --
>> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
>> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
