1 Reply Latest reply on May 16, 2003 6:39 AM by Frank Griffin

    SQL Error in 3.2.1, worked in 3.0.4

    Frank Griffin Novice

      If 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.