Appendix B. SQL Server 2005, SQL Server 2008, and Oracle Database 10g Comparison
The following table shows the statements that are sent to the supported databases when database transactions are handled.
Dynamics AX 2009 | SQL Server 2005 | SQL Server 2008 | Oracle Database 10g |
---|---|---|---|
First ttsbegin statement | BEGIN TRANSACTION | BEGIN TRANSACTION | No statement sent |
Final ttscommit statement | COMMIT TRANSACTION | COMMIT TRANSACTION | COMMIT |
ttsabort statement | ROLLBACK TRANSACTION | ROLLBACK TRANSACTION | ROLLBACK |
selectLocked(false) | Not supported, so no hint added | Not supported, so no hint added | Not supported, so no hint added |
Select optimisticlock concurrencyModel (ConcurrencyModel:: OptimisticLock) | No hint | No hint | No hint |
Select pessimisticlock concurrencyModel (ConcurrencyModel:: PessimisticLock) ... |
Get Inside Microsoft Dynamics® AX 2009, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.