Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-518

DNA w/ JPA/Oracle - bad create table DNA_OPTIONS

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 0.6
    • None
    • None
    • None

      The create table generated for DNA_OPTIONS is
      create table DNA_OPTIONS (NAME varchar2(512 char) not null unique, VALUE varchar2(512 char) not null, primary key (NAME))

      However, to work correctly in Oracle, it should be:

      create table DNA_OPTIONS (NAME varchar2(512 char) not null, VALUE varchar2(512 char) not null, primary key (NAME))

      which means we have to remove the unique=true attribute from dna options entity.

      There may be another entity like this as well, will double check.

              rhauch Randall Hauch (Inactive)
              meetoblivion_jira John Ament (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: