A.5.4. "Invalid object name 'JMS_SUBSCRIPTIONS' Exception

起動時に 例A.20「JMS_SUBSCRIPTIONS Exception」 にあるような例外を受け取る場合、例A.21「SelectMethod の指定」 に記載の接続 URL にてSelectMethod を指定します。

例A.20 JMS_SUBSCRIPTIONS Exception

          17:17:57,167 WARN  [ServiceController] Problem starting service jboss.mq.destination:name=testTopic,service=Topic
          org.jboss.mq.SpyJMSException: Error getting durable subscriptions for topic TOPIC.testTopic; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'JMS_SUBSCRIPTIONS'.)
          at org.jboss.mq.sm.jdbc.JDBCStateManager.getDurableSubscriptionIdsForTopic(JDBCStateManager.java:290)
          at org.jboss.mq.server.JMSDestinationManager.addDestination(JMSDestinationManager.java:656)

例A.21 SelectMethod の指定

          <connection-url>jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=jboss</connection-url>