2 Replies Latest reply on Jul 21, 2003 12:18 PM by viz

    MySQL missing auto_increment modifier

    nathanielstoddard Newbie

      Hi folks -- I'm having a problem getting JBoss 3.2.1 to properly generate my MySQL tables on deploy. I have the thing all working to increment my primary key for a table, but JBoss kindly neglects to add the "auto_increment" modifer to the field when it creates it. (Everything else is generated properly).

      Once I go in and change the column manually to auto_increment, everything works just fine. I'd just rather not have to do that every single time. I'm not sure what the problem could be. The MySQL mapping in standardjbosscmp-jdbc.xml has the correct auto-increment-mapping. I've also setup my other xml files just fine as far as I know and my datasource is running as expected. (Like I said, everything works fine once I manually change it to auto_increment).

      It's just the deployment parts that is screwing up. Can anybody help? Much thanks.