[jboss-user] [JBoss Messaging] - Re: Does anyone have a clustered oracle service xml file?

[batter]

Well I got it almost up and running.  The messaging system comes up and by the output it looks like queues and topics are created:

22:13:36,145 INFO  [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
  | 22:13:37,536 INFO  [ServerPeer] JBoss Messaging 1.2.0.Beta1 server [1] started
  | 22:13:38,031 INFO  [STDOUT]
  | -------------------------------------------------------
  | GMS: address is 127.0.0.1:2281
  | -------------------------------------------------------
  | 22:13:40,072 INFO  [DefaultClusteredPostOffice] ClusteredPostOffice[1:Clustered JMS:127.0.0.1:2281] got new view: [127.0.0.1:2281|0] [127.0.0.1:2281]
  | 22:13:40,087 INFO  [STDOUT]
  | -------------------------------------------------------
  | GMS: address is 127.0.0.1:2284
  | -------------------------------------------------------
  | 22:13:42,113 INFO  [DefaultPostOffice] PostOffice Clustered JMS nodeId=1 condition=queue.DLQ queueName=DLQ channelId=0 selector=null
  | 22:13:42,128 INFO  [DefaultPostOffice] PostOffice Clustered JMS nodeId=1 condition=queue.testQueue queueName=testQueue channelId=1 selector=null
  | 22:13:42,128 INFO  [DefaultPostOffice] PostOffice Clustered JMS nodeId=1 condition=queue.A queueName=A channelId=2 selector=null
  | 22:13:42,128 INFO  [DefaultPostOffice] PostOffice Clustered JMS nodeId=1 condition=queue.B queueName=B channelId=3 selector=null
  | 22:13:42,128 INFO  [DefaultPostOffice] PostOffice Clustered JMS nodeId=1 condition=queue.C queueName=C channelId=4 selector=null
  | 22:13:42,128 INFO  [DefaultPostOffice] PostOffice Clustered JMS nodeId=1 condition=queue.D queueName=D channelId=5 selector=null
  | 22:13:42,144 INFO  [DefaultPostOffice] PostOffice Clustered JMS nodeId=1 condition=queue.ex queueName=ex channelId=6 selector=null
  | 22:13:42,144 INFO  [DefaultPostOffice] PostOffice Clustered JMS nodeId=1 condition=queue.testDistributedQueue queueName=testDistributedQueue channelId=7 selec
  | tor=null
  | 22:13:42,577 INFO  [ConnectionFactory] Connector socket://15.2.119.192:4457 has leasing enabled, lease period 10000 milliseconds
  | 22:13:42,577 INFO  [ConnectionFactory] [/ConnectionFactory, /XAConnectionFactory, java:/ConnectionFactory, java:/XAConnectionFactory] deployed
  | 22:13:42,592 INFO  [PagingChannelSupport] Channel 0 loading 0 references
  | 22:13:42,592 INFO  [QueueService] Queue[/queue/DLQ] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,592 INFO  [TopicService] Topic[/topic/testTopic] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,592 INFO  [TopicService] Topic[/topic/securedTopic] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,592 INFO  [TopicService] Topic[/topic/testDurableTopic] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,607 INFO  [PagingChannelSupport] Channel 1 loading 0 references
  | 22:13:42,607 INFO  [QueueService] Queue[/queue/testQueue] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,607 INFO  [PagingChannelSupport] Channel 2 loading 0 references
  | 22:13:42,607 INFO  [QueueService] Queue[/queue/A] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,623 INFO  [PagingChannelSupport] Channel 3 loading 0 references
  | 22:13:42,623 INFO  [QueueService] Queue[/queue/B] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,623 INFO  [PagingChannelSupport] Channel 4 loading 0 references
  | 22:13:42,638 INFO  [QueueService] Queue[/queue/C] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,638 INFO  [PagingChannelSupport] Channel 5 loading 0 references
  | 22:13:42,638 INFO  [QueueService] Queue[/queue/D] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,638 INFO  [PagingChannelSupport] Channel 6 loading 0 references
  | 22:13:42,654 INFO  [QueueService] Queue[/queue/ex] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,654 INFO  [PagingChannelSupport] Channel 7 loading 0 references
  | 22:13:42,654 INFO  [QueueService] Queue[/queue/testDistributedQueue] started, fullSize=75000, pageSize=2000, downCacheSize=2000
  | 22:13:42,654 INFO  [TopicService] Topic[/topic/testDistributedTopic] started, fullSize=75000, pageSize=2000, downCacheSize=2000

but the EJB3Timerservice fails (I selected clustered EJB3 when installing jboss):

22:13:42,731 WARN  [ServiceController] Problem starting service jboss.ejb:service=EJBTimerService,persistencePolicy=database
  | java.lang.IllegalStateException: Cannot find datasource meta data: jboss.jdbc:datasource=DefaultDS,service=metadata

I will try and figure out tomorrow what to hack where :-)

The way I got here was using the clustered mysql config file as starting point, installed mysql and successfully ran it up against that DB, then I went back and  'fixed' the sql so it would work with oracle.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3999327#3999327

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3999327