[
https://issues.apache.org/jira/browse/OPENJPA-2837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Enrico Olivelli updated OPENJPA-2837:
-------------------------------------
Description:
If you want to enable physical Foreign Keys you have to configure SchemaFactory
with 'native'.
In this case the LazySchemaFactory does not handle correctly delimiters and
everything breaks, even the creation of OPENJPA_SEQUENCE table.
The problem is that the query generated for loading the sequence value is:
{code:java}
SELECT `SEQUENCE_VALUE` FROM "herd"."`OPENJPA_SEQUENCE_TABLE`" WHERE `ID` = ?
FOR UPDATE [params=?]{code}
was:
If you want to enable physical Foreign Keys you have to configure SchemaFactory
with 'native'.
In this case the LazySchemaFactory does not handle correctly delimiters and
everything breaks, even the creation of OPENJPA_SEQUENCE table.
I am sill investigating, I will update this description as soon as I have more
details
> 'native' SchemaFactory (LazySchemaFactory) does not work with DBDictionaries
> that require delimiters (like HerdDBDictionary) and generated column values
> --------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-2837
> URL: https://issues.apache.org/jira/browse/OPENJPA-2837
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 3.1.2
> Reporter: Enrico Olivelli
> Priority: Critical
> Fix For: 3.1.3
>
>
> If you want to enable physical Foreign Keys you have to configure
> SchemaFactory with 'native'.
> In this case the LazySchemaFactory does not handle correctly delimiters and
> everything breaks, even the creation of OPENJPA_SEQUENCE table.
>
> The problem is that the query generated for loading the sequence value is:
> {code:java}
> SELECT `SEQUENCE_VALUE` FROM "herd"."`OPENJPA_SEQUENCE_TABLE`" WHERE `ID` = ?
> FOR UPDATE [params=?]{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
