3 Replies Latest reply on Aug 18, 2010 7:10 PM by M Mudu

    JBoss 5.1.0.GA problems with MS SQL 2008

    M Mudu Newbie

      Hi there,

       

      We have succesfully deployed and tested an application where we use MYSQL server.

      We are trying to do the same with MS SQL 2008 but we are getting some deployments errors.

       

      This is what we have done:

       

      1. Removed hsqldb-ds.xml from the deploy folder and the relevant .jar file from the lib.

       

      2. Configured a new Datasource in our company-ds.xml file in the server/default/deploy.

       

      {code:xml}

       

      <local-tx-datasource>

      <jndi-name>DEFAULTDS</jndi-name>

      <connection-url>jdbc:jtds:sqlserver://localhost:1433/company</connection-url>

      <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

      <user-name>max</user-name>

      <password>max</password>

       

      <transaction-isolation>TRANSACTION_READ_UNCOMMITTED</transaction-isolation>

       

      <new-connection-sql>SELECT count(*) FROM system_keys</new-connection-sql>

      <check-valid-connection-sql>SELECT count(*) FROM system_keys</check-valid-connection-sql>

       

      </local-tx-datasource>

       

      {code}

       

      3. Added the drivers to be used with MS SQL 2008 jtds-1.2.2.jar to the server/default/lib

       

      4. Removed the hsqldb-persistence-service.xml from the server/default/deploy and added the mssql-persistence-service.xml

       

      5. In the persistence.xml we changed the Hibernate dialect from

       

      <property name="hibernate.dialect" value="org.hibernate.dialect.MYSQLServerDialect"/>

       

      to

       

      <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>

       

      Here below is the errors we see in our log:

       

      {quote}

      Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

      DEPLOYMENTS MISSING DEPENDENCIES:
        Deployment "JBossTimerServiceFactory" is missing the following dependencies:
          Dependency "jboss.ejb:service=EJBTimerService" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.ejb:persistencePolicy=database,service=EJBTimerService" is missing the following dependencies:
          Dependency "jboss.jdbc:datasource=DefaultDS,service=metadata" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jdbc:datasource=DefaultDS,service=metadata' **")
          Dependency "jboss.jca:name=DefaultDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **")
        Deployment "jboss.ejb:service=EJBTimerService" is missing the following dependencies:
          Dependency "jboss.ejb:persistencePolicy=database,service=EJBTimerService" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AccountBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AccountBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AccountBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AccountBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ApplicationConfigurationBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ApplicationConfigurationBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ApplicationConfigurationBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ApplicationConfigurationBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/AuthorityService/local-com.maxsystems.company.ejb.authority.AuthorityServiceLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewBean/local-com.maxsystems.company.ejb.view.ObjectViewLocal' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityService,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityService,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityService,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityService,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewBean/local-com.maxsystems.company.ejb.view.ObjectViewLocal' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ClearDataBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ClearDataBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ClearDataBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ClearDataBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=CollectionBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=CollectionBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=CollectionBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=CollectionBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=DirectoryBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=DirectoryBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=DirectoryBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=DirectoryBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=HighlightsBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=HighlightsBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=HighlightsBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=HighlightsBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImportQueueMDB,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImportQueueMDB,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/ImporterBean/local-com.maxsystems.company.ejb.importer.ImporterLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImportQueueMDB,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImportQueueMDB,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/ImporterService/local-com.maxsystems.company.ejb.importer.ImporterServiceLocal' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/ImporterService/local-com.maxsystems.company.ejb.importer.ImporterServiceLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/AuthorityBean/local-com.maxsystems.company.ejb.authority.AuthorityLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/IndexHelper/local-com.maxsystems.company.ejb.indexing.IndexHelperLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterService,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterService,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/IndexService/local-com.maxsystems.company.ejb.indexing.IndexServiceLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexHelper,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexHelper,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/IndexService/local-com.maxsystems.company.ejb.indexing.IndexServiceLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexHelper,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexHelper,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexHelper,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexSearchBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexSearchBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexSearchBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexSearchBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/PersonViewBean/local-com.maxsystems.company.ejb.view.PersonViewLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexSearchBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewBean/local-com.maxsystems.company.ejb.view.ObjectViewLocal' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexSearchBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexSearchBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexService,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexService,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexService,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexerBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexerBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexerBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexerBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexerBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=MediaViewBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=MediaViewBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=MediaViewBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=MediaViewBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/IndexHelper/local-com.maxsystems.company.ejb.indexing.IndexHelperLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewHelperBean/local-com.maxsystems.company.ejb.view.ObjectViewHelperLocal' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewHelperBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewHelperBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewHelperBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewHelperBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=PersonViewBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=PersonViewBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=PersonViewBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=PersonViewBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SessionLoggerBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SessionLoggerBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SessionLoggerBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SessionLoggerBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=StatisticsBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=StatisticsBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=StatisticsBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=StatisticsBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SystemKeysBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SystemKeysBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SystemKeysBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SystemKeysBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewContentBean,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewContentBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewBean/local-com.maxsystems.company.ejb.view.ObjectViewLocal' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewContentBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
          Dependency "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewContentBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:company-2.0-max/ViewBean/local-com.maxsystems.company.ejb.view.ViewLocal' **")
        Deployment "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewContentBean,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewContentBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3" is missing the following dependencies:
          Dependency "<UNKNOWN jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView' **")
          Dependency "<UNKNOWN jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **")
        Deployment "jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3_endpoint" is missing the following dependencies:
          Dependency "jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall")
        Deployment "jboss.jca:name=JmsXA,service=ConnectionFactoryBinding" is missing the following dependencies:
          Dependency "jboss.jca:name=JmsXA,service=TxCM" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.jca:name=JmsXA,service=ManagedConnectionFactory" is missing the following dependencies:
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.jca:name=JmsXA,service=ManagedConnectionPool" is missing the following dependencies:
          Dependency "jboss.jca:name=JmsXA,service=ManagedConnectionFactory" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.jca:name=JmsXA,service=TxCM" is missing the following dependencies:
          Dependency "jboss.jca:name=JmsXA,service=ManagedConnectionPool" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory" is missing the following dependencies:
          Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured")
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" is missing the following dependencies:
          Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured")
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.messaging.connectionfactory:service=ConnectionFactory" is missing the following dependencies:
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
          Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.messaging.destination:name=DLQ,service=Queue" is missing the following dependencies:
          Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured")
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.messaging.destination:name=ExpiryQueue,service=Queue" is missing the following dependencies:
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
          Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.messaging.destination:name=ImportStartTopic,service=Topic" is missing the following dependencies:
          Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured")
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.messaging.destination:name=ImporterQueue,service=Queue" is missing the following dependencies:
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
          Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.messaging:service=JMSUserManager" is missing the following dependencies:
          Dependency "jboss.jca:name=companyDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=companyDS,service=DataSourceBinding' **")
        Deployment "jboss.messaging:service=PersistenceManager" is missing the following dependencies:
          Dependency "jboss.jca:name=companyDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=companyDS,service=DataSourceBinding' **")
        Deployment "jboss.messaging:service=PostOffice" is missing the following dependencies:
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
          Dependency "jboss.jca:name=companyDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=companyDS,service=DataSourceBinding' **")
        Deployment "jboss.messaging:service=ServerPeer" is missing the following dependencies:
          Dependency "jboss.messaging:service=PersistenceManager" (should be in state "Create", but is actually in state "Configured")
          Dependency "jboss.messaging:service=JMSUserManager" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss.mq:service=DestinationManager" is missing the following dependencies:
          Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
        Deployment "jboss:service=KeyGeneratorFactory,type=HiLo" is missing the following dependencies:
          Dependency "jboss.jca:name=DefaultDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **")

      DEPLOYMENTS IN ERROR:
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewHelperBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=StatisticsBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterService,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImporterBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jndi:company-2.0-max/ImporterService/local-com.maxsystems.company.ejb.importer.ImporterServiceLocal' **, ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/IndexHelper/local-com.maxsystems.company.ejb.indexing.IndexHelperLocal' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/AuthorityBean/local-com.maxsystems.company.ejb.authority.AuthorityLocal' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ObjectViewBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/IndexHelper/local-com.maxsystems.company.ejb.indexing.IndexHelperLocal' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewHelperBean/local-com.maxsystems.company.ejb.view.ObjectViewHelperLocal' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=MediaViewBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ViewContentBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jndi:company-2.0-max/ViewBean/local-com.maxsystems.company.ejb.view.ViewLocal' **, ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewBean/local-com.maxsystems.company.ejb.view.ObjectViewLocal' **
        Deployment "jboss.jca:name=companyDS,service=DataSourceBinding" is in error due to the following reason(s): ** NOT FOUND Depends on 'jboss.jca:name=companyDS,service=DataSourceBinding' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SessionLoggerBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityService,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewBean/local-com.maxsystems.company.ejb.view.ObjectViewLocal' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=CollectionBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexerBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ImportQueueMDB,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jndi:company-2.0-max/ImporterService/local-com.maxsystems.company.ejb.importer.ImporterServiceLocal' **, ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/ImporterBean/local-com.maxsystems.company.ejb.importer.ImporterLocal' **
        Deployment "<UNKNOWN jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexService,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **
        Deployment "jboss.jca:name=DefaultDS,service=DataSourceBinding" is in error due to the following reason(s): ** NOT FOUND Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **
        Deployment "jboss.jdbc:datasource=DefaultDS,service=metadata" is in error due to the following reason(s): ** NOT FOUND Depends on 'jboss.jdbc:datasource=DefaultDS,service=metadata' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=DirectoryBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexHelper,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jndi:company-2.0-max/IndexService/local-com.maxsystems.company.ejb.indexing.IndexServiceLocal' **, ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AccountBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexSearchBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewBean/local-com.maxsystems.company.ejb.view.ObjectViewLocal' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/PersonViewBean/local-com.maxsystems.company.ejb.view.PersonViewLocal' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ApplicationConfigurationBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=IndexBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jndi:company-2.0-max/IndexService/local-com.maxsystems.company.ejb.indexing.IndexServiceLocal' **, ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/SystemKeysBean/local-com.maxsystems.company.ejb.systemkeys.SystemKeysLocal' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=SystemKeysBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=ClearDataBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView' **, ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=PersonViewBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=HighlightsBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **
        Deployment "<UNKNOWN jboss.j2ee:ear=company-2.0-max.ear,jar=company-ejb.jar,name=AuthorityBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jndi:company-2.0-max/AuthorityService/local-com.maxsystems.company.ejb.authority.AuthorityServiceLocal' **, ** UNRESOLVED Demands 'jboss.ejb:service=EJBTimerService' **, ** UNRESOLVED Demands 'jndi:company-2.0-max/ObjectViewBean/local-com.maxsystems.company.ejb.view.ObjectViewLocal' **

       

      {quote}

       

       

      Has anyone configured JBoss to use MS SQL 2008?  If so what steps did you follow?

       

       

      Thanks in advance,

       

      Max