Commit Transaction returnning false

Classic Servoy
1

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

2

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.

3

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.

4

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. :(

5

What does the Servoy server log tell you?

6

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 :D