Repository navigation
Transaction listener is not called properly with nested transactions #539
Description
Expected Behavior
When using nested transactions listener is called each time when the outer or inner transaction starts and ends/rolls back
Actual Behavior
The listener is not called in an expected way
Steps to Reproduce
Launch code with the nested transaction and observe the behavior
sqlcipher/sqlcipher-android-tests#39
SQLCipher version (can be identified by executing PRAGMA cipher_version;):
4.4.2 community
SQLCipher for Android version:
4.4.2
Note:
AndroidX SQLite database works as expected and dispatches all callbacks for nested and outer transactions.
Activity
oleksandr-semenov commentedon Mar 3, 2021
Android tests: sqlcipher/sqlcipher-android-tests#39
developernotes commentedon Mar 3, 2021
Hello @oleksandr-semenov
Unfortunately, the current Java implementation used within SQLCipher for Android does not allow nesting
SQLiteTransactionListenerinstances (i.e., it only allows for tracking a single listener, however, nested transactions are allowed). The current Google implementation ofandroid.database.sqliteappears to support this via embedding the listener into a transaction object managed via a session connection pool. This may be something we revisit in a future release.We will leave this ticket open for for review and further discussion in the future.
stale commentedon Jun 3, 2021
Hello, it looks like there has been no activity on this issue recently. Has the issue been fixed, or does it still require the community's attention? This issue may be closed if no further activity occurs. You may also label this issue as "bug", "enhancement", or "security" and I will leave it open. Thank you for your contributions.
stale commentedon Jun 23, 2021
Closing this issue after a prolonged period of inactivity. If this issue is still present in the latest release, please feel free to reopen with up-to-date information.