Oracle Auto Number Id Support

[recursivecodes]

Thanks for reporting an issue for Micronaut Data, please review the task list below before submitting the
issue. Your issue report will be closed if the issue is incomplete and the below tasks not completed.

NOTE: If you are unsure about something and the issue is more of a question a better place to ask questions is on Stack Overflow (http://stackoverflow.com/tags/micronaut) or Gitter (https://gitter.im/micronautfw/). DO NOT use the issue tracker to ask questions.

Task List

• Steps to reproduce provided
• Stacktrace (if present) provided
• Example that reproduces the problem uploaded to Github
• Full description of the issue provided (see below)

Steps to Reproduce

1. Create a table in an oracle db that uses auto number IDs
2. Create a model/repo that uses that table
3. Attempt persistence save operation

Table:

CREATE TABLE foo(
    "ID" NUMBER GENERATED ALWAYS AS IDENTITY
);

Expected Behaviour

The insert should occur without error and the object should be returned with the assigned auto number ID.

Actual Behaviour

Exception: Internal Server Error: SQL Error executing INSERT: ORA-02289: sequence does not exist

Environment Information

• Operating System: MacOS
• Micronaut Version: 1.3.5
• JDK Version: 11.0.2

Example Application

N/A

[recursivecodes]

Awesome. :)