[jboss-jira] [JBoss JIRA] (AS7-2538) The jboss-javaee6-ear-webapp Maven archetype generates a project that can cause a database duplicate key conflict

[Sande Gilda (Created) (JIRA)]

The jboss-javaee6-ear-webapp Maven archetype generates a project that can cause a database duplicate key conflict
-----------------------------------------------------------------------------------------------------------------

                 Key: AS7-2538
                 URL: https://issues.jboss.org/browse/AS7-2538
             Project: Application Server 7
          Issue Type: Bug
          Components: Build System, Documentation
            Reporter: Sande Gilda
            Assignee: Pete Muir


I created the the kitchensink-ear project using the jboss-javaee6-ear-webapp archetype.
I built and deployed the application to a server where the kitchensink quickstart was already deployed.
When I restarted my server, I got a JdbcSQLException:
    org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: 
          "PRIMARY_KEY_8 ON PUBLIC.MEMBER(ID)"; SQL statement:
    insert into Member (id, name, email, phone_number) values (0, 'John Smith', 
            'john.smith at mailinator.com', '2125551212')
Unfortunately there is no way to know if the kitchensink is also deployed to the server so it is easy to run into a conflict with the 'id' column.

We need to make the following 2 changes to the archetype:

1. We need to rename the table to avoid conflict. I checked in kitchensink-ear with the table renamed to "Registrant". This required renaming 5 files and changing all "member" references to "registrant". This can be found here: https://github.com/sgilda/quickstart

2. We also need to change the index.xhtml message to say "You have successfully deployed a Java EE 6 Enterprise application on JBoss AS 7". This uses the EAR archetype so it is an Enterprise application and not just a web application.



--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira