# Commit Transaction returnning false

**URL:** <https://forum.servoy.com/t/commit-transaction-returnning-false/8199>\
**Category:** Classic Servoy\
**Created:** [October 3, 2007, 12:59pm UTC](https://forum.servoy.com/t/commit-transaction-returnning-false/8199 "2007-10-03T12:59:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ars](https://avatars.discourse-cdn.com/v4/letter/a/e19adc/32.png) [@ars](https://forum.servoy.com/u/ars)\
**Post date:** [October 3, 2007, 12:59pm UTC](https://forum.servoy.com/t/commit-transaction-returnning-false/8199/1 "2007-10-03T12:59:30Z")

</div>

Hi all,

I my application I am using Transaction to control database operations. But, When I am going to executing the application, the databasemanager.commmitTrasaction() method returns false, and also the values are not saved to the database(Sybase iAnywhere) permanently.

I want to know that, under what condition generally, databasemanager.commitTransaction() returns false?

Thanks

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [October 3, 2007, 1:03pm UTC](https://forum.servoy.com/t/commit-transaction-returnning-false/8199/2 "2007-10-03T13:03:31Z")

</div>

Did you check the Sybase log? Or the Servoy server log?  
Most likely the database threw an error due to a constraint and the whole transaction was rolled back.

---

<div class="post-metadata">

**Author:** ![ars](https://avatars.discourse-cdn.com/v4/letter/a/e19adc/32.png) [@ars](https://forum.servoy.com/u/ars)\
**Post date:** [October 3, 2007, 1:07pm UTC](https://forum.servoy.com/t/commit-transaction-returnning-false/8199/3 "2007-10-03T13:07:24Z")

</div>

Thanks Robert for the quick reply.

> I. 10/03 17:16:05. Connection terminated abnormally; client socket shut down

I have got only one error at the Sybase log.

---

<div class="post-metadata">

**Author:** ![ars](https://avatars.discourse-cdn.com/v4/letter/a/e19adc/32.png) [@ars](https://forum.servoy.com/u/ars)\
**Post date:** [October 3, 2007, 1:10pm UTC](https://forum.servoy.com/t/commit-transaction-returnning-false/8199/4 "2007-10-03T13:10:13Z")

</div>

> ROCLASI:  
> Most likely the database threw an error due to a constraint and the whole transaction was rolled back.

Yes, there are some field with not null constarint, but I am checking the values prior to commiting the transaction.

Still it is returning false. ![:(]( "Sad")

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [October 3, 2007, 1:27pm UTC](https://forum.servoy.com/t/commit-transaction-returnning-false/8199/5 "2007-10-03T13:27:27Z")

</div>

What does the Servoy server log tell you?

---

<div class="post-metadata">

**Author:** ![ars](https://avatars.discourse-cdn.com/v4/letter/a/e19adc/32.png) [@ars](https://forum.servoy.com/u/ars)\
**Post date:** [October 3, 2007, 1:32pm UTC](https://forum.servoy.com/t/commit-transaction-returnning-false/8199/6 "2007-10-03T13:32:13Z")

</div>

Thanks Robert.

It is solved.

It is returning false due to a not null(constraint) field. Now It is solved.

Thanks a Lot, Robert. ![:D]( "Very Happy") ![:D]( "Very Happy")