Mapping a MySQL 5.0 View to an Entity Bean

[dparrilla]

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