Part 4. Appendices

Table of Contents

1. JPA Resources
2. Supported Databases
1. Overview
2. Verified Database Matrix
3. Compatible Database Matrix
4. Apache Derby
5. Borland Interbase
5.1. Known issues with Interbase
6. JDataStore
7. IBM DB2
7.1. Known issues with DB2
8. Empress
8.1. Known issues with Empress
9. H2 Database Engine
9.1. Known issues with H2 Database Engine
10. Hypersonic
10.1. Known issues with Hypersonic
11. Firebird
11.1. Known issues with Firebird
12. Informix
12.1. Known issues with Informix
13. Ingres Database
13.1. Known issues with Ingres
14. InterSystems Cache
14.1. Known issues with InterSystems Cache
15. Microsoft Access
15.1. Known issues with Microsoft Access
16. Microsoft SQL Server
16.1. Known issues with SQL Server
17. Microsoft FoxPro
17.1. Known issues with Microsoft FoxPro
18. MySQL
18.1. Using Query Hints with MySQL
18.2. Known issues with MySQL
19. Oracle
19.1. Using Query Hints with Oracle
19.2. Known issues with Oracle
20. Pointbase
20.1. Known issues with Pointbase
21. PostgreSQL
21.1. Known issues with PostgreSQL
22. Sybase Adaptive Server
22.1. Known issues with Sybase
3. Migration Considerations
1. JPA 2.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.setParameteres()
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. FieldMapping.getStrategy()
1.3.2. PreUpdate/PostUpdate Life Cycle Callbacks
1.3.3. createEntityManagerFactory Exceptions
1.3.4. openjpa.QueryCache default