3 Replies Latest reply on Jun 3, 2004 3:58 AM by Tom Vekemans

    Relationship (post-table-create)

    Houyoux Olivier Newbie

      Hi,

      I am using JBoss 3.2.3 with MySQL 4.0.17 and encountering issues populating the database with default values with CMP beans.

      The app. consists of a one-to-many relationship between the role bean and the user bean.

      jbosscmp-jdbc.xml

      <?xml version="1.0" encoding="UTF-8"?>
      
      <!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd">
      
      <jbosscmp-jdbc>
       <defaults>
       <datasource>java:/DefaultDS</datasource>
       <datasource-mapping>mySQL</datasource-mapping>
       <create-table>true</create-table>
       <remove-table>false</remove-table>
       <pk-constraint>true</pk-constraint>
       <preferred-relation-mapping>relation-table</preferred-relation-mapping>
       </defaults>
       <enterprise-beans>
       <entity>
       <ejb-name>User</ejb-name>
       <post-table-create>
       <sql-statement>insert into user (email, password) values ('someone@polygone.be', 'test');</sql-statement>
       </post-table-create>
       <table-name>User</table-name>
       <cmp-field>
       <field-name>email</field-name>
       <column-name>email</column-name>
       </cmp-field>
       <cmp-field>
       <field-name>password</field-name>
       <column-name>password</column-name>
       </cmp-field>
       </entity>
       <entity>
       <ejb-name>Role</ejb-name>
       <post-table-create>
       <sql-statement>insert into role (name) values ('admin');</sql-statement>
       </post-table-create>
       <table-name>Role</table-name>
       <cmp-field>
       <field-name>name</field-name>
       <column-name>name</column-name>
       </cmp-field>
       </entity>
       </enterprise-beans>
      
       <relationships>
       <ejb-relation>
       <ejb-relation-name>User-Role</ejb-relation-name>
       <relation-table-mapping>
       <table-name>user_roles</table-name>
       <create-table>true</create-table>
       <remove-table>false</remove-table>
       <post-table-create>
       <sql-statement>insert into user_roles (user, role) values ('someone@polygone.be', 'admin');</sql-statement>
       </post-table-create>
       <pk-constraint>true</pk-constraint>
       </relation-table-mapping>
       </ejb-relation>
       </relationships>
      </jbosscmp-jdbc>
      


      Default value insertion works well for both beans but fails for the relation
      I got an SQLException : Duplicate entry 'someone@polygone.be' for key 1"

      When I read the server.log file, I see that a wrong sql statement is chosen :

      issuePostCreateSQL::sql: [insert into user (email, password) values ('someone@polygone.be', 'test');] on table User
      issuePostCreateSQL::sql: [insert into role (name, description) values ('admin', 'Administrator');] on table Role
      issuePostCreateSQL::sql: [insert into user (email, password) values ('someone@polygone.be', 'test');] on table user_roles

      Why does the server choose the sql statement defined for the User bean (insert into user (email, password) values ('someone@polygone.be', 'test')) instead the statement defined for the relationship (insert into user_roles (user, role) values ('someone@polygone.be', 'admin')) ?
      In that situation, it's normal that I got this SQLException because the info has already been inserted in the user table.

      Is there something wrong with my configuration files ?
      How can I fix it ?

      Thanks,
      Olivier

      Here are my descriptors and stack trace when I start the server for the first time

      ejb-jar.xml
      <?xml version="1.0" encoding="UTF-8"?>
      
      <!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN' 'http://java.sun.com/dtd/ejb-jar_2_0.dtd'>
      
      <ejb-jar>
      
       <enterprise-beans>
       <entity>
       <ejb-name>User</ejb-name>
       <local-home>com.polygone.security.auth.ejb.user.LocalUserHome</local-home>
       <local>com.polygone.security.auth.ejb.user.LocalUser</local>
       <ejb-class>com.polygone.security.auth.ejb.user.UserBean</ejb-class>
       <persistence-type>Container</persistence-type>
       <prim-key-class>java.lang.String</prim-key-class>
       <reentrant>True</reentrant>
       <cmp-version>2.x</cmp-version>
       <abstract-schema-name>User</abstract-schema-name>
       <cmp-field><field-name>email</field-name></cmp-field>
       <cmp-field><field-name>password</field-name></cmp-field>
       <primkey-field>email</primkey-field>
       <query>
       <description>method to find the authenticated users</description>
       <query-method>
       <method-name>findAll</method-name>
       <method-params/>
       </query-method>
       <result-type-mapping>Local</result-type-mapping>
       <ejb-ql><![CDATA[select object (user) from User user]]></ejb-ql>
       </query>
       </entity>
       <entity>
       <ejb-name>Role</ejb-name>
       <local-home>com.polygone.security.auth.ejb.role.LocalRoleHome</local-home>
       <local>com.polygone.security.auth.ejb.role.LocalRole</local>
       <ejb-class>com.polygone.security.auth.ejb.role.RoleBean</ejb-class>
       <persistence-type>Container</persistence-type>
       <prim-key-class>java.lang.String</prim-key-class>
       <reentrant>True</reentrant>
       <cmp-version>2.x</cmp-version>
       <abstract-schema-name>Role</abstract-schema-name>
       <cmp-field><field-name>name</field-name></cmp-field>
       <primkey-field>name</primkey-field>
       <query>
       <description>method to find the roles</description>
       <query-method>
       <method-name>findAll</method-name>
       <method-params/>
       </query-method>
       <result-type-mapping>Local</result-type-mapping>
       <ejb-ql><![CDATA[select object (role) from Role role]]></ejb-ql>
       </query>
       </entity>
       <session>
       <ejb-name>Manager</ejb-name>
       <home>com.polygone.security.auth.ejb.manager.ManagerHome</home>
       <remote>com.polygone.security.auth.ejb.manager.Manager</remote>
       <ejb-class>com.polygone.security.auth.ejb.manager.ManagerBean</ejb-class>
       <session-type>Stateless</session-type>
       <transaction-type>Container</transaction-type>
       <ejb-local-ref>
       <ejb-ref-name>User</ejb-ref-name>
       <ejb-ref-type>Entity</ejb-ref-type>
       <local-home>com.polygone.security.auth.ejb.user.LocalUserHome</local-home>
       <local>com.polygone.security.auth.ejb.user.LocalUser</local>
       <ejb-link>User</ejb-link>
       </ejb-local-ref>
       <ejb-local-ref>
       <ejb-ref-name>Role</ejb-ref-name>
       <ejb-ref-type>Entity</ejb-ref-type>
       <local-home>com.polygone.security.auth.ejb.role.LocalRoleHome</local-home>
       <local>com.polygone.security.auth.ejb.role.LocalRole</local>
       <ejb-link>User</ejb-link>
       </ejb-local-ref>
       </session>
       </enterprise-beans>
      
       <relationships>
       <ejb-relation>
       <ejb-relation-name>User-Role</ejb-relation-name>
      
       <ejb-relationship-role>
       <ejb-relationship-role-name>user-has-roles</ejb-relationship-role-name>
       <multiplicity>Many</multiplicity>
       <relationship-role-source>
       <ejb-name>User</ejb-name>
       </relationship-role-source>
       <cmr-field>
       <cmr-field-name>roles</cmr-field-name>
       <cmr-field-type>java.util.Collection</cmr-field-type>
       </cmr-field>
       </ejb-relationship-role>
      
       <ejb-relationship-role>
       <ejb-relationship-role-name>role-has-users</ejb-relationship-role-name>
       <multiplicity>Many</multiplicity>
       <relationship-role-source>
       <ejb-name>Role</ejb-name>
       </relationship-role-source>
       </ejb-relationship-role>
       </ejb-relation>
       </relationships>
      
       <assembly-descriptor>
       <container-transaction>
       <method>
       <ejb-name>User</ejb-name>
       <method-name>*</method-name>
       </method>
       <trans-attribute>Required</trans-attribute>
       </container-transaction>
       <container-transaction>
       <method>
       <ejb-name>Role</ejb-name>
       <method-name>*</method-name>
       </method>
       <trans-attribute>Required</trans-attribute>
       </container-transaction>
       <container-transaction>
       <method>
       <ejb-name>Manager</ejb-name>
       <method-name>*</method-name>
       </method>
       <trans-attribute>Required</trans-attribute>
       </container-transaction>
       </assembly-descriptor>
      
      </ejb-jar>
      


      jboss.xml
      <?xml version="1.0" encoding="UTF-8"?>
      
      <!DOCTYPE jboss PUBLIC "-//JBoss//DTD JBOSS 3.2//EN" "http://www.jboss.org/j2ee/dtd/jboss_3_2.dtd">
      
      <jboss>
       <enterprise-beans>
       <entity>
       <ejb-name>User</ejb-name>
       <local-jndi-name>ejb/User</local-jndi-name>
       <configuration-name>Standard CMP 2.x EntityBean</configuration-name>
       <clustered>false</clustered>
       </entity>
       <entity>
       <ejb-name>Role</ejb-name>
       <local-jndi-name>ejb/Role</local-jndi-name>
       <configuration-name>Standard CMP 2.x EntityBean</configuration-name>
       <clustered>false</clustered>
       </entity>
       <session>
       <ejb-name>Manager</ejb-name>
       <jndi-name>ejb/Manager</jndi-name>
       <configuration-name>Standard Stateless SessionBean</configuration-name>
       <clustered>false</clustered>
       </session>
       </enterprise-beans>
      </jboss>
      


      server.log
      2004-06-03 07:47:52,853 INFO [org.jboss.management.j2ee.LocalJBossServerDomain] Started jboss.management.local:j2eeType=J2EEDomain,name=Manager
      2004-06-03 07:47:52,853 INFO [org.jboss.logging.Log4jService] Started jboss.system:type=Log4jService,service=Logging
      2004-06-03 07:47:52,973 INFO [org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread] Running
      2004-06-03 07:47:52,973 INFO [org.jboss.web.WebService] Started WebServer with address: 0.0.0.0:8083
      2004-06-03 07:47:53,254 INFO [org.jboss.web.WebService] Using RMI server codebase: http://Tokyo:8083/
      2004-06-03 07:47:53,254 INFO [org.jboss.web.WebService] Started jboss:service=WebService
      2004-06-03 07:47:53,254 INFO [org.jboss.naming.NamingService] Starting jnp server
      2004-06-03 07:47:53,444 INFO [org.jboss.naming.NamingService] Started jnpPort=1099, rmiPort=1098, backlog=50, bindAddress=/0.0.0.0, Client SocketFactory=null, Server SocketFactory=org.jboss.net.sockets.DefaultSocketFactory@ad093076
      2004-06-03 07:47:53,454 INFO [org.jboss.naming.NamingService] Listening on port 1099
      2004-06-03 07:47:53,464 INFO [org.jboss.naming.NamingService] Started jboss:service=Naming
      2004-06-03 07:47:53,464 INFO [org.jboss.naming.JNDIView] Started jboss:service=JNDIView
      2004-06-03 07:47:53,464 INFO [org.jboss.security.plugins.SecurityConfig] Started jboss.security:service=SecurityConfig
      2004-06-03 07:47:53,514 INFO [org.jboss.security.auth.login.XMLLoginConfig] Started jboss.security:service=XMLLoginConfig
      2004-06-03 07:47:53,524 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Started jboss.security:service=JaasSecurityManager
      2004-06-03 07:47:53,714 INFO [org.jboss.tm.TransactionManagerService] Started jboss:service=TransactionManager
      2004-06-03 07:47:53,774 INFO [org.jboss.invocation.jrmp.server.JRMPInvoker] Started jboss:service=invoker,type=jrmp
      2004-06-03 07:47:53,875 INFO [org.jboss.invocation.jrmp.server.JRMPProxyFactory] Started jboss:service=proxyFactory,target=ClientUserTransactionFactory
      2004-06-03 07:47:53,885 INFO [org.jboss.invocation.jrmp.server.JRMPProxyFactory] Started jboss:service=proxyFactory,target=ClientUserTransaction
      2004-06-03 07:47:53,895 INFO [org.jboss.tm.usertx.server.ClientUserTransactionService] Started jboss:service=ClientUserTransaction
      2004-06-03 07:47:53,905 INFO [org.jboss.invocation.local.LocalInvoker] Started jboss:service=invoker,type=local
      2004-06-03 07:47:53,965 INFO [org.jboss.invocation.pooled.server.PooledInvoker] Started jboss:service=invoker,type=pooled
      2004-06-03 07:47:53,975 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.ejb.EJBDeployer@18c3679
      2004-06-03 07:47:53,975 INFO [org.jboss.ejb.EJBDeployer] Started jboss.ejb:service=EJBDeployer
      2004-06-03 07:47:53,975 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.deployment.EARDeployer@6779e6
      2004-06-03 07:47:53,975 INFO [org.jboss.deployment.EARDeployer] Started jboss.j2ee:service=EARDeployer
      2004-06-03 07:47:53,985 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.varia.deployment.BeanShellSubDeployer@659db7
      2004-06-03 07:47:53,985 INFO [org.jboss.varia.deployment.BeanShellSubDeployer] Started jboss.scripts:service=BSHDeployer
      2004-06-03 07:47:54,115 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/ant.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/bootstrap.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/catalina.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/commons-beanutils.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/commons-collections.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/commons-digester.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/commons-logging.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/jakarta-regexp-1.3.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/jasper-compiler.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/jasper-runtime.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/naming-common.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/naming-resources.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/servlets-common.jar
      2004-06-03 07:47:54,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/servlets-default.jar
      2004-06-03 07:47:54,245 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/servlets-invoker.jar
      2004-06-03 07:47:54,245 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/servlets-webdav.jar
      2004-06-03 07:47:54,245 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/tomcat-coyote.jar
      2004-06-03 07:47:54,245 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/tomcat-http11.jar
      2004-06-03 07:47:54,245 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/tomcat-jk2.jar
      2004-06-03 07:47:54,245 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/tomcat-util.jar
      2004-06-03 07:47:54,245 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/tomcat41-service.jar
      2004-06-03 07:47:56,228 INFO [STDOUT] Apache Tomcat/4.1.29
      2004-06-03 07:47:56,318 INFO [org.apache.coyote.http11.Http11Protocol] Initialisation de Coyote HTTP/1.1 sur le port 80
      2004-06-03 07:47:56,318 INFO [org.jboss.web.localhost.Engine] CoyoteConnector Coyote can't register jmx for protocol
      2004-06-03 07:47:56,328 INFO [org.apache.coyote.http11.Http11Protocol] Démarrage de Coyote HTTP/1.1 sur le port 80
      2004-06-03 07:47:56,328 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] OK
      2004-06-03 07:47:56,328 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.web.tomcat.tc4.EmbeddedTomcatService@1c8ef56
      2004-06-03 07:47:56,328 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Started jboss.web:service=WebServer
      2004-06-03 07:47:56,538 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/Projects/polygone/jboss/server/test/deploy/jbossweb-tomcat41.sar/
      2004-06-03 07:47:56,538 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/C:/Projects/polygone/jboss/server/test/deploy/jboss-jca.sar
      2004-06-03 07:47:56,999 INFO [org.jboss.deployment.XSLSubDeployer] Created templates: org.apache.xalan.templates.StylesheetRoot@1db484d
      2004-06-03 07:47:56,999 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.resource.RARDeployer@167d7fb
      2004-06-03 07:47:56,999 INFO [org.jboss.resource.RARDeployer] Started jboss.jca:service=RARDeployer
      2004-06-03 07:47:57,119 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.deployment.XSLSubDeployer@118278a
      2004-06-03 07:47:57,119 INFO [org.jboss.deployment.XSLSubDeployer] Started jboss.jca:service=ConnectionFactoryDeployer
      2004-06-03 07:47:57,119 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/Projects/polygone/jboss/server/test/deploy/jboss-jca.sar
      2004-06-03 07:47:57,119 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/C:/Projects/polygone/jboss/server/test/deploy/jboss-local-jdbc.rar
      2004-06-03 07:47:57,420 INFO [org.jboss.resource.RARDeployer] nested deployment: file:/C:/Projects/polygone/jboss/server/test/tmp/deploy/tmp57329jboss-local-jdbc.rar-contents/jboss-local-jdbc.jar
      2004-06-03 07:47:57,450 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/Projects/polygone/jboss/server/test/deploy/jboss-local-jdbc.rar
      2004-06-03 07:47:57,450 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/C:/Projects/polygone/jboss/server/test/deploy/mysql-ds.xml
      2004-06-03 07:47:57,760 INFO [org.jboss.resource.connectionmanager.RARDeployment] Started jboss.jca:service=ManagedConnectionFactory,name=DefaultDS
      2004-06-03 07:47:57,890 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Started jboss.jca:service=ManagedConnectionPool,name=DefaultDS
      2004-06-03 07:47:57,910 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/Projects/polygone/jboss/server/test/deploy/mysql-ds.xml
      2004-06-03 07:47:57,910 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/C:/Projects/polygone/jboss/server/test/deploy/sqlexception-service.xml
      2004-06-03 07:47:58,021 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/Projects/polygone/jboss/server/test/deploy/sqlexception-service.xml
      2004-06-03 07:47:58,021 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/C:/Projects/polygone/jboss/server/test/deploy/transaction-service.xml
      2004-06-03 07:47:58,051 INFO [org.jboss.resource.connectionmanager.CachedConnectionManager] Started jboss.jca:service=CachedConnectionManager
      2004-06-03 07:47:58,061 INFO [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.DefaultDS] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=LocalTxCM,name=DefaultDS to JNDI name 'java:/DefaultDS'
      2004-06-03 07:47:58,061 INFO [org.jboss.resource.connectionmanager.TxConnectionManager] Started jboss.jca:service=LocalTxCM,name=DefaultDS
      2004-06-03 07:47:58,071 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/Projects/polygone/jboss/server/test/deploy/transaction-service.xml
      2004-06-03 07:47:58,071 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/C:/Projects/polygone/jboss/server/test/deploy/test.ear
      2004-06-03 07:47:58,141 INFO [org.jboss.deployment.EARDeployer] Init J2EE application: file:/C:/Projects/polygone/jboss/server/test/deploy/test.ear
      2004-06-03 07:47:59,503 INFO [org.jboss.ejb.EjbModule] Deploying User
      2004-06-03 07:47:59,513 INFO [org.jboss.ejb.EjbModule] Deploying Role
      2004-06-03 07:47:59,543 INFO [org.jboss.ejb.EjbModule] Deploying Manager
      2004-06-03 07:48:00,764 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.User] Initializing CMP plugin for User
      2004-06-03 07:48:00,774 INFO [org.jboss.ejb.plugins.EntityInstancePool] Started jboss.j2ee:jndiName=ejb/User,plugin=pool,service=EJB
      2004-06-03 07:48:00,774 INFO [org.jboss.ejb.EntityContainer] Started jboss.j2ee:jndiName=ejb/User,service=EJB
      2004-06-03 07:48:00,774 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Role] Initializing CMP plugin for Role
      2004-06-03 07:48:01,205 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.User] Insert Entity SQL: INSERT INTO User (email, password) VALUES (?, ?)
      2004-06-03 07:48:01,205 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.User] Entity Exists SQL: SELECT COUNT(*) FROM User WHERE email=?
      2004-06-03 07:48:01,205 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.User] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
      2004-06-03 07:48:01,215 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.User] Remove SQL: DELETE FROM User WHERE email=?
      2004-06-03 07:48:01,235 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.User] Executing SQL: CREATE TABLE User (email VARCHAR(250) BINARY NOT NULL, password VARCHAR(250) BINARY, CONSTRAINT pk_User PRIMARY KEY (email))
      2004-06-03 07:48:01,305 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.User] Created table 'User' successfully.
      2004-06-03 07:48:01,305 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.User] issuePostCreateSQL::sql: [insert into user (email, password) values ('someone@polygone.be', 'test');] on table User
      2004-06-03 07:48:01,305 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.User] Executing SQL: insert into user (email, password) values ('someone@polygone.be', 'test');
      2004-06-03 07:48:01,305 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.User] Issued SQL [insert into user (email, password) values ('someone@polygone.be', 'test');] successfully.
      2004-06-03 07:48:01,315 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.User#findByPrimaryKey] SQL: SELECT email FROM User WHERE email=?
      2004-06-03 07:48:01,325 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.User] Added findByPrimaryKey query command for local home interface
      2004-06-03 07:48:01,325 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.User#findAll] EJB-QL: select object (user) from User user
      2004-06-03 07:48:01,405 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.User#findAll] SQL: SELECT t0_user.email FROM User t0_user
      2004-06-03 07:48:01,756 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Role] Insert Entity SQL: INSERT INTO Role (name, description) VALUES (?, ?)
      2004-06-03 07:48:01,756 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Role] Entity Exists SQL: SELECT COUNT(*) FROM Role WHERE name=?
      2004-06-03 07:48:01,756 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.Role] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
      2004-06-03 07:48:01,756 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.Role] Remove SQL: DELETE FROM Role WHERE name=?
      2004-06-03 07:48:01,756 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] Executing SQL: CREATE TABLE Role (name VARCHAR(250) BINARY NOT NULL, description VARCHAR(250) BINARY, CONSTRAINT pk_Role PRIMARY KEY (name))
      2004-06-03 07:48:01,826 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] Created table 'Role' successfully.
      2004-06-03 07:48:01,826 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] issuePostCreateSQL::sql: [insert into role (name, description) values ('admin', 'Administrator');] on table Role
      2004-06-03 07:48:01,826 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] Executing SQL: insert into role (name, description) values ('admin', 'Forum administrator');
      2004-06-03 07:48:01,826 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] Issued SQL [insert into role (name, description) values ('admin', 'Forum administrator');] successfully.
      2004-06-03 07:48:01,826 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] Executing SQL: CREATE TABLE user_roles (Role VARCHAR(250) BINARY NOT NULL, User VARCHAR(250) BINARY NOT NULL, CONSTRAINT pk_user_roles PRIMARY KEY (Role, User))
      2004-06-03 07:48:01,876 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] Created table 'user_roles' successfully.
      2004-06-03 07:48:01,876 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] issuePostCreateSQL::sql: [insert into user (email, password) values ('someone@polygone.be', 'test');] on table user_roles
      2004-06-03 07:48:01,876 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] Executing SQL: insert into user (email, password) values ('someone@polygone.be', 'test');
      2004-06-03 07:48:01,876 WARN [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Role] Issuing sql insert into user (email, password) values ('someone@polygone.be', 'test'); failed: java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry 'someone@polygone.be' for key 1"
      2004-06-03 07:48:01,906 ERROR [org.jboss.ejb.EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException: Error while issuing sql in post-table-create; - nested throwable: (java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry 'someone@polygone.be' for key 1")
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.issuePostCreateSQL(JDBCStartCommand.java:392)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:154)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
       at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
       at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
       at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
       at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
       at $Proxy14.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:394)
       at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
       at $Proxy21.start(Unknown Source)