SQL Error in 3.2.1, worked in 3.0.4
ftg314159 May 9, 2003 4:33 PMIf I do a fresh install of 3.2.1 and deploy my EAR, I get the following:
15:50:31,050 ERROR [EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Column already exists in statement [CREATE TABLE WDREQUESTRQENTITYBEAN (id BIGINT NOT NULL, name VARCHAR(256), owner VARCHAR(256), logId BIGINT, systemPreProcessingStages VARBINARY, userPreProcessingStages
VARBINARY, userNormalStages VARBINARY, systemPostProcessingStages VARBINARY, userPostProcessingStages VARBINARY, systemNotificationTargets VARBINARY, userNotificationTargets VARBINARY, userNotificationTargets VARBINARY, stageGroups VARBINARY, activeStages VARBINARY, suspendedStages VARBINARY, outputs VARBINARY, principalInfo VARBINARY, debugEntry VARBINARY, dispatchRequired BIT NOT NULL, requestFailed BIT NOT NULL, CONSTRAINT PK_WDREQUESTRQENTITYBEAN PRIMARY KEY (id))])
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:178)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:87)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:499)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:410)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:170)
at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)
This EAR deploys fine under 3.0.4. The ejb-jar for the bean mentioned is:
<ejb-name>WDRequestRQEntityBean</ejb-name>
com.aonix.WebData.request.WDRequestRQEntityHomeRemote
<local-home>com.aonix.WebData.request.WDRequestRQEntityHomeLocal</local-home>
com.aonix.WebData.request.WDRequestRQEntityRemote
com.aonix.WebData.request.WDRequestRQEntityLocal
<ejb-class>com.aonix.WebData.request.WDRequestRQEntityBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.Long</prim-key-class>
false
<abstract-schema-name>WDRequestRQEntity</abstract-schema-name>
<cmp-field>
<field-name>id</field-name>
</cmp-field>
<cmp-field>
<field-name>name</field-name>
</cmp-field>
<cmp-field>
<field-name>owner</field-name>
</cmp-field>
<cmp-field>
<field-name>logId</field-name>
</cmp-field>
<cmp-field>
<field-name>systemPreProcessingStages</field-name>
</cmp-field>
<cmp-field>
<field-name>userPreProcessingStages</field-name>
</cmp-field>
<cmp-field>
<field-name>userNormalStages</field-name>
</cmp-field>
<cmp-field>
<field-name>systemPostProcessingStages</field-name>
</cmp-field>
<cmp-field>
<field-name>userPostProcessingStages</field-name>
</cmp-field>
<cmp-field>
<field-name>systemNotificationTargets</field-name>
</cmp-field>
<cmp-field>
<field-name>userNotificationTargets</field-name>
</cmp-field>
<cmp-field>
<field-name>userNotificationTargets</field-name>
</cmp-field>
<cmp-field>
<field-name>stageGroups</field-name>
</cmp-field>
<cmp-field>
<field-name>activeStages</field-name>
</cmp-field>
<cmp-field>
<field-name>suspendedStages</field-name>
</cmp-field>
<cmp-field>
<field-name>outputs</field-name>
</cmp-field>
<cmp-field>
<field-name>principalInfo</field-name>
</cmp-field>
<cmp-field>
<field-name>debugEntry</field-name>
</cmp-field>
<cmp-field>
<field-name>dispatchRequired</field-name>
</cmp-field>
<cmp-field>
<field-name>requestFailed</field-name>
</cmp-field>
<primkey-field>id</primkey-field>
<ejb-local-ref>
<ejb-ref-name>ejb/WDLogSessionHome</ejb-ref-name>
<ejb-ref-type>Session</ejb-ref-type>
<local-home>com.aonix.WebData.log.WDLogSessionHomeLocal</local-home>
com.aonix.WebData.log.WDLogSessionLocal
<ejb-link>WDLogSessionBean</ejb-link>
</ejb-local-ref>
<security-identity>
<use-caller-identity/>
</security-identity>
I can supply the EAR if needed.