Hi,

Using: JBoss 3.2.4RC1, MySQL

I have a one to one unidiretional CMR with the tables in two different schemas but in the same MySQL instance.

Jboss does not put the schema name with a "dot" in front of the tablenames in the generated query, so it fails.

Tried to change my Xdoclet

from

@ejb.persistence table-name = "SERVICE"

to

@ejb.persistence table-name = "MVC.SERVICE"

in a hope of schema recognisition. But that attempt failed badly.

Any ideas of a solution and still keep it as a CMR.

Thanks in advance

Goran