1 2 Previous Next 15 Replies Latest reply on May 14, 2004 2:44 AM by juha

    SQL error while JBoss try to create the table in my database

    amalsekro

      Well, actually I'm trying to have a 1-M bidirectionnal relation between 2 entities, and while they pass EJB tests, there is a SQL error at the deployment when jboss should create the tables.
      BTW, I'm using XDoclet.


      CustomerBean

      package org.jstock.ejb;
      
      import java.rmi.RemoteException;
      import javax.ejb.EJBException;
      import javax.ejb.RemoveException;
      import javax.ejb.CreateException;
      
      import javax.ejb.EntityBean;
      import javax.ejb.EntityContext;
      
      import org.jstock.interfaces.CommandTypeLocal;
      
      /**
       * @author ggratacap
       *
       * @ejb.bean name = "Command"
       * display-name = "Command EJB"
       * description = "EJB for Command entity"
       * view-type = "both"
       * jndi-name = "Command"
       * type = "CMP"
       * primkey-field = "id"
       * cmp-version = "2.x"
       *
       * @jboss.cmp-field field-name = "id"
       */
      public abstract class CommandBean implements EntityBean {
      
       /*
       ***********************************************************************************
       * CREATORS
       ***********************************************************************************
       */
      
       /**
       *
       * @param Integer id
       * @return Integer
       *
       * @ejb.create-method
       *
       */
       public Integer ejbCreate(Integer id)
       throws CreateException{
       this.setId(id);
       return null;
       }
       public void ejbPostCreate(Integer id){}
      
       /*
       ***********************************************************************************
       * PRIMARY KEYS
       ***********************************************************************************
       */
      
       /**
       * Retourne l'identifiant de "l'objet".
       *
       * @return Integer
       *
       * @ejb.pk-field
       * @ejb.persistence column-name = "ID_COMMAND"
       * jdbc-type = "INTEGER"
       */
       public abstract Integer getId();
      
       public abstract void setId(Integer id);
      
       /*
       ***********************************************************************************
       * COMMON METHODS
       ***********************************************************************************
       */
      
       /*
       ***********************************************************************************
       * RELATIONS
       ***********************************************************************************
       */
      
       /**
       *
       * @return CommandTypeLocal
       *
       * @ejb.persistence jdbc-type = "INTEGER"
       * column-name = "FK_COMMANDTYPE"
       *
       * @ejb.relation name = "CommandType-Command"
       * role-name = "Command_has_CommandType"
       *
       * @jboss.relation related-pk-field = "id"
       */
      
       public abstract CommandTypeLocal getHomeCommandType();
      
       public abstract void setHomeCommandType(CommandTypeLocal commandType);
       /*
       ...
      


      and CustomerType

      
      package org.jstock.ejb;
      
      import java.rmi.RemoteException;
      import javax.ejb.EJBException;
      import javax.ejb.RemoveException;
      import javax.ejb.CreateException;
      
      import javax.ejb.EntityBean;
      import javax.ejb.EntityContext;
      
      import java.util.Collection;
      
      /**
       * @author ggratacap
       *
       * @ejb.bean name = "CommandType"
       * display-name = "CommandType EJB"
       * description = "EJB for CommandType entity"
       * view-type = "both"
       * jndi-name = "CommandType"
       * type = "CMP"
       * primkey-field = "id"
       * cmp-version = "2.x"
       *
       * @jboss.cmp-field field-name = "id"
       */
      public abstract class CommandTypeBean implements EntityBean {
      
       /*
       ***********************************************************************************
       * CREATORS
       ***********************************************************************************
       */
      
       /**
       *
       * @param Integer id
       * @return Integer
       *
       * @ejb.create-method
       *
       */
       public Integer ejbCreate(Integer id)
       throws CreateException{
       this.setId(id);
       return null;
       }
       public void ejbPostCreate(Integer id){}
      
       /*
       ***********************************************************************************
       * PRIMARY KEYS
       ***********************************************************************************
       */
      
       /**
       * Retourne l'identifiant de "l'objet".
       *
       * @return Integer
       *
       * @ejb.pk-field
       * @ejb.persistence column-name = "ID_COMMANDTYPE"
       *
       */
       public abstract Integer getId();
      
       public abstract void setId(Integer id);
      
       /*
       ***********************************************************************************
       * COMMON METHODS
       ***********************************************************************************
       */
      
       /*
       ***********************************************************************************
       * RELATIONS
       ***********************************************************************************
       */
      
       /**
       *
       * @return Collection
       *
       * @ejb.relation name = "CommandType-Command"
       * role-name = "CommandType_to_Commands"
       *
       * @ejb.persistence
       *
       */
      
       public abstract Collection getCommands();
      
       public abstract void setCommands(Collection commands);
      


      If anyone can help...

        • 1. Re: 7.2 jbosscmp-jdbc.xml appears incomplete

          hi sacha iam from finland , can u give me ur email id so that we discuss abt the things , here is my id:
          jdsrinivaz@yahoo.com

          cheers

          JD

          • 2. Re: SQL error while JBoss try to create the table in my data
            amalsekro

            I forgot to put the error :

             Depends On Me: , ObjectName: jboss.j2ee:jndiName=Command,service=EJB
             state: FAILED
             I Depend On:
             Depends On Me: org.jboss.deployment.DeploymentException: Error while creating table Command; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER NOT NULL, FK_COMMANDTYPE VARBINARY, CONSTRAINT pk_Comma")]
            


            • 3. Re: SQL error while JBoss try to create the table in my data

              Post the errors from your server.log that occur when the EJB is being deployed, the SQL exception is not very revealing. Based on that, I'd venture a guess it is a problem with your primary key declaration.

              • 4. Re: SQL error while JBoss try to create the table in my data
                amalsekro

                Well, here it is :

                2004-05-14 09:22:20,265 INFO [org.jboss.ejb.EjbModule] Started jboss.j2ee:module=jstockEJB.jar,service=EjbModule
                2004-05-14 09:22:20,265 INFO [org.jboss.ejb.EJBDeployer] Deployed: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar
                2004-05-14 09:22:20,343 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar
                2004-05-14 09:22:20,343 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
                Cause: Incomplete Deployment listing:
                Packages waiting for a deployer:
                 <none>
                Incompletely deployed packages:
                 <none>
                MBeans waiting for classes:
                 <none>
                MBeans waiting for other MBeans:
                [ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=Invoker
                 jboss.web:service=WebServer
                
                 Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                 jboss.mq:service=SecurityManager
                
                 Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                 jboss.mq:service=SecurityManager
                
                 Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                 jboss.mq:service=SecurityManager
                
                 Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                 jboss.mq:service=SecurityManager
                
                 Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                
                 Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                
                 Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                
                 Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                
                 Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                
                 Depends On Me: , ObjectName: jboss.mq:service=Invoker
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=TracingInterceptor
                
                 Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
                 jboss.mq:service=InvocationLayer,type=JVM
                 jboss.mq:service=InvocationLayer,type=OIL
                 jboss.mq:service=InvocationLayer,type=OIL2
                 jboss.mq:service=InvocationLayer,type=RMI
                 jboss.mq:service=InvocationLayer,type=UIL2
                , ObjectName: jboss.mq:service=TracingInterceptor
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=SecurityManager
                
                 Depends On Me: jboss.mq:service=Invoker
                , ObjectName: jboss.mq:service=SecurityManager
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                
                 Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
                 jboss.mq.destination:service=Topic,name=securedTopic
                 jboss.mq.destination:service=Topic,name=testDurableTopic
                 jboss.mq.destination:service=Queue,name=testQueue
                 jboss.mq:service=TracingInterceptor
                 jboss.mq.destination:service=Queue,name=DLQ
                , ObjectName: jboss.mq.destination:service=Queue,name=DLQ
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=DestinationManager
                 jboss.mq:service=SecurityManager
                
                 Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=Invoker
                
                 Depends On Me: , ObjectName: jboss.mq:service=DestinationManager
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=MessageCache
                 jboss.mq:service=PersistenceManager
                 jboss.mq:service=StateManager
                
                 Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
                 jboss.mq.destination:service=Topic,name=securedTopic
                 jboss.mq.destination:service=Topic,name=testDurableTopic
                 jboss.mq.destination:service=Queue,name=testQueue
                 jboss.mq.destination:service=Queue,name=A
                 jboss.mq.destination:service=Queue,name=B
                 jboss.mq.destination:service=Queue,name=C
                 jboss.mq.destination:service=Queue,name=D
                 jboss.mq.destination:service=Queue,name=ex
                 jboss.mq:service=SecurityManager
                 jboss.mq.destination:service=Queue,name=DLQ
                , ObjectName: jboss.mq:service=PersistenceManager
                 state: CONFIGURED
                 I Depend On: jboss.jca:service=LocalTxCM,name=DefaultDS
                
                 Depends On Me: jboss.mq:service=DestinationManager
                , ObjectName: jboss.mq:service=InvocationLayer,type=OIL
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=Invoker
                
                 Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=Invoker
                
                 Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=Invoker
                
                 Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
                 state: CONFIGURED
                 I Depend On: jboss.mq:service=Invoker
                
                 Depends On Me: , ObjectName: jboss.j2ee:jndiName=Command,service=EJB
                 state: FAILED
                 I Depend On:
                 Depends On Me: org.jboss.deployment.DeploymentException: Error while creating table Command; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER NOT NULL, FK_COMMANDTYPE VARBINARY, CONSTRAINT pk_Comma")]
                


                • 5. Re: SQL error while JBoss try to create the table in my data

                  No, these are still the dependency errors, I want to see the errors before that, during the deployment.

                  • 6. Re: SQL error while JBoss try to create the table in my data
                    amalsekro

                    well, it is a bit agressive, but here is my whole server.log:

                    2004-05-14 09:10:12,921 INFO [org.jboss.management.j2ee.LocalJBossServerDomain] Started jboss.management.local:j2eeType=J2EEDomain,name=Manager
                    2004-05-14 09:10:12,921 INFO [org.jboss.logging.Log4jService] Started jboss.system:type=Log4jService,service=Logging
                    2004-05-14 09:10:12,937 INFO [org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread] Running
                    2004-05-14 09:10:12,968 INFO [org.jboss.web.WebService] Started WebServer with address: 0.0.0.0:8083
                    2004-05-14 09:10:12,984 INFO [org.jboss.web.WebService] Using RMI server codebase: http://leonardo:8083/
                    2004-05-14 09:10:12,984 INFO [org.jboss.web.WebService] Started jboss:service=WebService
                    2004-05-14 09:10:13,000 INFO [org.jboss.naming.NamingService] Starting jnp server
                    2004-05-14 09:10:13,671 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-05-14 09:10:13,750 INFO [org.jboss.naming.NamingService] Listening on port 1099
                    2004-05-14 09:10:13,765 INFO [org.jboss.naming.NamingService] Started jboss:service=Naming
                    2004-05-14 09:10:13,781 INFO [org.jboss.naming.JNDIView] Started jboss:service=JNDIView
                    2004-05-14 09:10:13,781 INFO [org.jboss.security.plugins.SecurityConfig] Started jboss.security:service=SecurityConfig
                    2004-05-14 09:10:13,937 INFO [org.jboss.security.auth.login.XMLLoginConfig] Started jboss.security:service=XMLLoginConfig
                    2004-05-14 09:10:13,968 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Started jboss.security:service=JaasSecurityManager
                    2004-05-14 09:10:14,046 INFO [org.jboss.tm.TransactionManagerService] Started jboss:service=TransactionManager
                    2004-05-14 09:10:14,156 INFO [org.jboss.invocation.jrmp.server.JRMPInvoker] Started jboss:service=invoker,type=jrmp
                    2004-05-14 09:10:14,281 INFO [org.jboss.invocation.jrmp.server.JRMPProxyFactory] Started jboss:service=proxyFactory,target=ClientUserTransactionFactory
                    2004-05-14 09:10:14,296 INFO [org.jboss.invocation.jrmp.server.JRMPProxyFactory] Started jboss:service=proxyFactory,target=ClientUserTransaction
                    2004-05-14 09:10:14,328 INFO [org.jboss.tm.usertx.server.ClientUserTransactionService] Started jboss:service=ClientUserTransaction
                    2004-05-14 09:10:14,328 INFO [org.jboss.invocation.local.LocalInvoker] Started jboss:service=invoker,type=local
                    2004-05-14 09:10:14,390 INFO [org.jboss.invocation.pooled.server.PooledInvoker] Started jboss:service=invoker,type=pooled
                    2004-05-14 09:10:14,421 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.ejb.EJBDeployer@cb07ef
                    2004-05-14 09:10:14,421 INFO [org.jboss.ejb.EJBDeployer] Started jboss.ejb:service=EJBDeployer
                    2004-05-14 09:10:14,437 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.deployment.EARDeployer@c272bc
                    2004-05-14 09:10:14,437 INFO [org.jboss.deployment.EARDeployer] Started jboss.j2ee:service=EARDeployer
                    2004-05-14 09:10:14,515 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.varia.deployment.BeanShellSubDeployer@1e940b
                    2004-05-14 09:10:14,515 INFO [org.jboss.varia.deployment.BeanShellSubDeployer] Started jboss.scripts:service=BSHDeployer
                    2004-05-14 09:10:14,593 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/
                    2004-05-14 09:10:14,640 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                    2004-05-14 09:10:14,671 INFO [org.jboss.deployment.MainDeployer] deployment waiting for deployer: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                    2004-05-14 09:10:14,921 INFO [org.jboss.invocation.http.server.HttpInvoker] Started jboss:service=invoker,type=http
                    2004-05-14 09:10:14,937 INFO [org.jboss.invocation.http.server.HttpInvokerHA] Started jboss:service=invoker,type=httpHA
                    2004-05-14 09:10:14,953 INFO [org.jboss.invocation.http.server.HttpProxyFactory] Started jboss:service=invoker,type=http,target=Naming
                    2004-05-14 09:10:14,953 INFO [org.jboss.invocation.http.server.HttpProxyFactory] Started jboss:service=invoker,type=http,target=Naming,readonly=true
                    2004-05-14 09:10:15,109 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/
                    2004-05-14 09:10:15,109 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-jca.sar
                    2004-05-14 09:10:16,562 INFO [org.jboss.deployment.XSLSubDeployer] Created templates: org.apache.xalan.templates.StylesheetRoot@11d2066
                    2004-05-14 09:10:16,578 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.resource.RARDeployer@13a1778
                    2004-05-14 09:10:16,578 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                    2004-05-14 09:10:16,578 INFO [org.jboss.deployment.MainDeployer] deployment waiting for deployer: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                    2004-05-14 09:10:16,578 INFO [org.jboss.deployment.MainDeployer] Deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/ is waiting for an appropriate deployer.
                    2004-05-14 09:10:16,578 INFO [org.jboss.resource.RARDeployer] Started jboss.jca:service=RARDeployer
                    2004-05-14 09:10:16,578 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.deployment.XSLSubDeployer@5e9db7
                    2004-05-14 09:10:16,578 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                    2004-05-14 09:10:16,578 INFO [org.jboss.deployment.MainDeployer] deployment waiting for deployer: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                    2004-05-14 09:10:16,578 INFO [org.jboss.deployment.MainDeployer] Deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/ is waiting for an appropriate deployer.
                    2004-05-14 09:10:16,578 INFO [org.jboss.deployment.XSLSubDeployer] Started jboss.jca:service=ConnectionFactoryDeployer
                    2004-05-14 09:10:16,625 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-jca.sar
                    2004-05-14 09:10:16,625 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/
                    2004-05-14 09:10:16,703 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/ant.jar
                    2004-05-14 09:10:16,703 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/bootstrap.jar
                    2004-05-14 09:10:16,703 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/catalina.jar
                    2004-05-14 09:10:16,703 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/commons-beanutils.jar
                    2004-05-14 09:10:16,703 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/commons-collections.jar
                    2004-05-14 09:10:16,718 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/commons-digester.jar
                    2004-05-14 09:10:16,718 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/commons-logging.jar
                    2004-05-14 09:10:16,718 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/jakarta-regexp-1.3.jar
                    2004-05-14 09:10:16,718 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/jasper-compiler.jar
                    2004-05-14 09:10:16,718 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/jasper-runtime.jar
                    2004-05-14 09:10:16,734 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/naming-common.jar
                    2004-05-14 09:10:16,750 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/naming-resources.jar
                    2004-05-14 09:10:16,750 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/servlets-common.jar
                    2004-05-14 09:10:16,750 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/servlets-default.jar
                    2004-05-14 09:10:16,750 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/servlets-invoker.jar
                    2004-05-14 09:10:16,750 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/servlets-webdav.jar
                    2004-05-14 09:10:16,750 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat-coyote.jar
                    2004-05-14 09:10:16,750 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat-http11.jar
                    2004-05-14 09:10:16,750 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat-jk2.jar
                    2004-05-14 09:10:16,765 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat-util.jar
                    2004-05-14 09:10:16,765 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat41-service.jar
                    2004-05-14 09:10:21,468 INFO [STDOUT] Apache Tomcat/4.1.29
                    2004-05-14 09:10:21,796 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut soLinger: -1
                    2004-05-14 09:10:21,796 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut soTimeout: 60000
                    2004-05-14 09:10:21,796 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut serverSoTimeout: 0
                    2004-05-14 09:10:21,796 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut tcpNoDelay: true
                    2004-05-14 09:10:21,812 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut jkHome: D:\Utilitaires\App-Server\jboss-3.2.3\server\default
                    2004-05-14 09:10:21,812 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut port: 8080
                    2004-05-14 09:10:21,812 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut maxThreads: 100
                    2004-05-14 09:10:21,812 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut backlog: 10
                    2004-05-14 09:10:21,812 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut tcpNoDelay: true
                    2004-05-14 09:10:21,812 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut soLinger: -1
                    2004-05-14 09:10:21,812 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut soTimeout: 20000
                    2004-05-14 09:10:21,812 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut timeout: 300000
                    2004-05-14 09:10:21,812 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut serverSoTimeout: 0
                    2004-05-14 09:10:21,828 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut maxKeepAliveRequests: 100
                    2004-05-14 09:10:21,828 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut tomcatAuthentication: true
                    2004-05-14 09:10:21,828 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut compression: off
                    2004-05-14 09:10:21,828 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut address: /0.0.0.0
                    2004-05-14 09:10:21,828 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut secure: false
                    2004-05-14 09:10:21,843 INFO [org.apache.coyote.http11.Http11Protocol] Initialisation de Coyote HTTP/1.1 sur le port 8080
                    2004-05-14 09:10:21,843 INFO [org.jboss.web.localhost.Engine] CoyoteConnector Coyote can't register jmx for protocol
                    2004-05-14 09:10:21,890 INFO [org.apache.coyote.http11.Http11Protocol] Démarrage de Coyote HTTP/1.1 sur le port 8080
                    2004-05-14 09:10:22,140 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty jkHome D:\Utilitaires\App-Server\jboss-3.2.3\server\default
                    2004-05-14 09:10:22,312 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty port 8009
                    2004-05-14 09:10:22,312 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty maxThreads 75
                    2004-05-14 09:10:22,343 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty backlog 10
                    2004-05-14 09:10:22,375 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty tcpNoDelay true
                    2004-05-14 09:10:22,375 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty soLinger -1
                    2004-05-14 09:10:22,375 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty soTimeout 20000
                    2004-05-14 09:10:22,375 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty timeout 300000
                    2004-05-14 09:10:22,375 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty serverSoTimeout 0
                    2004-05-14 09:10:22,390 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty disableUploadTimeout false
                    2004-05-14 09:10:22,390 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty maxKeepAliveRequests 100
                    2004-05-14 09:10:22,390 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty tomcatAuthentication true
                    2004-05-14 09:10:22,390 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty compression off
                    2004-05-14 09:10:22,390 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty address 0.0.0.0
                    2004-05-14 09:10:22,390 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty secure false
                    2004-05-14 09:10:22,421 DEBUG [org.apache.jk.server.JkMain] Starting Jk2, base dir= D:\Utilitaires\App-Server\jboss-3.2.3\server\default
                    2004-05-14 09:10:22,421 DEBUG [org.apache.jk.server.JkMain] No properties file found D:\Utilitaires\App-Server\jboss-3.2.3\server\default\conf\jk2.properties
                    2004-05-14 09:10:22,437 INFO [org.jboss.web.localhost.Engine] CoyoteConnector Coyote can't register jmx for protocol
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Substituting tomcatAuthentication request.tomcatAuthentication true
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Substituting soTimeout channelSocket.soTimeout 20000
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Substituting port channelSocket.port 8009
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Substituting maxThreads channelSocket.maxThreads 75
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Substituting backlog channelSocket.backlog 10
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Substituting timeout channelSocket.timeout 300000
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Substituting address channelSocket.address 0.0.0.0
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Substituting tcpNoDelay channelSocket.tcpNoDelay true
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket address
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Setting address on channelSocket org.apache.jk.common.ChannelSocket@ae1393
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@ae1393 address=0.0.0.0
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket soTimeout
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] Setting soTimeout on channelSocket org.apache.jk.common.ChannelSocket@ae1393
                    2004-05-14 09:10:22,500 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@ae1393 soTimeout=20000
                    2004-05-14 09:10:22,515 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket timeout
                    2004-05-14 09:10:22,515 DEBUG [org.apache.jk.server.JkMain] Setting timeout on channelSocket org.apache.jk.common.ChannelSocket@ae1393
                    2004-05-14 09:10:22,515 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@ae1393 timeout=300000
                    2004-05-14 09:10:22,515 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket maxThreads
                    2004-05-14 09:10:22,515 DEBUG [org.apache.jk.server.JkMain] Setting maxThreads on channelSocket org.apache.jk.common.ChannelSocket@ae1393
                    2004-05-14 09:10:22,531 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@ae1393 maxThreads=75
                    2004-05-14 09:10:22,531 DEBUG [org.apache.jk.common.ChannelSocket] Setting maxThreads 75
                    2004-05-14 09:10:22,531 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket backlog
                    2004-05-14 09:10:22,531 DEBUG [org.apache.jk.server.JkMain] Setting backlog on channelSocket org.apache.jk.common.ChannelSocket@ae1393
                    2004-05-14 09:10:22,531 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@ae1393 backlog=10
                    2004-05-14 09:10:22,531 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket tcpNoDelay
                    2004-05-14 09:10:22,546 DEBUG [org.apache.jk.server.JkMain] Setting tcpNoDelay on channelSocket org.apache.jk.common.ChannelSocket@ae1393
                    2004-05-14 09:10:22,546 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@ae1393 tcpNoDelay=true
                    2004-05-14 09:10:22,546 DEBUG [org.apache.jk.server.JkMain] Processing request::request tomcatAuthentication
                    2004-05-14 09:10:22,546 DEBUG [org.apache.jk.server.JkMain] Setting tomcatAuthentication on request org.apache.jk.common.HandlerRequest@1b044df
                    2004-05-14 09:10:22,546 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.HandlerRequest@1b044df tomcatAuthentication=true
                    2004-05-14 09:10:22,546 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket port
                    2004-05-14 09:10:22,546 DEBUG [org.apache.jk.server.JkMain] Setting port on channelSocket org.apache.jk.common.ChannelSocket@ae1393
                    2004-05-14 09:10:22,546 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@ae1393 port=8009
                    2004-05-14 09:10:22,546 DEBUG [org.apache.jk.common.HandlerRequest] Container handler org.apache.jk.server.JkCoyoteHandler@179c7cf container org.apache.jk.server.JkCoyoteHandler
                    2004-05-14 09:10:22,546 INFO [org.apache.jk.common.ChannelSocket] JK2: ajp13 listening on /0.0.0.0:8009
                    2004-05-14 09:10:22,578 INFO [org.apache.jk.server.JkMain] Jk running ID=0 time=0/141 config=null
                    2004-05-14 09:10:22,578 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] OK
                    2004-05-14 09:10:22,578 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.web.tomcat.tc4.EmbeddedTomcatService@c12978
                    2004-05-14 09:10:22,578 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                    2004-05-14 09:10:22,671 DEBUG [org.apache.tomcat.util.threads.ThreadPool] Getting new thread data
                    2004-05-14 09:10:22,671 DEBUG [org.apache.jk.common.ChannelSocket] Accepting ajp connections on 8009
                    2004-05-14 09:10:22,750 DEBUG [org.apache.tomcat.util.threads.ThreadPool] Getting new thread data
                    2004-05-14 09:10:22,906 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] deploy, ctxPath=/invoker, warUrl=file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                    2004-05-14 09:10:24,343 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/invoker]: Ajout de certificats -> requête Attribut de Valve (attribute Valve)
                    2004-05-14 09:10:24,468 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/invoker]: Configuration d'un authentificateur (authenticator) pour la méthode BASIC
                    2004-05-14 09:10:24,515 WARN [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Unable to invoke setDelegate on class loader:org.jboss.web.tomcat.tc4.WebCtxLoader$ENCLoader@1b94ea2
                    2004-05-14 09:10:24,515 INFO [org.jboss.web.localhost.Engine] StandardManager[/invoker]: Alimentation de la classe du générateur de nombre aléatoire java.security.SecureRandom
                    2004-05-14 09:10:24,921 INFO [org.jboss.web.localhost.Engine] StandardManager[/invoker]: L'alimentation du générateur de nombre aléatoire est terminé
                    2004-05-14 09:10:25,062 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/invoker:default]: Chargement du conteneur (container) de servlet default
                    2004-05-14 09:10:25,187 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/invoker:invoker]: Chargement du conteneur (container) de servlet invoker
                    2004-05-14 09:10:26,953 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                    2004-05-14 09:10:26,953 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Started jboss.web:service=WebServer
                    2004-05-14 09:10:26,968 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/
                    2004-05-14 09:10:26,968 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-httpil.sar/
                    2004-05-14 09:10:27,000 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
                    2004-05-14 09:10:27,312 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] deploy, ctxPath=/jbossmq-httpil, warUrl=file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
                    2004-05-14 09:10:27,781 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/jbossmq-httpil]: Ajout de certificats -> requête Attribut de Valve (attribute Valve)
                    2004-05-14 09:10:27,781 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/jbossmq-httpil]: Configuration d'un authentificateur (authenticator) pour la méthode BASIC
                    2004-05-14 09:10:27,812 WARN [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Unable to invoke setDelegate on class loader:org.jboss.web.tomcat.tc4.WebCtxLoader$ENCLoader@5f7d3f
                    2004-05-14 09:10:27,812 INFO [org.jboss.web.localhost.Engine] StandardManager[/jbossmq-httpil]: Alimentation de la classe du générateur de nombre aléatoire java.security.SecureRandom
                    2004-05-14 09:10:27,812 INFO [org.jboss.web.localhost.Engine] StandardManager[/jbossmq-httpil]: L'alimentation du générateur de nombre aléatoire est terminé
                    2004-05-14 09:10:27,812 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/jbossmq-httpil:default]: Chargement du conteneur (container) de servlet default
                    2004-05-14 09:10:27,828 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/jbossmq-httpil:invoker]: Chargement du conteneur (container) de servlet invoker
                    2004-05-14 09:10:28,390 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-httpil.sar/
                    2004-05-14 09:10:28,406 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-invoker-adaptor-server.sar/
                    2004-05-14 09:10:28,796 INFO [org.jboss.invocation.jrmp.server.JRMPProxyFactory] Started jboss.jmx:type=adaptor,name=Invoker,protocol=jrmp,service=proxyFactory
                    2004-05-14 09:10:28,796 INFO [org.jboss.naming.NamingAlias] Bound link jmx/rmi/RMIAdaptor to jmx/invoker/RMIAdaptor
                    2004-05-14 09:10:28,796 INFO [org.jboss.naming.NamingAlias] Started jboss.jmx:alias=jmx/rmi/RMIAdaptor
                    2004-05-14 09:10:28,828 INFO [org.jboss.jmx.connector.invoker.InvokerAdaptorService] Started jboss.jmx:type=adaptor,name=Invoker
                    2004-05-14 09:10:28,875 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-invoker-adaptor-server.sar/
                    2004-05-14 09:10:28,890 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/management/console-mgr.sar
                    2004-05-14 09:10:28,984 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp31325console-mgr.sar-contents/console-mgr-classes.jar
                    2004-05-14 09:10:29,015 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp31325console-mgr.sar-contents/jcommon.jar
                    2004-05-14 09:10:29,062 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp31325console-mgr.sar-contents/jfreechart-demo.jar
                    2004-05-14 09:10:29,125 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp31325console-mgr.sar-contents/jfreechart.jar
                    2004-05-14 09:10:29,921 INFO [org.jboss.console.manager.PluginManager] Started jboss.admin:service=PluginManager
                    2004-05-14 09:10:29,937 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/management/console-mgr.sar
                    2004-05-14 09:10:29,937 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/snmp-adaptor.sar/
                    2004-05-14 09:10:29,984 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/snmp-adaptor.sar/castor.jar
                    2004-05-14 09:10:30,828 INFO [org.jboss.jmx.adaptor.snmp.trapd.TrapdService] Started jboss.jmx:name=SnmpAgent,service=trapd,type=logger
                    2004-05-14 09:10:30,859 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Instantiating trap emitter ...
                    2004-05-14 09:10:30,906 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Starting trap emitter ...
                    2004-05-14 09:10:30,906 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapEmitter] Reading resource: "/managers.xml"
                    2004-05-14 09:10:31,703 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapEmitter] "/managers.xml" valid. Read 1 monitoring managers
                    2004-05-14 09:10:31,703 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapEmitter] Executing resource: "/managers.xml"
                    2004-05-14 09:10:31,921 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapFactorySupport] Reading resource: "/notifications.xml"
                    2004-05-14 09:10:32,015 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapFactorySupport] "/notifications.xml" valid. Read 2 mappings
                    2004-05-14 09:10:32,015 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapFactorySupport] Executing resource: "/notifications.xml"
                    2004-05-14 09:10:32,140 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapFactorySupport] Trap factory going active
                    2004-05-14 09:10:32,140 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Instantiating subscription manager ...
                    2004-05-14 09:10:32,140 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Starting subscription manager ...
                    2004-05-14 09:10:32,140 INFO [org.jboss.jmx.adaptor.snmp.agent.SubscriptionMgr] Reading resource: "/mbeans.xml"
                    2004-05-14 09:10:32,203 INFO [org.jboss.jmx.adaptor.snmp.agent.SubscriptionMgr] "/mbeans.xml" valid. Read 2 monitored objects
                    2004-05-14 09:10:32,203 INFO [org.jboss.jmx.adaptor.snmp.agent.SubscriptionMgr] Executing resource: "/mbeans.xml"
                    2004-05-14 09:10:32,218 INFO [org.jboss.jmx.adaptor.snmp.agent.SubscriptionMgr] Subscription manager done
                    2004-05-14 09:10:32,234 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Starting heartbeat controller ...
                    2004-05-14 09:10:32,234 WARN [org.jboss.jmx.adaptor.snmp.agent.Heartbeat] Heartbeat disabled
                    2004-05-14 09:10:32,359 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Snmp Agent going active
                    2004-05-14 09:10:32,359 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Started jboss.jmx:name=SnmpAgent,service=snmp,type=adaptor
                    2004-05-14 09:10:32,390 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/snmp-adaptor.sar/
                    2004-05-14 09:10:32,406 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/uuid-key-generator.sar
                    2004-05-14 09:10:32,859 INFO [org.jboss.ejb.plugins.keygenerator.uuid.UUIDKeyGeneratorFactoryService] Started jboss:service=UUIDKeyGeneratorFactory
                    2004-05-14 09:10:32,875 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/uuid-key-generator.sar
                    2004-05-14 09:10:32,875 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-local-jdbc.rar
                    2004-05-14 09:10:33,359 INFO [org.jboss.resource.RARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp31328jboss-local-jdbc.rar-contents/jboss-local-jdbc.jar
                    2004-05-14 09:10:33,453 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-local-jdbc.rar
                    2004-05-14 09:10:33,453 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-xa-jdbc.rar
                    2004-05-14 09:10:33,546 INFO [org.jboss.resource.RARMetaData] Loading JBoss Resource Adapter for JDBC 2 XA drivers
                    2004-05-14 09:10:33,546 INFO [org.jboss.resource.RARMetaData] Required license terms present. See deployment descriptor.
                    2004-05-14 09:10:33,562 INFO [org.jboss.resource.RARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp31329jboss-xa-jdbc.rar-contents/jboss-xa-jdbc.jar
                    2004-05-14 09:10:33,625 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-xa-jdbc.rar
                    2004-05-14 09:10:33,640 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jms-ra.rar
                    2004-05-14 09:10:33,750 INFO [org.jboss.resource.RARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp31330jms-ra.rar-contents/jms-ra.jar
                    2004-05-14 09:10:33,812 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jms-ra.rar
                    2004-05-14 09:10:33,812 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jms-ds.xml
                    2004-05-14 09:10:34,296 INFO [org.jboss.jms.jndi.JMSProviderLoader] Bound adapter to java:/DefaultJMSProvider
                    2004-05-14 09:10:34,296 INFO [org.jboss.jms.jndi.JMSProviderLoader] Started jboss.mq:service=JMSProviderLoader,name=JBossMQProvider
                    2004-05-14 09:10:34,328 INFO [org.jboss.jms.asf.ServerSessionPoolLoader] pool factory StdJMSPool bound to java:/StdJMSPool
                    2004-05-14 09:10:34,328 INFO [org.jboss.jms.asf.ServerSessionPoolLoader] Started jboss.mq:service=ServerSessionPoolMBean,name=StdJMSPool
                    2004-05-14 09:10:34,437 INFO [org.jboss.resource.connectionmanager.RARDeployment] Started jboss.jca:service=ManagedConnectionFactory,name=JmsXA
                    2004-05-14 09:10:34,453 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Started jboss.jca:service=ManagedConnectionPool,name=JmsXA
                    2004-05-14 09:10:34,546 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jms-ds.xml
                    2004-05-14 09:10:34,546 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/mysql-ds.xml
                    2004-05-14 09:10:34,687 INFO [org.jboss.resource.connectionmanager.RARDeployment] Started jboss.jca:service=ManagedConnectionFactory,name=
                     DefaultDS
                    
                    2004-05-14 09:10:34,687 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Started jboss.jca:service=ManagedConnectionPool,name=
                     DefaultDS
                    
                    2004-05-14 09:10:34,734 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/mysql-ds.xml
                    2004-05-14 09:10:34,750 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/cache-invalidation-service.xml
                    2004-05-14 09:10:34,812 INFO [org.jboss.cache.invalidation.InvalidationManager] Starting Invalidation Manager jboss.cache:service=InvalidationManager
                    2004-05-14 09:10:34,812 INFO [org.jboss.cache.invalidation.InvalidationManager] Started jboss.cache:service=InvalidationManager
                    2004-05-14 09:10:34,843 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/cache-invalidation-service.xml
                    2004-05-14 09:10:34,843 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/client-deployer-service.xml
                    2004-05-14 09:10:34,953 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.deployment.ClientDeployer@94124f
                    2004-05-14 09:10:34,953 INFO [org.jboss.deployment.ClientDeployer] Started jboss.j2ee:service=ClientDeployer
                    2004-05-14 09:10:34,984 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/client-deployer-service.xml
                    2004-05-14 09:10:34,984 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-destinations-service.xml
                    2004-05-14 09:10:35,265 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-destinations-service.xml
                    2004-05-14 09:10:35,281 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-service.xml
                    2004-05-14 09:10:35,687 INFO [org.jboss.mq.sm.file.DynamicStateManager] Started jboss.mq:service=StateManager
                    2004-05-14 09:10:35,734 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-service.xml
                    2004-05-14 09:10:35,734 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jvm-il-service.xml
                    2004-05-14 09:10:35,796 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jvm-il-service.xml
                    2004-05-14 09:10:35,812 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/mysql-jdbc2-service.xml
                    2004-05-14 09:10:36,062 INFO [org.jboss.mq.server.MessageCache] Started jboss.mq:service=MessageCache
                    2004-05-14 09:10:36,140 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/mysql-jdbc2-service.xml
                    2004-05-14 09:10:36,140 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/oil-service.xml
                    2004-05-14 09:10:36,218 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/oil-service.xml
                    2004-05-14 09:10:36,234 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/oil2-service.xml
                    2004-05-14 09:10:36,312 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/oil2-service.xml
                    2004-05-14 09:10:36,328 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/rmi-il-service.xml
                    2004-05-14 09:10:36,390 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/rmi-il-service.xml
                    2004-05-14 09:10:36,390 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/uil2-service.xml
                    2004-05-14 09:10:36,531 INFO [org.jboss.naming.NamingAlias] Bound link UILConnectionFactory to UIL2ConnectionFactory
                    2004-05-14 09:10:36,531 INFO [org.jboss.naming.NamingAlias] Started jboss.mq:service=InvocationLayer,type=UIL
                    2004-05-14 09:10:36,531 INFO [org.jboss.naming.NamingAlias] Bound link UILXAConnectionFactory to UIL2XAConnectionFactory
                    2004-05-14 09:10:36,531 INFO [org.jboss.naming.NamingAlias] Started jboss.mq:service=InvocationLayer,type=UILXA
                    2004-05-14 09:10:36,562 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/uil2-service.xml
                    2004-05-14 09:10:36,562 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/mail-service.xml
                    2004-05-14 09:10:37,265 INFO [org.jboss.mail.MailService] Mail Service bound to java:/Mail
                    2004-05-14 09:10:37,265 INFO [org.jboss.mail.MailService] Started jboss:service=Mail
                    2004-05-14 09:10:37,296 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/mail-service.xml
                    2004-05-14 09:10:37,296 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/properties-service.xml
                    2004-05-14 09:10:37,375 INFO [org.jboss.varia.property.PropertyEditorManagerService] Started jboss:type=Service,name=PropertyEditorManager
                    2004-05-14 09:10:37,375 INFO [org.jboss.varia.property.SystemPropertiesService] Started jboss:type=Service,name=SystemProperties
                    2004-05-14 09:10:37,390 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/properties-service.xml
                    2004-05-14 09:10:37,390 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/schedule-manager-service.xml
                    2004-05-14 09:10:37,453 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/schedule-manager-service.xml
                    2004-05-14 09:10:37,468 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/scheduler-service.xml
                    2004-05-14 09:10:37,484 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/scheduler-service.xml
                    2004-05-14 09:10:37,500 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/sqlexception-service.xml
                    2004-05-14 09:10:37,562 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/sqlexception-service.xml
                    2004-05-14 09:10:37,562 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/transaction-service.xml
                    2004-05-14 09:10:37,687 INFO [org.jboss.resource.connectionmanager.CachedConnectionManager] Started jboss.jca:service=CachedConnectionManager
                    2004-05-14 09:10:37,781 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Created securityMgr=org.jboss.security.plugins.JaasSecurityManager@14c7cd
                    2004-05-14 09:10:37,796 INFO [org.jboss.security.plugins.JaasSecurityManagerService] setCachePolicy, c=org.jboss.util.TimedCachePolicy@1c6480f
                    2004-05-14 09:10:37,812 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Added JmsXARealm, org.jboss.security.plugins.SecurityDomainContext@a50916 to map
                    2004-05-14 09:10:37,890 INFO [org.jboss.resource.adapter.jms.JmsManagedConnectionFactory.JmsXA] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=TxCM,name=JmsXA to JNDI name 'java:/JmsXA'
                    2004-05-14 09:10:37,890 INFO [org.jboss.resource.connectionmanager.TxConnectionManager] Started jboss.jca:service=TxCM,name=JmsXA
                    2004-05-14 09:10:37,906 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-05-14 09:10:37,921 INFO [org.jboss.resource.connectionmanager.TxConnectionManager] Started jboss.jca:service=LocalTxCM,name=
                     DefaultDS
                    
                    2004-05-14 09:10:37,937 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/transaction-service.xml
                    2004-05-14 09:10:37,937 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/user-service.xml
                    2004-05-14 09:10:37,968 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/user-service.xml
                    2004-05-14 09:10:37,968 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar
                    2004-05-14 09:10:40,140 INFO [org.jboss.ejb.EjbModule] Deploying CommandType
                    2004-05-14 09:10:40,765 INFO [org.jboss.ejb.EjbModule] Deploying Command
                    2004-05-14 09:10:43,109 INFO [org.jboss.ejb.plugins.EntityInstancePool] Started jboss.j2ee:jndiName=CommandType,plugin=pool,service=EJB
                    2004-05-14 09:10:43,109 INFO [org.jboss.ejb.EntityContainer] Started jboss.j2ee:jndiName=CommandType,service=EJB
                    2004-05-14 09:10:45,156 ERROR [org.jboss.ejb.EntityContainer] Starting failed
                    org.jboss.deployment.DeploymentException: Error while creating table Command; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER NOT NULL, homeCommandType VARBINARY, CONSTRAINT pk_Comm")
                     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232)
                     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:93)
                     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.NativeMethodAccessorImpl.invoke0(Native Method)
                     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                     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.GeneratedMethodAccessor6.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 $Proxy26.start(Unknown Source)
                     at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
                     at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
                     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                     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.GeneratedMethodAccessor6.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 $Proxy12.start(Unknown Source)
                     at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544)
                     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
                     at sun.reflect.GeneratedMethodAccessor20.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 $Proxy6.deploy(Unknown Source)
                     at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
                     at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
                     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
                     at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274)
                     at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
                     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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
                     at $Proxy0.start(Unknown Source)
                     at org.jboss.system.ServiceController.start(ServiceController.java:394)
                     at sun.reflect.GeneratedMethodAccessor6.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 $Proxy4.start(Unknown Source)
                     at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
                     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589)
                     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                     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 $Proxy5.deploy(Unknown Source)
                     at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384)
                     at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
                     at org.jboss.Main.boot(Main.java:150)
                     at org.jboss.Main$1.run(Main.java:395)
                     at java.lang.Thread.run(Thread.java:534)
                    Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER NOT NULL, homeCommandType VARBINARY, CONSTRAINT pk_Comm"
                     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905)
                     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
                     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
                     at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)
                     at com.mysql.jdbc.Connection.execSQL(Connection.java:2087)
                     at com.mysql.jdbc.Connection.execSQL(Connection.java:2037)
                     at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252)
                     at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198)
                     at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:262)
                     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:219)
                     ... 89 more
                    2004-05-14 09:10:45,187 WARN [org.jboss.system.ServiceController] Problem starting service jboss.j2ee:jndiName=Command,service=EJB
                    org.jboss.deployment.DeploymentException: Error while creating table Command; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER NOT NULL, homeCommandType VARBINARY, CONSTRAINT pk_Comm")
                     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232)
                     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:93)
                     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.NativeMethodAccessorImpl.invoke0(Native Method)
                     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                     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.GeneratedMethodAccessor6.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 $Proxy26.start(Unknown Source)
                     at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
                     at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
                     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                     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.GeneratedMethodAccessor6.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 $Proxy12.start(Unknown Source)
                     at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544)
                     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
                     at sun.reflect.GeneratedMethodAccessor20.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 $Proxy6.deploy(Unknown Source)
                     at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
                     at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
                     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
                     at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274)
                     at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
                     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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
                     at $Proxy0.start(Unknown Source)
                     at org.jboss.system.ServiceController.start(ServiceController.java:394)
                     at sun.reflect.GeneratedMethodAccessor6.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 $Proxy4.start(Unknown Source)
                     at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
                     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589)
                     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                     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 $Proxy5.deploy(Unknown Source)
                     at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384)
                     at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
                     at org.jboss.Main.boot(Main.java:150)
                     at org.jboss.Main$1.run(Main.java:395)
                     at java.lang.Thread.run(Thread.java:534)
                    Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER NOT NULL, homeCommandType VARBINARY, CONSTRAINT pk_Comm"
                     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905)
                     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
                     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
                     at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)
                     at com.mysql.jdbc.Connection.execSQL(Connection.java:2087)
                     at com.mysql.jdbc.Connection.execSQL(Connection.java:2037)
                     at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252)
                     at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198)
                     at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:262)
                     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:219)
                     ... 89 more
                    2004-05-14 09:10:45,203 INFO [org.jboss.ejb.EjbModule] Started jboss.j2ee:module=jstockEJB.jar,service=EjbModule
                    2004-05-14 09:10:45,203 INFO [org.jboss.ejb.EJBDeployer] Deployed: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar
                    2004-05-14 09:10:45,375 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar
                    2004-05-14 09:10:45,375 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-console.war/
                    2004-05-14 09:10:45,609 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] deploy, ctxPath=/jmx-console, warUrl=file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-console.war/
                    2004-05-14 09:10:46,046 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/jmx-console]: Ajout de certificats -> requête Attribut de Valve (attribute Valve)
                    2004-05-14 09:10:46,093 WARN [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Unable to invoke setDelegate on class loader:org.jboss.web.tomcat.tc4.WebCtxLoader$ENCLoader@10bbf6d
                    2004-05-14 09:10:46,109 INFO [org.jboss.web.localhost.Engine] StandardManager[/jmx-console]: Alimentation de la classe du générateur de nombre aléatoire java.security.SecureRandom
                    2004-05-14 09:10:46,109 INFO [org.jboss.web.localhost.Engine] StandardManager[/jmx-console]: L'alimentation du générateur de nombre aléatoire est terminé
                    2004-05-14 09:10:46,109 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/jmx-console:default]: Chargement du conteneur (container) de servlet default
                    2004-05-14 09:10:46,109 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/jmx-console:invoker]: Chargement du conteneur (container) de servlet invoker
                    2004-05-14 09:10:47,296 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-console.war/
                    2004-05-14 09:10:47,296 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/management/web-console.war
                    2004-05-14 09:10:47,906 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] deploy, ctxPath=/web-console, warUrl=file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp31351web-console.war/
                    2004-05-14 09:10:48,531 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/web-console]: Ajout de certificats -> requête Attribut de Valve (attribute Valve)
                    2004-05-14 09:10:48,593 WARN [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Unable to invoke setDelegate on class loader:org.jboss.web.tomcat.tc4.WebCtxLoader$ENCLoader@a3bb2e
                    2004-05-14 09:10:48,593 INFO [org.jboss.web.localhost.Engine] StandardManager[/web-console]: Alimentation de la classe du générateur de nombre aléatoire java.security.SecureRandom
                    2004-05-14 09:10:48,593 INFO [org.jboss.web.localhost.Engine] StandardManager[/web-console]: L'alimentation du générateur de nombre aléatoire est terminé
                    2004-05-14 09:10:49,437 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/web-console:default]: Chargement du conteneur (container) de servlet default
                    2004-05-14 09:10:49,546 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/web-console:invoker]: Chargement du conteneur (container) de servlet invoker
                    2004-05-14 09:10:50,906 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/management/web-console.war
                    2004-05-14 09:10:50,906 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
                    Cause: Incomplete Deployment listing:
                    Packages waiting for a deployer:
                     <none>
                    Incompletely deployed packages:
                     <none>
                    MBeans waiting for classes:
                     <none>
                    MBeans waiting for other MBeans:
                    [ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=Invoker
                     jboss.web:service=WebServer
                    
                     Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=DestinationManager
                     jboss.mq:service=SecurityManager
                    
                     Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=DestinationManager
                     jboss.mq:service=SecurityManager
                    
                     Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=DestinationManager
                     jboss.mq:service=SecurityManager
                    
                     Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=DestinationManager
                     jboss.mq:service=SecurityManager
                    
                     Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=DestinationManager
                    
                     Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=DestinationManager
                    
                     Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=DestinationManager
                    
                     Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=DestinationManager
                    
                     Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=DestinationManager
                    
                     Depends On Me: , ObjectName: jboss.mq:service=Invoker
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=TracingInterceptor
                    
                     Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
                     jboss.mq:service=InvocationLayer,type=JVM
                     jboss.mq:service=InvocationLayer,type=OIL
                     jboss.mq:service=InvocationLayer,type=OIL2
                     jboss.mq:service=InvocationLayer,type=RMI
                     jboss.mq:service=InvocationLayer,type=UIL2
                    , ObjectName: jboss.mq:service=TracingInterceptor
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=SecurityManager
                    
                     Depends On Me: jboss.mq:service=Invoker
                    , ObjectName: jboss.mq:service=SecurityManager
                     state: CONFIGURED
                     I Depend On: jboss.mq:service=Dest


                    • 7. Re: SQL error while JBoss try to create the table in my data

                      It didn't reveal anything additional, other than MySQL is unable to create a table for you with the SQL generated by CMP. Maybe MySQL lacks the ability to handle integrity constraints or maybe the SQL dialect is just wrong.

                      Set DEBUG level logging on the org.jboss.ejb.plugins.cmp category and check what is the SQL it's trying to invoke, and check if MySQL is actually able to swallow that.

                      Or just manually create your tables on MySQL, and see if you're able to succesfully insert and update the rows with your current EJB configuration.

                      • 8. Re: SQL error while JBoss try to create the table in my data
                        amalsekro

                        Ok but one question : how ? (I'm a newbie, remember ...)

                        • 9. Re: SQL error while JBoss try to create the table in my data

                          Create tables on MySQL with the schema that you expect from your EJB...

                          CREATE TABLE(.... )

                          If the tables are present, JBoss won't attempt to create them and you may get further and hopefully find out something more revealing about why MySQL is failing on that SQL statement.

                          • 10. Re: SQL error while JBoss try to create the table in my data
                            amalsekro

                            Well, not only MySQL failed, I tried with the default java database at my home, and there was an error too...

                            • 11. Re: SQL error while JBoss try to create the table in my data

                              What is the error from hypersonic?

                              • 12. Re: SQL error while JBoss try to create the table in my data
                                amalsekro

                                maybe it's because of this :

                                 * @jboss.relation related-pk-field = "id"
                                


                                in the relation, both entities have an "id" as a primary key ....

                                • 13. Re: SQL error while JBoss try to create the table in my data
                                  amalsekro

                                  For Hypersonic, here is my server.log

                                  2004-05-14 11:17:12,468 INFO [org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread] Running
                                  2004-05-14 11:17:12,484 INFO [org.jboss.management.j2ee.LocalJBossServerDomain] Started jboss.management.local:j2eeType=J2EEDomain,name=Manager
                                  2004-05-14 11:17:12,484 INFO [org.jboss.logging.Log4jService] Started jboss.system:type=Log4jService,service=Logging
                                  2004-05-14 11:17:12,500 INFO [org.jboss.web.WebService] Started WebServer with address: 0.0.0.0:8083
                                  2004-05-14 11:17:12,515 INFO [org.jboss.web.WebService] Using RMI server codebase: http://leonardo:8083/
                                  2004-05-14 11:17:12,515 INFO [org.jboss.web.WebService] Started jboss:service=WebService
                                  2004-05-14 11:17:12,515 INFO [org.jboss.naming.NamingService] Starting jnp server
                                  2004-05-14 11:17:12,718 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-05-14 11:17:12,765 INFO [org.jboss.naming.NamingService] Listening on port 1099
                                  2004-05-14 11:17:12,796 INFO [org.jboss.naming.NamingService] Started jboss:service=Naming
                                  2004-05-14 11:17:12,796 INFO [org.jboss.naming.JNDIView] Started jboss:service=JNDIView
                                  2004-05-14 11:17:12,796 INFO [org.jboss.security.plugins.SecurityConfig] Started jboss.security:service=SecurityConfig
                                  2004-05-14 11:17:12,890 INFO [org.jboss.security.auth.login.XMLLoginConfig] Started jboss.security:service=XMLLoginConfig
                                  2004-05-14 11:17:12,953 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Started jboss.security:service=JaasSecurityManager
                                  2004-05-14 11:17:13,031 INFO [org.jboss.tm.TransactionManagerService] Started jboss:service=TransactionManager
                                  2004-05-14 11:17:13,125 INFO [org.jboss.invocation.jrmp.server.JRMPInvoker] Started jboss:service=invoker,type=jrmp
                                  2004-05-14 11:17:13,250 INFO [org.jboss.invocation.jrmp.server.JRMPProxyFactory] Started jboss:service=proxyFactory,target=ClientUserTransactionFactory
                                  2004-05-14 11:17:13,265 INFO [org.jboss.invocation.jrmp.server.JRMPProxyFactory] Started jboss:service=proxyFactory,target=ClientUserTransaction
                                  2004-05-14 11:17:13,312 INFO [org.jboss.tm.usertx.server.ClientUserTransactionService] Started jboss:service=ClientUserTransaction
                                  2004-05-14 11:17:13,328 INFO [org.jboss.invocation.local.LocalInvoker] Started jboss:service=invoker,type=local
                                  2004-05-14 11:17:13,406 INFO [org.jboss.invocation.pooled.server.PooledInvoker] Started jboss:service=invoker,type=pooled
                                  2004-05-14 11:17:13,453 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.ejb.EJBDeployer@c272bc
                                  2004-05-14 11:17:13,453 INFO [org.jboss.ejb.EJBDeployer] Started jboss.ejb:service=EJBDeployer
                                  2004-05-14 11:17:13,453 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.deployment.EARDeployer@6d1750
                                  2004-05-14 11:17:13,453 INFO [org.jboss.deployment.EARDeployer] Started jboss.j2ee:service=EARDeployer
                                  2004-05-14 11:17:13,515 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.varia.deployment.BeanShellSubDeployer@da3772
                                  2004-05-14 11:17:13,515 INFO [org.jboss.varia.deployment.BeanShellSubDeployer] Started jboss.scripts:service=BSHDeployer
                                  2004-05-14 11:17:13,546 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/
                                  2004-05-14 11:17:13,562 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                                  2004-05-14 11:17:13,578 INFO [org.jboss.deployment.MainDeployer] deployment waiting for deployer: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                                  2004-05-14 11:17:13,906 INFO [org.jboss.invocation.http.server.HttpInvoker] Started jboss:service=invoker,type=http
                                  2004-05-14 11:17:13,906 INFO [org.jboss.invocation.http.server.HttpInvokerHA] Started jboss:service=invoker,type=httpHA
                                  2004-05-14 11:17:13,937 INFO [org.jboss.invocation.http.server.HttpProxyFactory] Started jboss:service=invoker,type=http,target=Naming
                                  2004-05-14 11:17:13,937 INFO [org.jboss.invocation.http.server.HttpProxyFactory] Started jboss:service=invoker,type=http,target=Naming,readonly=true
                                  2004-05-14 11:17:14,093 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/
                                  2004-05-14 11:17:14,109 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-jca.sar
                                  2004-05-14 11:17:15,203 INFO [org.jboss.deployment.XSLSubDeployer] Created templates: org.apache.xalan.templates.StylesheetRoot@dafa2c
                                  2004-05-14 11:17:15,203 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.resource.RARDeployer@5e9db7
                                  2004-05-14 11:17:15,203 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                                  2004-05-14 11:17:15,203 INFO [org.jboss.deployment.MainDeployer] deployment waiting for deployer: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                                  2004-05-14 11:17:15,203 INFO [org.jboss.deployment.MainDeployer] Deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/ is waiting for an appropriate deployer.
                                  2004-05-14 11:17:15,218 INFO [org.jboss.resource.RARDeployer] Started jboss.jca:service=RARDeployer
                                  2004-05-14 11:17:15,218 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.deployment.XSLSubDeployer@1fc25e5
                                  2004-05-14 11:17:15,218 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                                  2004-05-14 11:17:15,218 INFO [org.jboss.deployment.MainDeployer] deployment waiting for deployer: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                                  2004-05-14 11:17:15,218 INFO [org.jboss.deployment.MainDeployer] Deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/ is waiting for an appropriate deployer.
                                  2004-05-14 11:17:15,218 INFO [org.jboss.deployment.XSLSubDeployer] Started jboss.jca:service=ConnectionFactoryDeployer
                                  2004-05-14 11:17:15,234 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-jca.sar
                                  2004-05-14 11:17:15,250 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/
                                  2004-05-14 11:17:15,281 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/ant.jar
                                  2004-05-14 11:17:15,281 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/bootstrap.jar
                                  2004-05-14 11:17:15,281 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/catalina.jar
                                  2004-05-14 11:17:15,281 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/commons-beanutils.jar
                                  2004-05-14 11:17:15,281 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/commons-collections.jar
                                  2004-05-14 11:17:15,281 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/commons-digester.jar
                                  2004-05-14 11:17:15,281 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/commons-logging.jar
                                  2004-05-14 11:17:15,296 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/jakarta-regexp-1.3.jar
                                  2004-05-14 11:17:15,296 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/jasper-compiler.jar
                                  2004-05-14 11:17:15,296 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/jasper-runtime.jar
                                  2004-05-14 11:17:15,296 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/naming-common.jar
                                  2004-05-14 11:17:15,296 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/naming-resources.jar
                                  2004-05-14 11:17:15,296 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/servlets-common.jar
                                  2004-05-14 11:17:15,312 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/servlets-default.jar
                                  2004-05-14 11:17:15,312 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/servlets-invoker.jar
                                  2004-05-14 11:17:15,312 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/servlets-webdav.jar
                                  2004-05-14 11:17:15,312 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat-coyote.jar
                                  2004-05-14 11:17:15,312 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat-http11.jar
                                  2004-05-14 11:17:15,312 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat-jk2.jar
                                  2004-05-14 11:17:15,312 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat-util.jar
                                  2004-05-14 11:17:15,328 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/tomcat41-service.jar
                                  2004-05-14 11:17:18,375 INFO [STDOUT] Apache Tomcat/4.1.29
                                  2004-05-14 11:17:18,687 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut soLinger: -1
                                  2004-05-14 11:17:18,687 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut soTimeout: 60000
                                  2004-05-14 11:17:18,687 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut serverSoTimeout: 0
                                  2004-05-14 11:17:18,703 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut tcpNoDelay: true
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut jkHome: D:\Utilitaires\App-Server\jboss-3.2.3\server\default
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut port: 8080
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut maxThreads: 100
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut backlog: 10
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut tcpNoDelay: true
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut soLinger: -1
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut soTimeout: 20000
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut timeout: 300000
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut serverSoTimeout: 0
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut maxKeepAliveRequests: 100
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut tomcatAuthentication: true
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut compression: off
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut address: /0.0.0.0
                                  2004-05-14 11:17:18,718 DEBUG [org.apache.coyote.http11.Http11Protocol] Attribut secure: false
                                  2004-05-14 11:17:18,734 INFO [org.apache.coyote.http11.Http11Protocol] Initialisation de Coyote HTTP/1.1 sur le port 8080
                                  2004-05-14 11:17:18,734 INFO [org.jboss.web.localhost.Engine] CoyoteConnector Coyote can't register jmx for protocol
                                  2004-05-14 11:17:18,781 INFO [org.apache.coyote.http11.Http11Protocol] Démarrage de Coyote HTTP/1.1 sur le port 8080
                                  2004-05-14 11:17:19,062 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty jkHome D:\Utilitaires\App-Server\jboss-3.2.3\server\default
                                  2004-05-14 11:17:19,250 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty port 8009
                                  2004-05-14 11:17:19,250 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty maxThreads 75
                                  2004-05-14 11:17:19,265 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty backlog 10
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty tcpNoDelay true
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty soLinger -1
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty soTimeout 20000
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty timeout 300000
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty serverSoTimeout 0
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty disableUploadTimeout false
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty maxKeepAliveRequests 100
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty tomcatAuthentication true
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty compression off
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty address 0.0.0.0
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkCoyoteHandler] setProperty secure false
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkMain] Starting Jk2, base dir= D:\Utilitaires\App-Server\jboss-3.2.3\server\default
                                  2004-05-14 11:17:19,281 DEBUG [org.apache.jk.server.JkMain] No properties file found D:\Utilitaires\App-Server\jboss-3.2.3\server\default\conf\jk2.properties
                                  2004-05-14 11:17:19,296 INFO [org.jboss.web.localhost.Engine] CoyoteConnector Coyote can't register jmx for protocol
                                  2004-05-14 11:17:19,328 DEBUG [org.apache.jk.server.JkMain] Substituting tomcatAuthentication request.tomcatAuthentication true
                                  2004-05-14 11:17:19,328 DEBUG [org.apache.jk.server.JkMain] Substituting soTimeout channelSocket.soTimeout 20000
                                  2004-05-14 11:17:19,328 DEBUG [org.apache.jk.server.JkMain] Substituting port channelSocket.port 8009
                                  2004-05-14 11:17:19,328 DEBUG [org.apache.jk.server.JkMain] Substituting maxThreads channelSocket.maxThreads 75
                                  2004-05-14 11:17:19,328 DEBUG [org.apache.jk.server.JkMain] Substituting backlog channelSocket.backlog 10
                                  2004-05-14 11:17:19,328 DEBUG [org.apache.jk.server.JkMain] Substituting timeout channelSocket.timeout 300000
                                  2004-05-14 11:17:19,328 DEBUG [org.apache.jk.server.JkMain] Substituting address channelSocket.address 0.0.0.0
                                  2004-05-14 11:17:19,328 DEBUG [org.apache.jk.server.JkMain] Substituting tcpNoDelay channelSocket.tcpNoDelay true
                                  2004-05-14 11:17:19,343 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket address
                                  2004-05-14 11:17:19,343 DEBUG [org.apache.jk.server.JkMain] Setting address on channelSocket org.apache.jk.common.ChannelSocket@162f030
                                  2004-05-14 11:17:19,343 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@162f030 address=0.0.0.0
                                  2004-05-14 11:17:19,390 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket soTimeout
                                  2004-05-14 11:17:19,390 DEBUG [org.apache.jk.server.JkMain] Setting soTimeout on channelSocket org.apache.jk.common.ChannelSocket@162f030
                                  2004-05-14 11:17:19,390 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@162f030 soTimeout=20000
                                  2004-05-14 11:17:19,390 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket timeout
                                  2004-05-14 11:17:19,390 DEBUG [org.apache.jk.server.JkMain] Setting timeout on channelSocket org.apache.jk.common.ChannelSocket@162f030
                                  2004-05-14 11:17:19,390 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@162f030 timeout=300000
                                  2004-05-14 11:17:19,390 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket maxThreads
                                  2004-05-14 11:17:19,390 DEBUG [org.apache.jk.server.JkMain] Setting maxThreads on channelSocket org.apache.jk.common.ChannelSocket@162f030
                                  2004-05-14 11:17:19,406 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@162f030 maxThreads=75
                                  2004-05-14 11:17:19,421 DEBUG [org.apache.jk.common.ChannelSocket] Setting maxThreads 75
                                  2004-05-14 11:17:19,421 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket backlog
                                  2004-05-14 11:17:19,421 DEBUG [org.apache.jk.server.JkMain] Setting backlog on channelSocket org.apache.jk.common.ChannelSocket@162f030
                                  2004-05-14 11:17:19,421 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@162f030 backlog=10
                                  2004-05-14 11:17:19,421 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket tcpNoDelay
                                  2004-05-14 11:17:19,421 DEBUG [org.apache.jk.server.JkMain] Setting tcpNoDelay on channelSocket org.apache.jk.common.ChannelSocket@162f030
                                  2004-05-14 11:17:19,421 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@162f030 tcpNoDelay=true
                                  2004-05-14 11:17:19,421 DEBUG [org.apache.jk.server.JkMain] Processing request::request tomcatAuthentication
                                  2004-05-14 11:17:19,421 DEBUG [org.apache.jk.server.JkMain] Setting tomcatAuthentication on request org.apache.jk.common.HandlerRequest@39ea58
                                  2004-05-14 11:17:19,437 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.HandlerRequest@39ea58 tomcatAuthentication=true
                                  2004-05-14 11:17:19,437 DEBUG [org.apache.jk.server.JkMain] Processing channelSocket::channelSocket port
                                  2004-05-14 11:17:19,437 DEBUG [org.apache.jk.server.JkMain] Setting port on channelSocket org.apache.jk.common.ChannelSocket@162f030
                                  2004-05-14 11:17:19,437 DEBUG [org.apache.jk.server.JkMain] setProperty org.apache.jk.common.ChannelSocket@162f030 port=8009
                                  2004-05-14 11:17:19,484 DEBUG [org.apache.jk.common.HandlerRequest] Container handler org.apache.jk.server.JkCoyoteHandler@1b044df container org.apache.jk.server.JkCoyoteHandler
                                  2004-05-14 11:17:19,484 INFO [org.apache.jk.common.ChannelSocket] JK2: ajp13 listening on /0.0.0.0:8009
                                  2004-05-14 11:17:19,593 DEBUG [org.apache.tomcat.util.threads.ThreadPool] Getting new thread data
                                  2004-05-14 11:17:19,593 DEBUG [org.apache.tomcat.util.threads.ThreadPool] Getting new thread data
                                  2004-05-14 11:17:19,593 DEBUG [org.apache.jk.common.ChannelSocket] Accepting ajp connections on 8009
                                  2004-05-14 11:17:19,593 INFO [org.apache.jk.server.JkMain] Jk running ID=0 time=0/297 config=null
                                  2004-05-14 11:17:19,593 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] OK
                                  2004-05-14 11:17:19,593 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.web.tomcat.tc4.EmbeddedTomcatService@9fd062
                                  2004-05-14 11:17:19,593 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                                  2004-05-14 11:17:19,875 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] deploy, ctxPath=/invoker, warUrl=file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                                  2004-05-14 11:17:21,109 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/invoker]: Ajout de certificats -> requête Attribut de Valve (attribute Valve)
                                  2004-05-14 11:17:21,265 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/invoker]: Configuration d'un authentificateur (authenticator) pour la méthode BASIC
                                  2004-05-14 11:17:21,296 WARN [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Unable to invoke setDelegate on class loader:org.jboss.web.tomcat.tc4.WebCtxLoader$ENCLoader@541b02
                                  2004-05-14 11:17:21,328 INFO [org.jboss.web.localhost.Engine] StandardManager[/invoker]: Alimentation de la classe du générateur de nombre aléatoire java.security.SecureRandom
                                  2004-05-14 11:17:21,562 INFO [org.jboss.web.localhost.Engine] StandardManager[/invoker]: L'alimentation du générateur de nombre aléatoire est terminé
                                  2004-05-14 11:17:21,687 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/invoker:default]: Chargement du conteneur (container) de servlet default
                                  2004-05-14 11:17:21,812 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/invoker:invoker]: Chargement du conteneur (container) de servlet invoker
                                  2004-05-14 11:17:23,437 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/http-invoker.sar/invoker.war/
                                  2004-05-14 11:17:23,437 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Started jboss.web:service=WebServer
                                  2004-05-14 11:17:23,468 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jbossweb-tomcat41.sar/
                                  2004-05-14 11:17:23,468 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-httpil.sar/
                                  2004-05-14 11:17:23,500 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
                                  2004-05-14 11:17:23,781 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] deploy, ctxPath=/jbossmq-httpil, warUrl=file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
                                  2004-05-14 11:17:24,218 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/jbossmq-httpil]: Ajout de certificats -> requête Attribut de Valve (attribute Valve)
                                  2004-05-14 11:17:24,218 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/jbossmq-httpil]: Configuration d'un authentificateur (authenticator) pour la méthode BASIC
                                  2004-05-14 11:17:24,265 WARN [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Unable to invoke setDelegate on class loader:org.jboss.web.tomcat.tc4.WebCtxLoader$ENCLoader@1087d61
                                  2004-05-14 11:17:24,265 INFO [org.jboss.web.localhost.Engine] StandardManager[/jbossmq-httpil]: Alimentation de la classe du générateur de nombre aléatoire java.security.SecureRandom
                                  2004-05-14 11:17:24,265 INFO [org.jboss.web.localhost.Engine] StandardManager[/jbossmq-httpil]: L'alimentation du générateur de nombre aléatoire est terminé
                                  2004-05-14 11:17:24,265 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/jbossmq-httpil:default]: Chargement du conteneur (container) de servlet default
                                  2004-05-14 11:17:24,265 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/jbossmq-httpil:invoker]: Chargement du conteneur (container) de servlet invoker
                                  2004-05-14 11:17:24,781 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-httpil.sar/
                                  2004-05-14 11:17:24,796 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-invoker-adaptor-server.sar/
                                  2004-05-14 11:17:25,109 INFO [org.jboss.invocation.jrmp.server.JRMPProxyFactory] Started jboss.jmx:type=adaptor,name=Invoker,protocol=jrmp,service=proxyFactory
                                  2004-05-14 11:17:25,125 INFO [org.jboss.naming.NamingAlias] Bound link jmx/rmi/RMIAdaptor to jmx/invoker/RMIAdaptor
                                  2004-05-14 11:17:25,125 INFO [org.jboss.naming.NamingAlias] Started jboss.jmx:alias=jmx/rmi/RMIAdaptor
                                  2004-05-14 11:17:25,140 INFO [org.jboss.jmx.connector.invoker.InvokerAdaptorService] Started jboss.jmx:type=adaptor,name=Invoker
                                  2004-05-14 11:17:25,171 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-invoker-adaptor-server.sar/
                                  2004-05-14 11:17:25,171 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/management/console-mgr.sar
                                  2004-05-14 11:17:25,250 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp30925console-mgr.sar-contents/console-mgr-classes.jar
                                  2004-05-14 11:17:25,281 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp30925console-mgr.sar-contents/jcommon.jar
                                  2004-05-14 11:17:25,328 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp30925console-mgr.sar-contents/jfreechart-demo.jar
                                  2004-05-14 11:17:25,390 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp30925console-mgr.sar-contents/jfreechart.jar
                                  2004-05-14 11:17:26,140 INFO [org.jboss.console.manager.PluginManager] Started jboss.admin:service=PluginManager
                                  2004-05-14 11:17:26,156 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/management/console-mgr.sar
                                  2004-05-14 11:17:26,171 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/snmp-adaptor.sar/
                                  2004-05-14 11:17:26,171 INFO [org.jboss.deployment.SARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/snmp-adaptor.sar/castor.jar
                                  2004-05-14 11:17:27,046 INFO [org.jboss.jmx.adaptor.snmp.trapd.TrapdService] Started jboss.jmx:name=SnmpAgent,service=trapd,type=logger
                                  2004-05-14 11:17:27,046 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Instantiating trap emitter ...
                                  2004-05-14 11:17:27,125 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Starting trap emitter ...
                                  2004-05-14 11:17:27,125 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapEmitter] Reading resource: "/managers.xml"
                                  2004-05-14 11:17:27,890 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapEmitter] "/managers.xml" valid. Read 1 monitoring managers
                                  2004-05-14 11:17:27,890 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapEmitter] Executing resource: "/managers.xml"
                                  2004-05-14 11:17:28,078 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapFactorySupport] Reading resource: "/notifications.xml"
                                  2004-05-14 11:17:28,203 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapFactorySupport] "/notifications.xml" valid. Read 2 mappings
                                  2004-05-14 11:17:28,203 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapFactorySupport] Executing resource: "/notifications.xml"
                                  2004-05-14 11:17:28,312 INFO [org.jboss.jmx.adaptor.snmp.agent.TrapFactorySupport] Trap factory going active
                                  2004-05-14 11:17:28,312 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Instantiating subscription manager ...
                                  2004-05-14 11:17:28,328 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Starting subscription manager ...
                                  2004-05-14 11:17:28,328 INFO [org.jboss.jmx.adaptor.snmp.agent.SubscriptionMgr] Reading resource: "/mbeans.xml"
                                  2004-05-14 11:17:28,375 INFO [org.jboss.jmx.adaptor.snmp.agent.SubscriptionMgr] "/mbeans.xml" valid. Read 2 monitored objects
                                  2004-05-14 11:17:28,375 INFO [org.jboss.jmx.adaptor.snmp.agent.SubscriptionMgr] Executing resource: "/mbeans.xml"
                                  2004-05-14 11:17:28,390 INFO [org.jboss.jmx.adaptor.snmp.agent.SubscriptionMgr] Subscription manager done
                                  2004-05-14 11:17:28,406 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Starting heartbeat controller ...
                                  2004-05-14 11:17:28,406 WARN [org.jboss.jmx.adaptor.snmp.agent.Heartbeat] Heartbeat disabled
                                  2004-05-14 11:17:28,546 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Snmp Agent going active
                                  2004-05-14 11:17:28,546 INFO [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] Started jboss.jmx:name=SnmpAgent,service=snmp,type=adaptor
                                  2004-05-14 11:17:28,578 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/snmp-adaptor.sar/
                                  2004-05-14 11:17:28,593 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/uuid-key-generator.sar
                                  2004-05-14 11:17:28,718 INFO [org.jboss.ejb.plugins.keygenerator.uuid.UUIDKeyGeneratorFactoryService] Started jboss:service=UUIDKeyGeneratorFactory
                                  2004-05-14 11:17:28,750 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/uuid-key-generator.sar
                                  2004-05-14 11:17:28,750 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-local-jdbc.rar
                                  2004-05-14 11:17:29,328 INFO [org.jboss.resource.RARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp30928jboss-local-jdbc.rar-contents/jboss-local-jdbc.jar
                                  2004-05-14 11:17:29,562 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-local-jdbc.rar
                                  2004-05-14 11:17:29,562 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-xa-jdbc.rar
                                  2004-05-14 11:17:29,687 INFO [org.jboss.resource.RARMetaData] Loading JBoss Resource Adapter for JDBC 2 XA drivers
                                  2004-05-14 11:17:29,687 INFO [org.jboss.resource.RARMetaData] Required license terms present. See deployment descriptor.
                                  2004-05-14 11:17:29,703 INFO [org.jboss.resource.RARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp30929jboss-xa-jdbc.rar-contents/jboss-xa-jdbc.jar
                                  2004-05-14 11:17:29,765 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jboss-xa-jdbc.rar
                                  2004-05-14 11:17:29,765 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jms-ra.rar
                                  2004-05-14 11:17:29,875 INFO [org.jboss.resource.RARDeployer] nested deployment: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp30930jms-ra.rar-contents/jms-ra.jar
                                  2004-05-14 11:17:29,937 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jms-ra.rar
                                  2004-05-14 11:17:29,937 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/hsqldb-ds.xml
                                  2004-05-14 11:17:30,343 INFO [org.jboss.resource.connectionmanager.RARDeployment] Started jboss.jca:service=ManagedConnectionFactory,name=DefaultDS
                                  2004-05-14 11:17:30,359 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Started jboss.jca:service=ManagedConnectionPool,name=DefaultDS
                                  2004-05-14 11:17:30,453 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/hsqldb-ds.xml
                                  2004-05-14 11:17:30,453 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jms-ds.xml
                                  2004-05-14 11:17:30,671 INFO [org.jboss.jms.jndi.JMSProviderLoader] Bound adapter to java:/DefaultJMSProvider
                                  2004-05-14 11:17:30,671 INFO [org.jboss.jms.jndi.JMSProviderLoader] Started jboss.mq:service=JMSProviderLoader,name=JBossMQProvider
                                  2004-05-14 11:17:30,703 INFO [org.jboss.jms.asf.ServerSessionPoolLoader] pool factory StdJMSPool bound to java:/StdJMSPool
                                  2004-05-14 11:17:30,703 INFO [org.jboss.jms.asf.ServerSessionPoolLoader] Started jboss.mq:service=ServerSessionPoolMBean,name=StdJMSPool
                                  2004-05-14 11:17:30,828 INFO [org.jboss.resource.connectionmanager.RARDeployment] Started jboss.jca:service=ManagedConnectionFactory,name=JmsXA
                                  2004-05-14 11:17:30,828 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Started jboss.jca:service=ManagedConnectionPool,name=JmsXA
                                  2004-05-14 11:17:30,875 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jms-ds.xml
                                  2004-05-14 11:17:30,875 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/cache-invalidation-service.xml
                                  2004-05-14 11:17:30,953 INFO [org.jboss.cache.invalidation.InvalidationManager] Starting Invalidation Manager jboss.cache:service=InvalidationManager
                                  2004-05-14 11:17:30,953 INFO [org.jboss.cache.invalidation.InvalidationManager] Started jboss.cache:service=InvalidationManager
                                  2004-05-14 11:17:30,968 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/cache-invalidation-service.xml
                                  2004-05-14 11:17:30,968 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/client-deployer-service.xml
                                  2004-05-14 11:17:31,078 INFO [org.jboss.deployment.MainDeployer] Adding deployer: org.jboss.deployment.ClientDeployer@1d602b3
                                  2004-05-14 11:17:31,078 INFO [org.jboss.deployment.ClientDeployer] Started jboss.j2ee:service=ClientDeployer
                                  2004-05-14 11:17:31,109 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/client-deployer-service.xml
                                  2004-05-14 11:17:31,109 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/hsqldb-jdbc2-service.xml
                                  2004-05-14 11:17:31,375 INFO [org.jboss.mq.server.MessageCache] Started jboss.mq:service=MessageCache
                                  2004-05-14 11:17:31,406 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/hsqldb-jdbc2-service.xml
                                  2004-05-14 11:17:31,421 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-destinations-service.xml
                                  2004-05-14 11:17:31,703 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-destinations-service.xml
                                  2004-05-14 11:17:31,703 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-service.xml
                                  2004-05-14 11:17:32,062 INFO [org.jboss.mq.sm.file.DynamicStateManager] Started jboss.mq:service=StateManager
                                  2004-05-14 11:17:32,093 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jbossmq-service.xml
                                  2004-05-14 11:17:32,093 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jvm-il-service.xml
                                  2004-05-14 11:17:32,203 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/jvm-il-service.xml
                                  2004-05-14 11:17:32,203 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/oil-service.xml
                                  2004-05-14 11:17:32,281 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/oil-service.xml
                                  2004-05-14 11:17:32,296 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/oil2-service.xml
                                  2004-05-14 11:17:32,359 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/oil2-service.xml
                                  2004-05-14 11:17:32,359 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/rmi-il-service.xml
                                  2004-05-14 11:17:32,453 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/rmi-il-service.xml
                                  2004-05-14 11:17:32,453 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/uil2-service.xml
                                  2004-05-14 11:17:32,609 INFO [org.jboss.naming.NamingAlias] Bound link UILConnectionFactory to UIL2ConnectionFactory
                                  2004-05-14 11:17:32,609 INFO [org.jboss.naming.NamingAlias] Started jboss.mq:service=InvocationLayer,type=UIL
                                  2004-05-14 11:17:32,609 INFO [org.jboss.naming.NamingAlias] Bound link UILXAConnectionFactory to UIL2XAConnectionFactory
                                  2004-05-14 11:17:32,609 INFO [org.jboss.naming.NamingAlias] Started jboss.mq:service=InvocationLayer,type=UILXA
                                  2004-05-14 11:17:32,640 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jms/uil2-service.xml
                                  2004-05-14 11:17:32,640 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/mail-service.xml
                                  2004-05-14 11:17:33,218 INFO [org.jboss.mail.MailService] Mail Service bound to java:/Mail
                                  2004-05-14 11:17:33,218 INFO [org.jboss.mail.MailService] Started jboss:service=Mail
                                  2004-05-14 11:17:33,250 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/mail-service.xml
                                  2004-05-14 11:17:33,250 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/properties-service.xml
                                  2004-05-14 11:17:33,328 INFO [org.jboss.varia.property.PropertyEditorManagerService] Started jboss:type=Service,name=PropertyEditorManager
                                  2004-05-14 11:17:33,328 INFO [org.jboss.varia.property.SystemPropertiesService] Started jboss:type=Service,name=SystemProperties
                                  2004-05-14 11:17:33,359 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/properties-service.xml
                                  2004-05-14 11:17:33,359 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/schedule-manager-service.xml
                                  2004-05-14 11:17:33,406 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/schedule-manager-service.xml
                                  2004-05-14 11:17:33,406 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/scheduler-service.xml
                                  2004-05-14 11:17:33,453 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/scheduler-service.xml
                                  2004-05-14 11:17:33,453 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/sqlexception-service.xml
                                  2004-05-14 11:17:33,515 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/sqlexception-service.xml
                                  2004-05-14 11:17:33,515 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/transaction-service.xml
                                  2004-05-14 11:17:33,718 INFO [org.jboss.resource.connectionmanager.CachedConnectionManager] Started jboss.jca:service=CachedConnectionManager
                                  2004-05-14 11:17:33,812 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Created securityMgr=org.jboss.security.plugins.JaasSecurityManager@1445748
                                  2004-05-14 11:17:33,843 INFO [org.jboss.security.plugins.JaasSecurityManagerService] setCachePolicy, c=org.jboss.util.TimedCachePolicy@1bfeb82
                                  2004-05-14 11:17:33,843 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Added HsqlDbRealm, org.jboss.security.plugins.SecurityDomainContext@fed6f7 to map
                                  2004-05-14 11:17:33,890 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-05-14 11:17:33,890 INFO [org.jboss.resource.connectionmanager.TxConnectionManager] Started jboss.jca:service=LocalTxCM,name=DefaultDS
                                  2004-05-14 11:17:35,171 INFO [org.jboss.mq.pm.jdbc2.PersistenceManager] Started jboss.mq:service=PersistenceManager
                                  2004-05-14 11:17:35,203 INFO [org.jboss.mq.server.jmx.DestinationManager] Started jboss.mq:service=DestinationManager
                                  2004-05-14 11:17:35,296 INFO [org.jboss.mq.server.jmx.Queue.A] Bound to JNDI name: queue/A
                                  2004-05-14 11:17:35,296 INFO [org.jboss.mq.server.jmx.Queue.A] Started jboss.mq.destination:service=Queue,name=A
                                  2004-05-14 11:17:35,296 INFO [org.jboss.mq.server.jmx.Queue.B] Bound to JNDI name: queue/B
                                  2004-05-14 11:17:35,296 INFO [org.jboss.mq.server.jmx.Queue.B] Started jboss.mq.destination:service=Queue,name=B
                                  2004-05-14 11:17:35,296 INFO [org.jboss.mq.server.jmx.Queue.C] Bound to JNDI name: queue/C
                                  2004-05-14 11:17:35,296 INFO [org.jboss.mq.server.jmx.Queue.C] Started jboss.mq.destination:service=Queue,name=C
                                  2004-05-14 11:17:35,312 INFO [org.jboss.mq.server.jmx.Queue.D] Bound to JNDI name: queue/D
                                  2004-05-14 11:17:35,312 INFO [org.jboss.mq.server.jmx.Queue.D] Started jboss.mq.destination:service=Queue,name=D
                                  2004-05-14 11:17:35,312 INFO [org.jboss.mq.server.jmx.Queue.ex] Bound to JNDI name: queue/ex
                                  2004-05-14 11:17:35,312 INFO [org.jboss.mq.server.jmx.Queue.ex] Started jboss.mq.destination:service=Queue,name=ex
                                  2004-05-14 11:17:35,375 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Created securityMgr=org.jboss.security.plugins.JaasSecurityManager@baf4ae
                                  2004-05-14 11:17:35,375 INFO [org.jboss.security.plugins.JaasSecurityManagerService] setCachePolicy, c=org.jboss.util.TimedCachePolicy@15e68d
                                  2004-05-14 11:17:35,375 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Added jbossmq, org.jboss.security.plugins.SecurityDomainContext@1d3633c to map
                                  2004-05-14 11:17:35,406 INFO [org.jboss.mq.security.SecurityManager] Started jboss.mq:service=SecurityManager
                                  2004-05-14 11:17:35,421 INFO [org.jboss.mq.server.jmx.Topic.testTopic] Bound to JNDI name: topic/testTopic
                                  2004-05-14 11:17:35,421 INFO [org.jboss.mq.server.jmx.Topic.testTopic] Started jboss.mq.destination:service=Topic,name=testTopic
                                  2004-05-14 11:17:35,421 INFO [org.jboss.mq.server.jmx.Topic.securedTopic] Bound to JNDI name: topic/securedTopic
                                  2004-05-14 11:17:35,421 INFO [org.jboss.mq.server.jmx.Topic.securedTopic] Started jboss.mq.destination:service=Topic,name=securedTopic
                                  2004-05-14 11:17:35,437 INFO [org.jboss.mq.server.jmx.Topic.testDurableTopic] Bound to JNDI name: topic/testDurableTopic
                                  2004-05-14 11:17:35,437 INFO [org.jboss.mq.server.jmx.Topic.testDurableTopic] Started jboss.mq.destination:service=Topic,name=testDurableTopic
                                  2004-05-14 11:17:35,437 INFO [org.jboss.mq.server.jmx.Queue.testQueue] Bound to JNDI name: queue/testQueue
                                  2004-05-14 11:17:35,437 INFO [org.jboss.mq.server.jmx.Queue.testQueue] Started jboss.mq.destination:service=Queue,name=testQueue
                                  2004-05-14 11:17:35,437 INFO [org.jboss.mq.server.jmx.InterceptorLoader] Started jboss.mq:service=TracingInterceptor
                                  2004-05-14 11:17:35,437 INFO [org.jboss.mq.server.jmx.Invoker] Started jboss.mq:service=Invoker
                                  2004-05-14 11:17:35,718 INFO [org.jboss.mq.il.http.HTTPServerILService] Started jboss.mq:service=InvocationLayer,type=HTTP
                                  2004-05-14 11:17:35,734 INFO [org.jboss.mq.il.jvm.JVMServerILService] Started jboss.mq:service=InvocationLayer,type=JVM
                                  2004-05-14 11:17:35,734 INFO [org.jboss.mq.il.oil.OILServerILService] JBossMQ OIL service available at : /0.0.0.0:8090
                                  2004-05-14 11:17:35,796 INFO [org.jboss.mq.il.oil.OILServerILService] Started jboss.mq:service=InvocationLayer,type=OIL
                                  2004-05-14 11:17:35,796 INFO [org.jboss.mq.il.oil2.OIL2ServerILService] JBossMQ OIL2 service available at : /0.0.0.0:8092
                                  2004-05-14 11:17:35,875 INFO [org.jboss.mq.il.oil2.OIL2ServerILService] Started jboss.mq:service=InvocationLayer,type=OIL2
                                  2004-05-14 11:17:36,062 INFO [org.jboss.mq.il.rmi.RMIServerILService] Started jboss.mq:service=InvocationLayer,type=RMI
                                  2004-05-14 11:17:36,062 INFO [org.jboss.mq.il.uil2.UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
                                  2004-05-14 11:17:36,281 INFO [org.jboss.mq.il.uil2.UILServerILService] Started jboss.mq:service=InvocationLayer,type=UIL2
                                  2004-05-14 11:17:36,281 INFO [org.jboss.mq.server.jmx.Queue.DLQ] Bound to JNDI name: queue/DLQ
                                  2004-05-14 11:17:36,296 INFO [org.jboss.mq.server.jmx.Queue.DLQ] Started jboss.mq.destination:service=Queue,name=DLQ
                                  2004-05-14 11:17:36,328 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Created securityMgr=org.jboss.security.plugins.JaasSecurityManager@6da8eb
                                  2004-05-14 11:17:36,328 INFO [org.jboss.security.plugins.JaasSecurityManagerService] setCachePolicy, c=org.jboss.util.TimedCachePolicy@16d079a
                                  2004-05-14 11:17:36,328 INFO [org.jboss.security.plugins.JaasSecurityManagerService] Added JmsXARealm, org.jboss.security.plugins.SecurityDomainContext@10e468f to map
                                  2004-05-14 11:17:36,343 INFO [org.jboss.resource.adapter.jms.JmsManagedConnectionFactory.JmsXA] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=TxCM,name=JmsXA to JNDI name 'java:/JmsXA'
                                  2004-05-14 11:17:36,343 INFO [org.jboss.resource.connectionmanager.TxConnectionManager] Started jboss.jca:service=TxCM,name=JmsXA
                                  2004-05-14 11:17:36,390 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/transaction-service.xml
                                  2004-05-14 11:17:36,390 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/user-service.xml
                                  2004-05-14 11:17:36,421 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/user-service.xml
                                  2004-05-14 11:17:36,421 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar
                                  2004-05-14 11:17:37,640 INFO [org.jboss.ejb.EjbModule] Deploying CommandType
                                  2004-05-14 11:17:38,171 INFO [org.jboss.ejb.EjbModule] Deploying Command
                                  2004-05-14 11:17:39,906 INFO [org.jboss.ejb.plugins.EntityInstancePool] Started jboss.j2ee:jndiName=CommandType,plugin=pool,service=EJB
                                  2004-05-14 11:17:39,906 INFO [org.jboss.ejb.EntityContainer] Started jboss.j2ee:jndiName=CommandType,service=EJB
                                  2004-05-14 11:17:41,843 ERROR [org.jboss.ejb.EntityContainer] Starting failed
                                  org.jboss.deployment.DeploymentException: Error while creating table COMMAND; - nested throwable: (java.sql.SQLException: Wrong data type: NOT in statement [CREATE TABLE COMMAND ( INTEGER NOT NULL, FK_COMMANDTYPE VARBINARY, CONSTRAINT PK_COMMAND PRIMARY KEY ())])
                                   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232)
                                   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:93)
                                   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.GeneratedMethodAccessor22.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.GeneratedMethodAccessor6.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 $Proxy29.start(Unknown Source)
                                   at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
                                   at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
                                   at sun.reflect.GeneratedMethodAccessor22.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.GeneratedMethodAccessor6.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 $Proxy12.start(Unknown Source)
                                   at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544)
                                   at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
                                   at sun.reflect.GeneratedMethodAccessor20.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 $Proxy6.deploy(Unknown Source)
                                   at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
                                   at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
                                   at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
                                   at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274)
                                   at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
                                   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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
                                   at $Proxy0.start(Unknown Source)
                                   at org.jboss.system.ServiceController.start(ServiceController.java:394)
                                   at sun.reflect.GeneratedMethodAccessor6.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 $Proxy4.start(Unknown Source)
                                   at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
                                   at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589)
                                   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                                   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                                   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 $Proxy5.deploy(Unknown Source)
                                   at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384)
                                   at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
                                   at org.jboss.Main.boot(Main.java:150)
                                   at org.jboss.Main$1.run(Main.java:395)
                                   at java.lang.Thread.run(Thread.java:534)
                                  Caused by: java.sql.SQLException: Wrong data type: NOT in statement [CREATE TABLE COMMAND ( INTEGER NOT NULL, FK_COMMANDTYPE VARBINARY, CONSTRAINT PK_COMMAND PRIMARY KEY ())]
                                   at org.hsqldb.Trace.getError(Unknown Source)
                                   at org.hsqldb.jdbcResultSet.<init>(Unknown Source)
                                   at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
                                   at org.hsqldb.jdbcConnection.execute(Unknown Source)
                                   at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
                                   at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source)
                                   at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:262)
                                   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:219)
                                   ... 87 more
                                  2004-05-14 11:17:41,875 WARN [org.jboss.system.ServiceController] Problem starting service jboss.j2ee:jndiName=Command,service=EJB
                                  org.jboss.deployment.DeploymentException: Error while creating table COMMAND; - nested throwable: (java.sql.SQLException: Wrong data type: NOT in statement [CREATE TABLE COMMAND ( INTEGER NOT NULL, FK_COMMANDTYPE VARBINARY, CONSTRAINT PK_COMMAND PRIMARY KEY ())])
                                   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232)
                                   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:93)
                                   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.GeneratedMethodAccessor22.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.GeneratedMethodAccessor6.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 $Proxy29.start(Unknown Source)
                                   at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
                                   at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
                                   at sun.reflect.GeneratedMethodAccessor22.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.GeneratedMethodAccessor6.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 $Proxy12.start(Unknown Source)
                                   at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544)
                                   at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
                                   at sun.reflect.GeneratedMethodAccessor20.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 $Proxy6.deploy(Unknown Source)
                                   at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
                                   at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
                                   at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
                                   at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274)
                                   at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
                                   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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
                                   at $Proxy0.start(Unknown Source)
                                   at org.jboss.system.ServiceController.start(ServiceController.java:394)
                                   at sun.reflect.GeneratedMethodAccessor6.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 $Proxy4.start(Unknown Source)
                                   at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
                                   at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
                                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589)
                                   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                                   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                                   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 $Proxy5.deploy(Unknown Source)
                                   at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384)
                                   at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
                                   at org.jboss.Main.boot(Main.java:150)
                                   at org.jboss.Main$1.run(Main.java:395)
                                   at java.lang.Thread.run(Thread.java:534)
                                  Caused by: java.sql.SQLException: Wrong data type: NOT in statement [CREATE TABLE COMMAND ( INTEGER NOT NULL, FK_COMMANDTYPE VARBINARY, CONSTRAINT PK_COMMAND PRIMARY KEY ())]
                                   at org.hsqldb.Trace.getError(Unknown Source)
                                   at org.hsqldb.jdbcResultSet.<init>(Unknown Source)
                                   at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
                                   at org.hsqldb.jdbcConnection.execute(Unknown Source)
                                   at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
                                   at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source)
                                   at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:262)
                                   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:219)
                                   ... 87 more
                                  2004-05-14 11:17:41,890 INFO [org.jboss.ejb.EjbModule] Started jboss.j2ee:module=jstockEJB.jar,service=EjbModule
                                  2004-05-14 11:17:41,890 INFO [org.jboss.ejb.EJBDeployer] Deployed: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar
                                  2004-05-14 11:17:42,046 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar
                                  2004-05-14 11:17:42,062 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-console.war/
                                  2004-05-14 11:17:42,234 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] deploy, ctxPath=/jmx-console, warUrl=file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-console.war/
                                  2004-05-14 11:17:42,671 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/jmx-console]: Ajout de certificats -> requête Attribut de Valve (attribute Valve)
                                  2004-05-14 11:17:42,703 WARN [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] Unable to invoke setDelegate on class loader:org.jboss.web.tomcat.tc4.WebCtxLoader$ENCLoader@e3f6d
                                  2004-05-14 11:17:42,703 INFO [org.jboss.web.localhost.Engine] StandardManager[/jmx-console]: Alimentation de la classe du générateur de nombre aléatoire java.security.SecureRandom
                                  2004-05-14 11:17:42,703 INFO [org.jboss.web.localhost.Engine] StandardManager[/jmx-console]: L'alimentation du générateur de nombre aléatoire est terminé
                                  2004-05-14 11:17:42,734 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/jmx-console:default]: Chargement du conteneur (container) de servlet default
                                  2004-05-14 11:17:42,734 INFO [org.jboss.web.localhost.Engine] StandardWrapper[/jmx-console:invoker]: Chargement du conteneur (container) de servlet invoker
                                  2004-05-14 11:17:43,765 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jmx-console.war/
                                  2004-05-14 11:17:43,765 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/management/web-console.war
                                  2004-05-14 11:17:44,265 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService] deploy, ctxPath=/web-console, warUrl=file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/tmp/deploy/tmp30951web-console.war/
                                  2004-05-14 11:17:44,703 INFO [org.jboss.web.localhost.Engine] SingleSignOnContextConfig[/web-console]: Ajout de certificats -> requête Attribut de Val


                                  • 14. Re: SQL error while JBoss try to create the table in my data

                                    It is showing an empty primary key element:

                                    (java.sql.SQLException: Wrong data type: NOT in statement [CREATE TABLE COMMAND ( INTEGER NOT NULL, FK_COMMANDTYPE VARBINARY, CONSTRAINT PK_COMMAND PRIMARY KEY ())])

                                    So like I originally suspected, your primary key declaration in your ejb-jar.xml is not correct. This is also why MySQL fails to properly create a table constraint for you.

                                    1 2 Previous Next