Bugs item #508053, was opened at 2002-01-24 09:31
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=508053&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Georg Schmid (giorgio42)
Assigned to: Nobody/Anonymous (nobody)
Summary: table creation fails, deploy succeeds
Initial Comment:
RH 3.0 (200200105), W2K, JDK1.3.1_02, Oracle8.1.7
Even if a "create table" throws an exception during
deployment of an entity bean (for instance, because the
same column name appears twice in the corresponding
jbosscmp-jdbc.xml definition) as can be seen in the
debug log, the deployer continues and finally reports
"Created table xxx successfully" and the deployment
succeeds.
The transaction is rolled back, but otherwise the
exception is ignored.
Naturally enough, creating instances of the
corresponding entity bean fails with "table or view
does not exist" later on:
2002-01-24 17:30:42,864 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.MaintenanceTriggerEB]
Executing SQL: CREATE TABLE MAINTENANCE_TRIGGER (ID
VARCHAR2(16), TYPE VARCHAR2(16), UNIT VARCHAR2(16),
VALUE VARCHAR2(16), LEVEL VARCHAR2(16), CONSTRAINT
pk_MAINTENANCE_TRIGGER PRIMARY KEY (ID))
2002-01-24 17:30:42,864 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.MaintenanceTriggerEB]
Could not create table MAINTENANCE_TRIGGER
java.sql.SQLException: ORA-00904: invalid column name
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:693)
at
org.jboss.resource.adapter.jdbc.local.StatementInPool.executeUpdate(StatementInPool.java:736)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:154)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:78)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:303)
at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:175)
at
org.jboss.ejb.EntityContainer.start(EntityContainer.java:341)
at org.jboss.ejb.Application.start(Application.java:219)
at
org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:389)
at
org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:312)
at java.lang.reflect.Method.invoke(Native Method)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at
org.jboss.deployment.J2eeDeployer.startModules(J2eeDeployer.java:468)
at
org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:439)
at
org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:203)
at java.lang.reflect.Method.invoke(Native Method)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at
org.jboss.deployment.AutoDeployer.deploy(AutoDeployer.java:681)
at
org.jboss.deployment.AutoDeployer.run(AutoDeployer.java:325)
at java.lang.Thread.run(Unknown Source)
2002-01-24 17:30:42,864 DEBUG [org.jboss.tm.TxCapsule]
rollback(): Entered, tx=XidImpl [FormatId=257,
GlobalId=cna0796942//30, BranchQual=] status=STATUS_ACTIVE
2002-01-24 17:30:42,864 DEBUG [org.jboss.tm.TxManager]
rolled back tx: TransactionImpl:XidImpl [FormatId=257,
GlobalId=cna0796942//30, BranchQual=]
2002-01-24 17:30:42,864 INFO
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.MaintenanceTriggerEB]
Created table 'MAINTENANCE_TRIGGER' successfully.
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=508053&group_id=22866
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
