Hello,
I am getting the following error, when I try to show data in a datagrid using getAll() method on the service over my table STUDENT, I am using services generated from LCDS 3.1. This is my error log;
faultString = "Unable to invoke a fill operation on destination 'DB.Student' due to the following error: class java.lang.RuntimeException:Hibernate jdbc exception on operation=fill error=could not execute query : sqlError = from SQLException: java.sql.SQLException: ORA-00904: "STUDENT0_"."CODE_A_CODE_B_CODE": invalid identifier
I have the following tables;
table STUDENT
CODE_C [PK]
CODE_B [PK] <=STUDENT_ROLE.CODE_A
CODE_A [PK] <=STUDENT_ROLE.CODE_B
NAME
SURNAME
/* CODE_A and CODE_B and CODE_C are composite primary keys for STUDENT table */
table STUDENT_ROLE
CODE_A [PK] <= DEPARTMENT.CODE_A
CODE_B [PK]
DESCRIPTION
...
/* CODE_A and CODE_B are composite primary keys for STUDENT_ROLE table */
table DEPARTMENT
CODE_A [PK]
NAME
DESCRIPTION
....