I have a Customer table with a relationship to an EyeColorCode table.  The 
eyeColorCode is maintained on inserts and updates through Sql Server triggers.  
Both triggers do basically the same check.

Inserts behave as expected but updates aren't working.

However, if I remove the tU_Customer, the update executes successfully?  This 
is, unfortunately, not an option.

I was wondering if there is a setting that I need to flip in order for this to 
complete successfully?

The error states:

  | org.jboss.tm.JBossRollbackException: Unable to commit, 
tx=TransactionImpl:XidImpl[
  | ...
  | Update failed. Expected one affected row: rowsAffected=0, id=tableid
  | 


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

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


-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to