[
https://issues.apache.org/jira/browse/OPENJPA-582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Catalina Wei resolved OPENJPA-582.
----------------------------------
Resolution: Duplicate
Duplicate of OPENJPA-557
> when updating postgresql sequences last generated key query does not account
> for schema
> ---------------------------------------------------------------------------------------
>
> Key: OPENJPA-582
> URL: https://issues.apache.org/jira/browse/OPENJPA-582
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.0.1
> Environment: postgresql 8.1.11, debian
> Reporter: Mehmet Akif Olcay
> Priority: Minor
> Original Estimate: 1h
> Remaining Estimate: 1h
>
> In persistence.xml, a schema is defined for persistence unit with
> <property name="openjpa.jdbc.Schema" value="hukuk" />
> when an insertion occurs postgresql complains as
> database problem - HATA: "dava_id_seq" nesnesi mevcut değil {prepstmnt
> 22074838 SELECT CURRVAL('Dava_id_SEQ')} [code=0, state=42P01]
> in turkish meaning that: there is no dava_id_seq object,
> which was a sequence under the hukuk schema
> The schema defined in persistence.xml is not used for sequence names.
> Workaround:
> create an entry in persistence.xml as
> <property name="openjpa.jdbc.DBDictionary"
> value="postgres(LastGeneratedKeyQuery=SELECT CURRVAL(''{1}_{0}_SEQ''))" />
> I think, there must be a correction in DBDictionary of postgresql.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
