I have been working on getting all database structure changes complete, I 
seemed to be having an issue with the way our oracle datasource is configured 
(see below). Does anyone know how to configure the oracle datasource to fix 
this? 

When using a non-transaction-enabled DataSource, a "java.sql.SQLException: 
ORA-01002" error will occur when creating a CMP entity bean which has a field 
mapped to Oracle CLOB/BLOB.

The EJB container inserts a row which has CLOB/BLOB columns as follows:


insert into the table initializing the LOB using EMPTY_BLOB() or EMPTY_CLOB(). 

retrieve the LOB locator using select for update statement. 

modify the LOB. 
Although the connection from a non-transaction-enabled DataSource is in 
auto-commit mode, Oracle LOB locators that are used to write cannot span the 
transactions. So the transaction is closed at step 1 and then ORA-1002 occurs 
at step 2.


View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3870381#3870381

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3870381


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to