0 Replies Latest reply on Apr 26, 2006 6:45 PM by dparrilla

    Mapping a MySQL 5.0 View to an Entity Bean

    dparrilla Newbie

      Hi all,

      I'm trying to map a mysql 5.0 view to a EJB3 entity bean, but I get the following error:

      00:37:02,240 INFO [DatabaseMetadata] table not found: CS_O_NET_SKILL_V
      00:37:02,250 WARN [ServiceController] Problem starting service persistence.unit
      s:ear=999classifiedsolutions.ear.ear,unitName=ClassifiedSolutionsPar
      java.lang.reflect.InvocationTargetException
      etc... etc...


      The mapping of the other tables works, but I cannot map a single table. I have tried with mysql-connector-3.1.2 and mysql-connector-5.0beta, and I get the same error.

      My configuration is:

      JDK 150_6
      JBOSS 404RC1
      MYSQL 5.0
      mysql-connector-3.1.2 or mysql-connector-5.0beta

      and the code in my java class is:

      @Entity
      @Table(name="CS_O_NET_SKILL_V", uniqueConstraints = { } )
      
      public class CsONetSkill implements java.io.Serializable {
      
      etc...
      

      Anybody knows how I can map a MySQL View to an EJB3 entity bean? What am I doing wrong?

      Thanks in advance:
      Diego