Unique constraint annotations not generated by Reverse Mapping tool

[anand213]

Hi, 
I am trying to reverse map beans by directly connecting to H2 DB. Below is
the DB schema to reverse. It has couple of unique keys and a non-unique key.
These are read by the tool but no annotations generated for the same: 

CREATE SCHEMA TEST; 

CREATE TABLE TEST.EMPLOYEE_FOR_CACHE ( 
ID INT PRIMARY KEY, 
FNAME VARCHAR2(50), 
LNAME VARCHAR2(50), 
PROJECT VARCHAR2(10), 
DEPT VARCHAR2(50), 
LOCATION VARCHAR2(50) 
); 

-- Indexes: 
CREATE INDEX ON TEST.EMPLOYEE_FOR_CACHE(LNAME); 
CREATE UNIQUE INDEX ON TEST.EMPLOYEE_FOR_CACHE(FNAME, LNAME, LOCATION); 
CREATE UNIQUE INDEX ON TEST.EMPLOYEE_FOR_CACHE(DEPT, PROJECT); 


Below is the generated bean: 
@Entity 
@Table( name="EMPLOYEE_FOR_CACHE") 
public class EmployeeForCache { 
        @Basic 
        @Column(length=50) 
        private String dept; 

        @Basic 
        @Column(length=50) 
        private String fname; 

        @Id 
        private int id; 

        @Basic 
        @Column(length=50) 
        private String lname; 

        @Basic 
        @Column(length=50) 
        private String location; 

        @Basic 
        @Column(length=10) 
        private String project; 


        public EmployeeForCache() { 
        } 

        public EmployeeForCache(int id) { 
                this.id = id; 
        } 

        public String getDept() { 
                return dept; 
        } 

        public void setDept(String dept) { 
                this.dept = dept; 
        } 

        public String getFname() { 
                return fname; 
        } 

        public void setFname(String fname) { 
                this.fname = fname; 
        } 

        public int getId() { 
                return id; 
        } 

        public void setId(int id) { 
                this.id = id; 
        } 

        public String getLname() { 
                return lname; 
        } 

        public void setLname(String lname) { 
                this.lname = lname; 
        } 

        public String getLocation() { 
                return location; 
        } 

        public void setLocation(String location) { 
                this.location = location; 
        } 

        public String getProject() { 
                return project; 
        } 

        public void setProject(String project) { 
                this.project = project; 
        } 
} 



Below are the logs: 

94  cut-jpa-bean-generator  TRACE  [main] openjpa.jdbc.Schema - Found
existing index "INDEX_14" on table "TEST.EMPLOYEE_FOR_CACHE (FNAME)". 
94  cut-jpa-bean-generator  TRACE  [main] openjpa.jdbc.Schema - Found
existing index "INDEX_14" on table "TEST.EMPLOYEE_FOR_CACHE (LNAME)". 
94  cut-jpa-bean-generator  TRACE  [main] openjpa.jdbc.Schema - Found
existing index "INDEX_14" on table "TEST.EMPLOYEE_FOR_CACHE (LOCATION)". 
94  cut-jpa-bean-generator  TRACE  [main] openjpa.jdbc.Schema - Found
existing index "INDEX_14C" on table "TEST.EMPLOYEE_FOR_CACHE (DEPT)". 
94  cut-jpa-bean-generator  TRACE  [main] openjpa.jdbc.Schema - Found
existing index "INDEX_14C" on table "TEST.EMPLOYEE_FOR_CACHE (PROJECT)". 
94  cut-jpa-bean-generator  TRACE  [main] openjpa.jdbc.Schema - Found
existing index "PRIMARY_KEY_1" on table "TEST.EMPLOYEE_FOR_CACHE (ID)". 
94  cut-jpa-bean-generator  TRACE  [main] openjpa.jdbc.Schema - Found
existing index "INDEX_1" on table "TEST.EMPLOYEE_FOR_CACHE (LNAME)". 
94  cut-jpa-bean-generator  TRACE  [main] openjpa.jdbc.Schema - Reading
foreign keys for schema name "TEST", table name "TEST.EMPLOYEE_FOR_CACHE". 
109  cut-jpa-bean-generator  INFO   [main] openjpa.Tool - ReverseMappingTool
: generating classes. 
107259  cut-jpa-bean-generator  INFO   [main] openjpa.Tool - Generating
annotations. 
110368  cut-jpa-bean-generator  INFO   [main] openjpa.Tool - Writing
generated class source code. 



I am using below reverse properties: 
-pkg, com.bofa.cut.jpa.entity.bean, -directory, ./scr/test/java, -log,
'DefaultLevel=WARN, Tool=INFO, SQL=TRACE,Schema=TRACE', -metadata, none,
-useGenericCollections, true, -annotations, true, -connectionURL, ..... 

OPen JPA version: 2.2.0

Thanks and Regards, 
AKumar



--
View this message in context: 
http://openjpa.208410.n2.nabble.com/Unique-constraint-annotations-not-generated-by-Reverse-Mapping-tool-tp7582055.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.