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

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 Assignee: Randall Hauch 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.