Bugs item #508053, was opened at 2002-01-24 18: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: Georg Schmid (giorgio42)
Date: 2002-04-26 07:57
Message:
Logged In: YES
user_id=437570
The bug has disappeared in JBoss 3.0 since end of
January, so it does not occur anymore in JB3.0.0Beta2 or
JB3.1.0alpha.
Georg
----------------------------------------------------------------------
Comment By: Charles Bradley (cbradley2)
Date: 2002-04-26 01: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 20: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
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
