aspose file tools*
The moose likes Object Relational Mapping and the fly likes Transaction Problem with Jboss, Oracle 10g Xe & CMP  Entities Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply locked New topic
Author

Transaction Problem with Jboss, Oracle 10g Xe & CMP Entities

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 GA

Thanks in advance.

Regards
Abhinav
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61206
    
  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]
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61206
    
  66

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Transaction Problem with Jboss, Oracle 10g Xe & CMP Entities