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!
what is your oracle-ds.xml configuration?