End of transaction

Classic Servoy
1

Hi,

If I correctly understand how transactions work, when I start a transaction:

  • if I show a FormA (related to database A), It open a transaction on Database A
  • if I show a FormB (related to database B), it open a transaction on Database B
  • if I show a FormC (related to database C), it open a transaction on Database C
  • if I show a FormA (related to database A), noting append because the transaction on database A is already open.
  • If I close transaction with commit, All transactions will be close.

But I have a mistake, “sometimes” when I have 3 transactions open on 3 differents databases and when I close transactions with commit method, the solution close only 2 transactions.
So this problem let a active connection on my database, and after a few hours, my database is saturated and the solution freeze.

I would like to konw if somebody else have the same problem and can confirm this.

Another thing, I don’t understand why the first time I do operations above, transactions are visible in web admin, but when I do again operations, nothing is show on web admin.

Thanks

2

Some more observations, I have ofen 3 transactions open in same time, and the only transaction which don’t close is always the same.

This transaction is on my database name ‘initialisation’.
I have a solution name ‘initialisation’ use as module in my main solution.

Perhaps the problem is due to this ?