[jira] Commented: (OPENJPA-1842) CachedEntityStatistics depends on @GeneratedValue which is not supported in Oracle by default

["Rick Curtis (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENJPA-1842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12922320#action_12922320 ] 

Rick Curtis commented on OPENJPA-1842:
--------------------------------------

Would changing the strategy to GenerationType.AUTO make the problem go away?

> CachedEntityStatistics depends on @GeneratedValue which is not supported in Oracle by default
> ---------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-1842
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1842
>             Project: OpenJPA
>          Issue Type: Test
>    Affects Versions: 2.0.0, 2.0.1
>            Reporter: Albert Lee
>            Assignee: Albert Lee
>            Priority: Minor
>             Fix For: 2.0.2, 2.1.0
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.