1 Reply Latest reply on Oct 22, 2003 4:30 PM by Ivan O. Parra

    Who knows how to configure the JBoss to use Oracle9i as CMP'

    xf_fong Newbie

      System and software condition:
      JBoss(Version is jboss-3.0.8_tomcat-4.1.24,and installed on 192.168.18.10)
      Oracle9i(Installed on 192.168.18.20,SID=Roster,user=system,password=manage)
      EJB(The Movie bean, an example in Thinking in Enterprise Java by Bruce Eckel.This CMP sample only create and manipulate the Movie table,and this sample CMP bean has been proved right in JBoss' default database Hypersonic)

      I have followed some instructions to modified jboss-service.xml,login-config.xml,standardjbosscmp-jdbc.xml and oralce-service.xml to change the JBoss' default database to Oracle9i,but when deploy my Movie EJB in the JBoss,it shows:
      15:38:54,921 WARN [ServiceController] Problem starting service jboss.j2ee:jndiN
      ame=javatheater/Movie,service=EJB
      org.jboss.deployment.DeploymentException: Error while creating table MOVIE; - ne
      sted throwable: (java.sql.SQLException: Wrong data type: NUMBER in statement [CR
      EATE TABLE MOVIE (id NUMBER(10) NOT NULL, title VARCHAR2(255), CONSTRAINT PK_MOV
      IE PRIMARY KEY (id))])
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStart
      Command.java:175)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartComm
      and.java:84)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDB
      CStoreManager.java:457)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManage
      r.java:369)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManag
      er.java:198)
      at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
      at org.jboss.ejb.Container.invoke(Container.java:782)
      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
      ....................................

      I think something was wrong??Who can give me a detail instruction on how to change the JBoss' default database and how to modify the CMP EJB's deployment descriptor for the JBoss?

      Thanks!