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: