[
https://jira.jboss.org/jira/browse/DNA-520?page=com.atlassian.jira.plugin...
]
John Ament commented on DNA-520:
--------------------------------
Sorry stated wrong.
In source (StoreOptionEntity.java) :
@Id
@Column( name = "NAME", nullable = false, unique = true, length = 512 )
private String name;
Should be
@Id
@Column( name = "NAME", nullable = false, length = 512 )
private String name;
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