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
