3 Replies Latest reply on Feb 12, 2005 11:50 AM by triathlon98

    add new column to a CMP in jboss 3.2.5

    caesarkim

      i added a new field to one of my CMPs to create a new column. I am using Jboss 3.2.5 and Mysql 4. This is my jbosscmp-jdbc.xml

      java:/jdbc/MySQLDS
      <datasource-mapping>mySQL</datasource-mapping>
      <create-table>true</create-table>
      <alter-table>true</alter-table>
      <remove-table>false</remove-table>

      The following is the columns from ejb-jar.xml

      <cmp-field><field-name>id</field-name></cmp-field>
      <cmp-field><field-name>developerId</field-name></cmp-field>
      <cmp-field><field-name>subProjectId</field-name></cmp-field>
      <cmp-field><field-name>readMode</field-name></cmp-field>
      <cmp-field><field-name>editMode</field-name></cmp-field>
      <cmp-field><field-name>removeMode</field-name></cmp-field>
      <cmp-field><field-name>exportMode</field-name></cmp-field>
      <cmp-field><field-name>writeMode</field-name></cmp-field>
      <cmp-field><field-name>uploadMode</field-name></cmp-field>
      <cmp-field><field-name>createDate</field-name></cmp-field>
      <cmp-field><field-name>lastChange</field-name></cmp-field>


      uploadMode is the new column. even though i redeploy EAR file, it doesn't update a table(add a new column). is there anything else that I have to look into?

      Thanks..