0 Replies Latest reply on Jul 13, 2010 7:16 AM by adnan.m

    ORA-00904 error

    adnan.m Level 1

      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
      ....