2 Replies Latest reply on Apr 21, 2004 4:57 AM by jimbrady

    Specifying an Oracle database schema for CMP beans

    null null Newbie

      Hi, I'm sort of new to EJBs. I am working with CMP beans that uses JBOSS 4.0 as the application server and Oracle8i as the database. I am able to create and deploy a simple CMP bean that creates a table in the Oracle databse. In my Oracle-ds.xml i have given the database configuration including the user /password.
      My problem is that when the bean gets deployed, by default the table gets created in a schema named the same as the user name specified in my Oracle-ds.xml.
      How can I get my tables created in a different schema in the Oracle db other than in the "username" schema? Please help.

      thanks in advance
      wkst