[JBoss-dev] [ jboss-Bugs-508053 ] table creation fails, deploy succeeds

[<no...@so...>]

Bugs item #508053, was opened at 2002-01-24 10: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: Closed
Resolution: Fixed
Priority: 5
Submitted By: Georg Schmid (giorgio42)
Assigned to: Dain Sundstrom (dsundstrom)
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.




----------------------------------------------------------------------

Comment By: Charles Bradley (cbradley2)
Date: 2002-04-25 16:11

Message:
Logged In: YES 
user_id=479872

Am I missing something, or is there a way to know which
version of JBoss will have this fix?

Is there a workaround?

Thanks!

----------------------------------------------------------------------

Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-01-28 12:56

Message:
Logged In: YES 
user_id=251431

JDBCStartCommand will now throw a Deployment exception if 
an exception occures while creating a table or adding a 
foreign key constraint.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=508053&group_id=22866