[OPENJPA-1842] CachedEntityStatistics depends on @GeneratedValue which is not supported in Oracle by default

• Type: Test
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.0.1
• Fix Version/s: 2.0.2, 2.1.0
• Assignee: Albert Lee
• Reporter: Albert Lee
• Created: 18/Oct/10 21:53
• Updated: 20/Oct/10 21:17
• Resolved: 20/Oct/10 21:17

Description

CachedEntityStatistics depends on @GeneratedValue which is not supported in Oracle by default unless special trigger and OracleDictionary setting is implemented.

Otherwise, the following similar exception will be observed.

Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-01400: cannot insert NULL into ("JPAUSER"."CACHEDENTITYSTATISTICS"."ID")

{prepstmnt 406657085 INSERT INTO CachedEntityStatistics (firstName, lastName, version) VALUES (?, ?, ?) [params=?, ?, ?]}

[code=1400, state=23000]

SInce TestStatistics, the test case uses CachedEntityStatistics, is not testing GeneratedValue per se, will remove the annotation and implement a simple id assignment in CachedEntityStatistics class.