File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JBoss/WildFly and the fly likes CMP Transactions with EJB3, Jboss & Oracle 10g XE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "CMP Transactions with EJB3, Jboss & Oracle 10g XE" Watch "CMP Transactions with EJB3, Jboss & Oracle 10g XE" New topic
Author

CMP Transactions with EJB3, Jboss & Oracle 10g XE

Abhinav Nigam
Greenhorn

Joined: Mar 20, 2007
Posts: 6
Hi All

I have two CMP entities (EJB3) defined over two tables in Oracle 10g XE DB, namely User & UserDetails. UserDetails references User entity in One-to-one unidirection fashion.

When I create a new User I have to insert a record using User entity & a corresponding record using the UserDetail.

Since the first insert is not committed when the UserDetails entity tries to insert the record in the UserDetails table. The parent child relationship fails.

Where should I define the DB isolation level?

I am using Jboss 4.0.5

Thanks in advance.

Regards
Abhinav
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61198
    
  66

"Abhinav 'Journeyman' Nigam",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
JavaRanch Sheriff


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Abhinav Nigam
Greenhorn

Joined: Mar 20, 2007
Posts: 6
Hi Bear

I think Journeyman was as fictitious as bear.

Anyways as you like it. You are the sheriff

Journeyman
Abhinav Nigam
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CMP Transactions with EJB3, Jboss & Oracle 10g XE