A
A_Haddad
Guest
Hello, I am trying to make my rule-flow working with a customer's Progress OpenEdge DB (using EDC). Corticon studio version is 5.5.1 OpenEdge DB version : 10.2B06 Question 1: What is the best Identity strategy (Native, Table, Sequence...?) adapted to the case of a database primary key composed by multiple fields? Question 2: I have a business entity called "Party" that I am trying to map with a table having a different name (REU). I don't understand the origins of following incoherences: I defined as "Entity Identity" an integer attribute I called Party.Id. I mapped Party.Id to the DB field REU.NUM-REU which is an integer field and makes part of the primary key of REU. Error 1 : Corticon studio is saying : Warning : Entity Party identity attribute Id is mapped to column PUB.REU.NUM-REU but that column is not part of the primary key. (But this is not true!) Error 2 : When validating the vocabulary mapping or running a rule-test using Party entity, I have the following exception : org.hibernate.HibernateException: Wrong column type in TUPPER.PUB.REU for column NUM-REU. Found: integer, expected: numeric. I don't see why a "numeric" data-type is expected as integer is the right data-type for both vocabulary attribute and the concerned DB field? Error 3 : I updated the data-type of my vocabulary attribute to "decimal" to see if it changes anything. I have a new warning saying: Attribute data type Decimal cannot be mapped to database type integer. Supported database types: {numeric; DECIMAL; REAL; DOUBLE} So Integer seems to be the right data-type. Why was it rejected previously? Did someone else encountred same problems?
Continue reading...
Continue reading...