Part 4. Appendices

Table of Contents

1. JPA Resources
2. Supported Databases
1. Overview
2. Verified Database Matrix
3. Compatible Database Matrix
4. Unverified Database Matrix
5. Apache Derby
6. Borland Interbase
6.1. Known issues with Interbase
7. JDataStore
8. IBM DB2
8.1. Known issues with DB2
9. Empress
9.1. Known issues with Empress
10. H2 Database Engine
10.1. Known issues with H2 Database Engine
11. Hypersonic
11.1. Known issues with Hypersonic
12. Firebird
12.1. Known issues with Firebird
13. Informix
13.1. Known issues with Informix
14. Ingres Database
14.1. Known issues with Ingres
15. InterSystems Cache
15.1. Known issues with InterSystems Cache
16. Microsoft Access
16.1. Known issues with Microsoft Access
17. Microsoft SQL Server
17.1. Known issues with SQL Server
18. Microsoft FoxPro
18.1. Known issues with Microsoft FoxPro
19. MySQL
19.1. Using Query Hints with MySQL
19.2. Known issues with MySQL
20. Oracle
20.1. Using Query Hints with Oracle
20.2. Known issues with Oracle
21. Pointbase
21.1. Known issues with Pointbase
22. PostgreSQL
22.1. Known issues with PostgreSQL
23. IBM solidDB
23.1. M-type tables vs. D-type tables
23.2. Concurrency control mechanism
24. Sybase Adaptive Server
24.1. Known issues with Sybase
3. Migration Considerations
1. OpenJPA 2.0.0
1.1. Incompatibilities
1.1.1. getProperties()
1.1.2. Detach Behavior
1.1.3. Use of private persistent properties
1.1.4. Query.setParameter()
1.1.5. Serialization of Entities
1.1.6. openjpa.jdbc.QuerySQLCache
1.2. Disabling AutoOff Collection Tracking
1.3. Internal Behavioral Differences
1.3.1. PreUpdate/PostUpdate Life Cycle Callbacks
1.3.2. createEntityManagerFactory Exceptions
1.3.3. openjpa.QueryCache default
2. OpenJPA 2.2.0
2.1. Incompatibilities
2.1.1. allocationSize Property of Sequence Generator
2.1.2. MetaModel Attributes for Arrays
2.1.3. supportsSetClob Property.
2.1.4. useNativeSequenceCache Property.
2.1.5. Cascade persist behavior
2.1.6. Life Cycle Event Manager Callback Behavior
2.1.7. shared-cache-mode Property