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

    JBoss 5.1.0.GA problems with MS SQL 2008

    max010

      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

        • 1. Re: JBoss 5.1.0.GA problems with MS SQL 2008
          sapozpa

          Hi

           

          I am also running at home a small app thats querying against ms sql 2008 and it runs fine on jboss 5.1.0.GA. I didn't have to do anything with hsgldb. I use the latest jtds driver which is jtds1.2.5.jar. Also I didn't have to set transaction-isolation, although I don't think thats your problem. My url is somewhat different too:

           

          jdbc:jtds:sqlserver://localhost:1433;DatabaseName=TestDB;tds=8.0;lastupdatecount=false

          • 2. Re: JBoss 5.1.0.GA problems with MS SQL 2008
            peterj

            Two things:

             

            1) DEFAULTDS != DefaultDS (JNDI names are case sensitive). I recommend using some other name in company-ds.xml.

             

            2) Do not remove hsqldb-ds.xml unless you are prepared to convert every service that uses DefaultDS it to the other database. For most of the services this conversion is easy, for JMS it is a little harder.

            • 3. Re: JBoss 5.1.0.GA problems with MS SQL 2008
              max010

              Thanks for your help.

               

              We have decided to use the hypersonic configuration instead of the Ms SQL.

              With hypersonic everything works.

               

              Thanks again.