0 Replies Latest reply on May 11, 2004 7:14 PM by gorano

    CMR and 2 schemas

    gorano Newbie

      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