[dna-issues] [JBoss JIRA] Created: (DNA-520) DNA w/ JPA/Oracle - bad create table DNA_OPTIONS

[John Ament (JIRA)]

DNA w/ JPA/Oracle - bad create table DNA_OPTIONS 
-------------------------------------------------

                 Key: DNA-520
                 URL: https://jira.jboss.org/jira/browse/DNA-520
             Project: DNA
          Issue Type: Bug
         Environment: Oracle 10g
JBoss AS 5.1
JDK6
            Reporter: John Ament


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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira