Hibernate Community • View topic - Table update returns multiple results due to update trigger

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Table update returns multiple results due to update trigger

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

lanman2000

Post subject: Table update returns multiple results due to update trigger

Posted: Fri Mar 31, 2006 3:45 pm

Newbie

Joined: Wed Sep 28, 2005 12:24 am
Posts: 15

Here is an interesting one we ran across today. We have a single table called "Contact" and a "Contact" object to represent it.

When updating rows in this table we get the error :

org.hibernate.HibernateException: Unexpected row count: 0 expected: 1

The cause of the error is becuase we have a trigger on the contact table that writes rows to an audit table so multiple "rows returned" results come back from the database. Here is the output when run in SQL Query Analyzer:

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

of course because hibernate is just doing a simple update it expects to just see:

(1 row(s) affected)

hence the error..

any idea how to fix or workaround this?

Top

lanman2000

Post subject:

Posted: Fri Mar 31, 2006 11:29 pm

Newbie

Joined: Wed Sep 28, 2005 12:24 am
Posts: 15

bump

Top

lanman2000

Post subject:

Posted: Mon Apr 03, 2006 10:37 am

Newbie

Joined: Wed Sep 28, 2005 12:24 am
Posts: 15

bump. anyone?

Top

abiman

Post subject:

Posted: Wed Jul 26, 2006 6:15 pm

Newbie

Joined: Fri May 06, 2005 9:03 pm
Posts: 4

BUMP ! Anybody found a resolution for this yet?

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum