0 Replies Latest reply on Jan 12, 2006 4:17 AM by murthy cvrs

    Jboss4.0.2-MSsql2000-Jtds1.2 driver Problem

    murthy cvrs Newbie

      Hi,

      I have setup using JDK1.5, Jboss-4.0.2,MsSql2000,jtds1.2 and started the server.
      I have the below errors

      --------------------------------------------------------------------------------------
      2006-01-12 14:41:55,437 INFO [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MSSQLDS to JNDI name 'java:MSSQLDS'
      2006-01-12 14:41:55,437 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Started jboss.jca:service=DataSourceBinding,name=MSSQLDS
      2006-01-12 14:41:55,437 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.jca:service=DataSourceBinding,name=MSSQLDS dependent components: [ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
      State: CREATED
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=MSSQLDS
      , ObjectName: jboss.mq:service=PersistenceManager
      State: CREATED
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=MSSQLDS
      Depends On Me:
      jboss.mq:service=DestinationManager
      ]
      2006-01-12 14:41:55,437 DEBUG [org.jboss.system.ServiceController] starting service jboss.ejb:service=EJBTimerService,persistencePolicy=database
      2006-01-12 14:41:55,437 DEBUG [org.jboss.ejb.txtimer.DatabasePersistencePolicy] Starting jboss.ejb:service=EJBTimerService,persistencePolicy=database

      2006-01-12 14:41:55,452 ERROR [org.jboss.ejb.txtimer.DatabasePersistencePolicy] Starting failed jboss.ejb:service=EJBTimerService,persistencePolicy=database
      java.lang.IllegalStateException: Cannot find datasource meta data: jboss.jdbc:datasource=MSSQLDS,service=metadata

      .................................

      2006-01-12 14:41:55,624 WARN [org.jboss.system.ServiceController] Problem starting service jboss.ejb:service=EJBTimerService,persistencePolicy=database
      java.lang.IllegalStateException: Cannot find datasource meta data: jboss.jdbc:datasource=MSSQLDS,service=metadata
      .............................

      2006-01-12 14:42:01,968 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Could not create table with SQL: CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB IMAGE, PRIMARY KEY (MESSAGEID, DESTINATION))
      java.sql.SQLException: There is already an object named 'JMS_MESSAGES' in the database. ....................................

      2006-01-12 14:42:01,984 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Could not create table with SQL: CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER, PRIMARY KEY (TXID) )
      java.sql.SQLException: There is already an object named 'JMS_TRANSACTIONS' in the database............................

      --- MBeans waiting for other MBeans ---
      ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
      State: FAILED
      Reason: java.lang.IllegalStateException: Cannot find datasource meta data: jbo
      ss.jdbc:datasource=MSSQLDS,service=metadata
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=MSSQLDS

      ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=Invoker
      jboss.web:service=WebServer

      ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
      State: CONFIGURED
      I Depend On:
      jboss:service=TransactionManager
      jboss.jca:service=DataSourceBinding,name=DefaultDS

      ObjectName: jboss.mq.destination:service=Topic,name=testTopic
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq.destination:service=Queue,name=testQueue
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq.destination:service=Queue,name=A
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq.destination:service=Queue,name=B
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq.destination:service=Queue,name=C
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq.destination:service=Queue,name=D
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq.destination:service=Queue,name=ex
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq:service=Invoker
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=TracingInterceptor
      Depends On Me:
      jboss.mq:service=InvocationLayer,type=HTTP
      jboss.mq:service=InvocationLayer,type=JVM
      jboss.mq:service=InvocationLayer,type=UIL2

      ObjectName: jboss.mq:service=TracingInterceptor
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=SecurityManager
      Depends On Me:
      jboss.mq:service=Invoker

      ObjectName: jboss.mq:service=SecurityManager
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      Depends On Me:
      jboss.mq.destination:service=Topic,name=testTopic
      jboss.mq.destination:service=Topic,name=securedTopic
      jboss.mq.destination:service=Topic,name=testDurableTopic
      jboss.mq.destination:service=Queue,name=testQueue
      jboss.mq:service=TracingInterceptor
      jboss.mq.destination:service=Queue,name=DLQ

      ObjectName: jboss.mq.destination:service=Queue,name=DLQ
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq:service=InvocationLayer,type=JVM
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=Invoker

      ObjectName: jboss.mq:service=DestinationManager
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=MessageCache
      jboss.mq:service=PersistenceManager
      jboss.mq:service=StateManager
      Depends On Me:
      jboss.mq.destination:service=Topic,name=testTopic
      jboss.mq.destination:service=Topic,name=securedTopic
      jboss.mq.destination:service=Topic,name=testDurableTopic
      jboss.mq.destination:service=Queue,name=testQueue
      jboss.mq.destination:service=Queue,name=A
      jboss.mq.destination:service=Queue,name=B
      jboss.mq.destination:service=Queue,name=C
      jboss.mq.destination:service=Queue,name=D
      jboss.mq.destination:service=Queue,name=ex
      jboss.mq:service=SecurityManager
      jboss.mq.destination:service=Queue,name=DLQ

      ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=Invoker

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
      State: FAILED
      Reason: java.lang.IllegalStateException: Cannot find datasource meta data: jbo
      ss.jdbc:datasource=MSSQLDS,service=metadata
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=MSSQLDS

      ObjectName: jboss.mq:service=StateManager
      State: NOTYETINSTALLED
      Depends On Me:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
      State: NOTYETINSTALLED
      Depends On Me:
      jboss:service=KeyGeneratorFactory,type=HiLo

      14:42:02,780 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
      14:42:02,890 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
      14:42:02,905 INFO [JkMain] Jk running ID=0 time=0/46 config=null
      14:42:02,921 INFO [Server] JBoss (MX MicroKernel) [4.0.2 (build: CVSTag=JBoss_4_0_2 date=200505022023)] Started in 23s:516ms

      --------------------------------------------------------------------------------------

      I checked the database and found that there aren't any tables created by Jboss in the database.

      An early reply is deeply appreciated.

      Thanx n Rgds