[
https://issues.apache.org/jira/browse/OPENJPA-427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540693
]
Ryosuke Iwata commented on OPENJPA-427:
---------------------------------------
I built OpenJPA with my patch and deployed my EAR with the private build.
Finally, @Entity objects with IDENTITY key generation no longer cause
exceptions that I reported. IDENTITY sequence names seem to be handled
correctly. And, for now, I don't see any side effects.
I hope that this patch is included as soon as possible, because our product
needs IDENTITY key generation.
Thank you.
> PostgresDictionary should set "63" as "maxAutoAssignNameLength".
> ----------------------------------------------------------------
>
> Key: OPENJPA-427
> URL: https://issues.apache.org/jira/browse/OPENJPA-427
> Project: OpenJPA
> Issue Type: Bug
> Components: sql
> Affects Versions: 1.0.0, 1.1.0
> Environment: PostgreSQL 8.1.
> Reporter: Ryosuke Iwata
> Priority: Blocker
> Attachments: mychanges.patch
>
>
> PostgresDictionary should set "63" (or something correct) as
> "maxAutoAssignNameLength", in order to let
> DBDictionary#getGeneratedKeySequenceName() generate correct names for
> IDENTITY sequences.
> OpenJPA trims IDENTITY sequence names longer than 32 characters, while
> PostgreSQL uses longer names for BIGSERIAL sequences. So, persisting entities
> with @Id column with GenerationType.IDENTITY often results in a database
> error such as :
> org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: relation
> "x_school_membershi_entityid_seq" does not exist {prepstmnt 2398193 SELECT
> CURRVAL(X_SCHOOL_TRANSFER_entityId_SEQ')} [code=0, state=42P01]
> The followings are the examples. "OK"s are the sequence names which
> PostgreSQL uses. "NG"s are those which OpenJPA attempts to use.
> Ex.1 -
> Table : X_SCHOOL_TRANSFER_EVENT
> BIGSERIAL Column : ENTITYID
> OK : X_SCHOOL_TRANSFER_EVENT_ENTITY_ID_SEQ
> NG : 'X_SCHOOL_TRANSFER__ENTITYID_SEQ
> Ex.2 -
> Table : X_SCHOOL_MEMBERSHIP
> BIGSERIAL Column : ENTITYID
> OK : X_SCHOOL_MEMBERSHIP_ENTITYID_SEQ
> NG : X_SCHOOL_MEMBERSHI_ENTITYID_SEQ
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
