Maxim Solodovnik created OPENJPA-2883:
-----------------------------------------
Summary: UseTriggersForAutoAssign in Oracle seems to be broken
Key: OPENJPA-2883
URL: https://issues.apache.org/jira/browse/OPENJPA-2883
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Affects Versions: 3.2.0
Reporter: Maxim Solodovnik
Assignee: Maxim Solodovnik
Fix For: 3.2.1
Everything works as expected in {{openjpa:3.1.2}}
In case Oracle DB is used and Entity has {{@GeneratedValue(strategy =
GenerationType.IDENTITY)}} annotation
The following error is thrown:
{code}
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-32795: cannot
insert into a generated always identity column
{stmnt 2049051802 CREATE OR REPLACE TRIGGER PObjectNative_id_TRG BEFORE INSERT
ON PObjectNative FOR EACH ROW BEGIN SELECT PObjectNative_id_SEQ.nextval INTO
:new.id FROM DUAL; END PObjectNative_id_TRG;} [code=32795, state=99999]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:955)
at
org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:123)
at
org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1375)
at
org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:1114)
at
org.apache.openjpa.jdbc.schema.SchemaTool.buildSchema(SchemaTool.java:660)
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:565)
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:400)
at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:372)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:571)
... 36 more
{code}
The issue seems to be caused by introducing {{"GENERATED ALWAYS AS IDENTITY"}}
in {{3.2.0}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
