1 Reply Latest reply on Jan 28, 2005 2:34 AM by yi Booney

    error in configuring jboss for mssql server 2000

    anuradha sadss Newbie

      Hi,
      Im getting this error when I configure jboss for mssql server200.


      MBeanException: org.jboss.mq.SpyJMSException: Error creating connection to the database.; - nested throwable: (org.jboss.util.NestedS
      QLException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Erro
      r establishing socket.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwa
      ble: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)))
      Cause: org.jboss.mq.SpyJMSException: Error creating connection to the database.; - nested throwable: (org.jboss.util.NestedSQLExcepti
      on: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establi
      shing socket.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (jav
      a.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)))
      ObjectName: jboss.mq:service=PersistenceManager
      state: FAILED
      I Depend On: jboss.jca:service=LocalTxCM,name=DefaultDS

      Depends On Me: jboss.mq:service=DestinationManager
      MBeanException: org.jboss.mq.SpyJMSException: Could not get a connection for jdbc2 table construction ; - nested throwable: (org.jbos
      s.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver
      for JDBC]Error establishing socket.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; -
      nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)))
      Cause: org.jboss.mq.SpyJMSException: Could not get a connection for jdbc2 table construction ; - nested throwable: (org.jboss.util.Ne
      stedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC
      ]Error establishing socket.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested t
      hrowable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)))

      10:13:30,984 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
      10:13:33,277 INFO [ChannelSocket] JK2: ajp13 listening on /0.0.0.0:8009
      10:13:33,297 INFO [JkMain] Jk running ID=0 time=0/190 config=null
      10:13:33,377 INFO [Server] JBoss (MX MicroKernel) [3.2.6 (build: CVSTag=JBoss_3_2_6 date=200410140106)] Started in 59s:386ms
      10:18:15,072 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=chnmkt20//1, BranchQual=] timed out.
      status=STATUS_ACTIVE