4 Replies Latest reply on Jun 9, 2004 8:35 AM by sys user

    Deploy order

    sys user Master

      There is my problem :
      I deploy a module (module 1) which need a .class in another module (module 2). However when I start JBoss my module 1 is deploied before the other.
      How can I do to deploy module 2 before module 1.

      Thanks for your help...

        • 1. Relationship (post-table-create)
          sys user Master

          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)
          


          • 2. Re: Deploy order
            Viet Master

            how are your 2 modules packaged : 2 sars in the same directory ?

            • 3. Re: Deploy order
              sys user Master

              I have mytheme.sar and mymodule.sar in the JBOSS_HOME/server/default/nukes.
              And I want deploy mytheme.sar before mymodule.sar...

              • 4. Re: Deploy order
                jae Master

                provided "mymodule.sar" does not rely upon any classes in "mytheme.sar", then you can use a depends tag in the "mymodule.sar" jboss-service.xml for the "mytheme.sar" (look at the nukes core jboss-service.xml to see how this is done).

                if "mymodule.sar" does rely upon a class in "mytheme.sar" (this issue currently exists in the downloads module w/ the *-service.xml files for the blocks), you can create a "nukes.last" directory inside the "nukes" directory and then place "mytheme.sar" in the nukes directory and "mymodule.sar" in the nukes.last directory.

                all modules in the "nukes" directory will be deployed before those in the "nukes.last" directory.