Skip to content
This repository has been archived by the owner on Mar 31, 2022. It is now read-only.

Unexpected error occurs when creating an entity generated from Oracle database #56

Closed
lovtsovaik opened this issue Mar 15, 2021 · 1 comment
Assignees
Labels
state: duplicate This issue or pull request already exists type: bug Something isn't working
Milestone

Comments

@lovtsovaik
Copy link

bomVersion = '1.0.0-SNAPSHOT'

see also the similar problem for MSSQL in #54

  1. Connect to Oracle server using a third-party program and execute sql script Sample-Oracle.sql.txt
  2. Create data store and connect it to this database
  3. Click Generate model, refresh list
  4. Select All tables -> Finish
  5. Add missed attributes to screens if needed
  6. Run the app
  7. Open Individual browser
  8. Create item

AR: Unexpected error occurs when trying to save

OracleDatabaseException: ORA-00001: нарушено ограничение уникальности (IRA_TEST.SYS_C003581863)
Error : 1, Position : 0, Sql = INSERT INTO INDIVIDUAL ("CUST_ID", "BIRTH_DATE", "FIRST_NAME", "LAST_NAME") VALUES (:1 , :2 , :3 , :4 ), OriginalSql = INSERT INTO INDIVIDUAL ("CUST_ID", "BIRTH_DATE", "FIRST_NAME", "LAST_NAME") VALUES (?, ?, ?, ?), Error Msg = ORA-00001: нарушено ограничение уникальности (IRA_TEST.SYS_C003581863)

The id defined as

    @JmixGeneratedValue
    @Column(name = "\"CUST_ID\"", nullable = false)
    @Id
    private Integer id;

ER: correct saving

@lovtsovaik lovtsovaik added the type: bug Something isn't working label Mar 15, 2021
@knstvk knstvk added this to the 1.0.0 milestone Mar 18, 2021
@dtaimanov
Copy link
Contributor

Duplicate of #54

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
state: duplicate This issue or pull request already exists type: bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants