Hi:
I am using jboss 4.2.1 with ejb3 default configuration
If I make a native query execute update in a Session bean:
User user = new User(userId);
| myEntityManager.persist(user);
|
| String insertUserInOldTable = "insert into olduserstable values('" +
userId + "');
| myEntityManager.createNativeQuery(insertUserInOldTable ).executeUpdate();
|
| String userCreate = "CREATE USER " + userId + " IDENTIFIED BY " +
userPassword + " DEFAULT TABLESPACE TB1 TEMPORARY TABLESPACE TEMPORARY PROFILE
P1";
| myEntityManager.createNativeQuery(userCreate).executeUpdate();
If the "create user " statement fails, the Entity bean code rolls back correctly
but the insert statement does not roll back.
Why?
We need this to maintain old tables (no ejbs) in sync with new tables (ejb3)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4116645#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...