1 Reply Latest reply on Dec 30, 2005 7:53 PM by Emmanuel Bernard

    Using Views with derived columns

    James Moring Newbie

      Consider the following SQL Server view...

      create view Employee_DOC
      as

      select

      FirstName,
      LastName,
      GenderCode,
      GenderDesc = dbo.getCodeDescriprtion( 'GENDER', GenderCode ),
      SSN

      from Employees


      It uses a derived column and is thus unupdateable (no insert or update). It can not be used by an Entity bean if you want that bean to be updateable. What would be great is if you could specify a table (or view) to used for reading and a different table for saving. This does not appear to be a feature of EBJ3/Hibernate, but is there a way to achieve the same outcome?

      Amazing product!! My deepest admiration to those responsible.

      Jim