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

Monday, 8 January 2007

Trying to get clustering working with oracle but getting a 'method not found'
exception at startup.  I am suspecting something wrong with the sql statements but am
unable to locate it and would appreciate a second pair of eyes :-)  This is what my file
currently looks like ( I basically took the clustered-mysql file and replaced bigint with
integer, blobs and using raw):

<?xml version="1.0" encoding="UTF-8"?>
  | 
  | <!--
  |      Orcle persistence deployment descriptor.
  | 
  |      $Id: oracle-persistence-service.xml 1766 2006-12-11 22:29:27Z
ovidiu.feodorov(a)jboss.com $
  |  -->
  | 
  | <server>
  | 
  |    <mbean code="org.jboss.messaging.core.plugin.JDBCPersistenceManager"
  |       name="jboss.messaging:service=PersistenceManager"
  |       xmbean-dd="xmdesc/JDBCPersistenceManager-xmbean.xml">      
  |      
<depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
  |       <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
  |       <depends
optional-attribute-name="ChannelMapper">jboss.messaging:service=ChannelMapper</depends>
  |       <attribute name="DataSource">java:/DefaultDS</attribute>
  |       <attribute name="CreateTablesOnStartup">true</attribute>
  |       <attribute name="UsingBatchUpdates">true</attribute>     

  |       <attribute name="SqlProperties"><![CDATA[
  | CREATE_MESSAGE_REFERENCE=CREATE TABLE JMS_MESSAGE_REFERENCE (CHANNELID INTEGER,
MESSAGEID INTEGER, TRANSACTIONID INTEGER, STATE CHAR(1), ORD INTEGER, PAGE_ORD INTEGER,
DELIVERYCOUNT INTEGER, RELIABLE CHAR(1), LOADED CHAR(1), PRIMARY KEY(CHANNELID,
MESSAGEID))
  | CREATE_IDX_MESSAGE_REF_TX=CREATE INDEX JMS_MESSAGE_REF_TX ON JMS_MESSAGE_REFERENCE
(TRANSACTIONID)
  | CREATE_IDX_MESSAGE_REF_ORD=CREATE INDEX JMS_MESSAGE_REF_ORD ON JMS_MESSAGE_REFERENCE
(ORD)
  | CREATE_IDX_MESSAGE_REF_PAGE_ORD=CREATE INDEX JMS_MESSAGE_REF_LOADED ON
JMS_MESSAGE_REFERENCE (PAGE_ORD)
  | CREATE_IDX_MESSAGE_REF_MESSAGEID=CREATE INDEX JMS_MESSAGE_REF_MESSAGEID ON
JMS_MESSAGE_REFERENCE (MESSAGEID)
  | CREATE_IDX_MESSAGE_REF_RELIABLE=CREATE INDEX JMS_MESSAGE_REF_RELIABLE ON
JMS_MESSAGE_REFERENCE (RELIABLE)
  | CREATE_MESSAGE=CREATE TABLE JMS_MESSAGE (MESSAGEID INTEGER, RELIABLE CHAR(1),
EXPIRATION INTEGER, TIMESTAMP INTEGER, PRIORITY INTEGER, COREHEADERS BLOB, PAYLOAD BLOB,
CHANNELCOUNT INTEGER, TYPE INTEGER, JMSTYPE VARCHAR(255), CORRELATIONID VARCHAR(255),
CORRELATIONID_BYTES RAW(254), DESTINATION VARCHAR(255), REPLYTO VARCHAR(255),
JMSPROPERTIES MEDIUMBLOB, PRIMARY KEY (MESSAGEID))
  | CREATE_TRANSACTION=CREATE TABLE JMS_TRANSACTION (TRANSACTIONID INTEGER, BRANCH_QUAL
RAW(254), FORMAT_ID INTEGER, GLOBAL_TXID RAW(254), PRIMARY KEY (TRANSACTIONID))
  | CREATE_COUNTER=CREATE TABLE JMS_COUNTER (NAME VARCHAR(255), NEXT_ID INTEGER, PRIMARY
KEY(NAME))
  | INSERT_MESSAGE_REF=INSERT INTO JMS_MESSAGE_REFERENCE (CHANNELID, MESSAGEID,
TRANSACTIONID, STATE, ORD, PAGE_ORD, DELIVERYCOUNT, RELIABLE) VALUES (?, ?, ?, ?, ?, ?, ?,
?)
  | DELETE_MESSAGE_REF=DELETE FROM JMS_MESSAGE_REFERENCE WHERE MESSAGEID=? AND CHANNELID=?
AND STATE='C'
  | UPDATE_MESSAGE_REF=UPDATE JMS_MESSAGE_REFERENCE SET TRANSACTIONID=?, STATE='-'
WHERE MESSAGEID=? AND CHANNELID=? AND STATE='C'
  | UPDATE_PAGE_ORDER=UPDATE JMS_MESSAGE_REFERENCE SET PAGE_ORD = ? WHERE MESSAGEID=? AND
CHANNELID=?
  | COMMIT_MESSAGE_REF1=UPDATE JMS_MESSAGE_REFERENCE SET STATE='C', TRANSACTIONID
= NULL WHERE TRANSACTIONID=? AND STATE='+'
  | COMMIT_MESSAGE_REF2=DELETE FROM JMS_MESSAGE_REFERENCE WHERE TRANSACTIONID=? AND
STATE='-'
  | ROLLBACK_MESSAGE_REF1=DELETE FROM JMS_MESSAGE_REFERENCE WHERE TRANSACTIONID=? AND
STATE='+'
  | ROLLBACK_MESSAGE_REF2=UPDATE JMS_MESSAGE_REFERENCE SET STATE='C',
TRANSACTIONID = NULL WHERE TRANSACTIONID=? AND STATE='-'
  | LOAD_PAGED_REFS=SELECT MESSAGEID, DELIVERYCOUNT, PAGE_ORD, RELIABLE FROM
JMS_MESSAGE_REFERENCE WHERE CHANNELID = ? AND PAGE_ORD BETWEEN ? AND ? ORDER BY PAGE_ORD
  | LOAD_UNPAGED_REFS=SELECT MESSAGEID, DELIVERYCOUNT, RELIABLE FROM JMS_MESSAGE_REFERENCE
WHERE PAGE_ORD IS NULL and CHANNELID = ? ORDER BY ORD
  | UPDATE_RELIABLE_REFS_NOT_PAGED=UPDATE JMS_MESSAGE_REFERENCE SET PAGE_ORD = NULL WHERE
PAGE_ORD BETWEEN ? AND ? AND CHANNELID=?
  | SELECT_MIN_MAX_PAGE_ORD=SELECT MIN(PAGE_ORD), MAX(PAGE_ORD) FROM JMS_MESSAGE_REFERENCE
WHERE CHANNELID = ?
  | SELECT_EXISTS_REF=SELECT MESSAGEID FROM JMS_MESSAGE_REFERENCE WHERE CHANNELID = ? AND
MESSAGEID = ?
  | UPDATE_DELIVERYCOUNT=UPDATE JMS_MESSAGE_REFERENCE SET DELIVERYCOUNT = ? WHERE
CHANNELID = ? AND MESSAGEID = ?
  | LOAD_MESSAGES=SELECT MESSAGEID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY,
COREHEADERS, PAYLOAD, CHANNELCOUNT, TYPE, JMSTYPE, CORRELATIONID, CORRELATIONID_BYTES,
DESTINATION, REPLYTO, JMSPROPERTIES FROM JMS_MESSAGE
  | INSERT_MESSAGE=INSERT INTO JMS_MESSAGE (MESSAGEID, RELIABLE, EXPIRATION, TIMESTAMP,
PRIORITY, COREHEADERS, PAYLOAD, CHANNELCOUNT, TYPE, JMSTYPE, CORRELATIONID,
CORRELATIONID_BYTES, DESTINATION, REPLYTO, JMSPROPERTIES) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)
  | INC_CHANNELCOUNT=UPDATE JMS_MESSAGE SET CHANNELCOUNT = CHANNELCOUNT + 1 WHERE
MESSAGEID=?
  | DEC_CHANNELCOUNT=UPDATE JMS_MESSAGE SET CHANNELCOUNT = CHANNELCOUNT - 1 WHERE
MESSAGEID=?
  | DELETE_MESSAGE=DELETE FROM JMS_MESSAGE WHERE MESSAGEID=? AND CHANNELCOUNT=0
  | MESSAGEID_COLUMN=MESSAGEID
  | MESSAGE_EXISTS=SELECT MESSAGEID FROM JMS_MESSAGE WHERE MESSAGEID = ? FOR UPDATE
  | INSERT_TRANSACTION=INSERT INTO JMS_TRANSACTION (TRANSACTIONID, BRANCH_QUAL, FORMAT_ID,
GLOBAL_TXID) VALUES(?, ?, ?, ?)
  | DELETE_TRANSACTION=DELETE FROM JMS_TRANSACTION WHERE TRANSACTIONID = ?
  | SELECT_PREPARED_TRANSACTIONS=SELECT TRANSACTIONID, BRANCH_QUAL, FORMAT_ID, GLOBAL_TXID
FROM JMS_TRANSACTION
  | UPDATE_COUNTER=UPDATE JMS_COUNTER SET NEXT_ID = ? WHERE NAME=?
  | SELECT_COUNTER=SELECT NEXT_ID FROM JMS_COUNTER WHERE NAME=? FOR UPDATE
  | INSERT_COUNTER=INSERT INTO JMS_COUNTER (NAME, NEXT_ID) VALUES (?, ?)
  | SELECT_ALL_CHANNELS=SELECT DISTINCT(CHANNELID) FROM JMS_MESSAGE_REFERENCE
  | ]]></attribute>
  |       <attribute name="MaxParams">500</attribute>
  |    </mbean>      
  |       
  |    <mbean
code="org.jboss.messaging.core.plugin.ClusteredPostOfficeService"
  |       name="jboss.messaging:service=PostOffice"
  |       xmbean-dd="xmdesc/ClusteredPostOffice-xmbean.xml">
  |       <depends
optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>
  |      
<depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
  |       <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
  |       <attribute name="PostOfficeName">Clustered
JMS</attribute>
  |       <attribute name="DataSource">java:/DefaultDS</attribute>
  |       <attribute name="CreateTablesOnStartup">true</attribute>
  |       <attribute name="SqlProperties"><![CDATA[
  | CREATE_POSTOFFICE_TABLE=CREATE TABLE JMS_POSTOFFICE (POSTOFFICE_NAME VARCHAR(255),
NODE_ID INTEGER, QUEUE_NAME VARCHAR(1023), COND VARCHAR(1023), SELECTOR VARCHAR(1023),
CHANNEL_ID INTEGER, IS_FAILED_OVER VARCHAR(1))
  | INSERT_BINDING=INSERT INTO JMS_POSTOFFICE (POSTOFFICE_NAME, NODE_ID, QUEUE_NAME, COND,
SELECTOR, CHANNEL_ID, IS_FAILED_OVER) VALUES (?, ?, ?, ?, ?, ?, ?)
  | DELETE_BINDING=DELETE FROM JMS_POSTOFFICE WHERE POSTOFFICE_NAME=? AND NODE_ID=? AND
QUEUE_NAME=?
  | LOAD_BINDINGS=SELECT NODE_ID, QUEUE_NAME, COND, SELECTOR, CHANNEL_ID, IS_FAILED_OVER
FROM JMS_POSTOFFICE WHERE POSTOFFICE_NAME  = ?
  |       ]]></attribute>
  |       <attribute name="GroupName">Queue</attribute>
  |       <attribute name="StateTimeout">5000</attribute>
  |       <attribute name="CastTimeout">5000</attribute>
  |       <attribute name="StatsSendPeriod">10000</attribute>
  |       <attribute
name="MessagePullPolicy">org.jboss.messaging.core.plugin.postoffice.cluster.NullMessagePullPolicy</attribute>
  |       <attribute
name="ClusterRouterFactory">org.jboss.messaging.core.plugin.postoffice.cluster.DefaultRouterFactory</attribute>
  | 
  |       <attribute name="AsyncChannelConfig">
  |          <config>
  |             <UDP mcast_recv_buf_size="500000"
down_thread="false" ip_mcast="true"
mcast_send_buf_size="32000"
  |            mcast_port="45567" ucast_recv_buf_size="500000"
use_incoming_packet_handler="false"
  |            mcast_addr="228.8.8.8"
use_outgoing_packet_handler="true" loopback="true"
ucast_send_buf_size="32000" ip_ttl="32"
bind_addr="127.0.0.1"/>
  |             <AUTOCONF down_thread="false"
up_thread="false"/>
  |             <PING timeout="2000" down_thread="false"
num_initial_members="3" up_thread="false"/>
  |             <MERGE2 max_interval="10000" down_thread="false"
min_interval="5000" up_thread="false"/>
  |             <FD_SOCK down_thread="false"
up_thread="false"/>
  |             <FD timeout="20000" max_tries="3"
down_thread="false" up_thread="false" shun="true"/>      

  |             <VERIFY_SUSPECT timeout="1500" down_thread="false"
up_thread="false"/>
  |             <pbcast.NAKACK max_xmit_size="8192"
down_thread="false" use_mcast_xmit="true" gc_lag="50"
up_thread="false"
  |                         
retransmit_timeout="100,200,600,1200,2400,4800"/>
  |             <UNICAST timeout="1200,2400,3600"
down_thread="false" up_thread="false"/>
  |             <pbcast.STABLE stability_delay="1000"
desired_avg_gossip="20000" down_thread="false" max_bytes="0"
up_thread="false"/>
  |             <FRAG frag_size="8192" down_thread="false"
up_thread="false"/>
  |             <VIEW_SYNC avg_send_interval="60000"
down_thread="false" up_thread="false" />
  |             <pbcast.GMS print_local_addr="true"
join_timeout="3000" down_thread="false"
join_retry_timeout="2000" up_thread="false"
shun="true"/>
  |          </config>
  |       </attribute>
  | 
  |       <attribute name="SyncChannelConfig">
  |          <config>
  |             <UDP mcast_recv_buf_size="500000"
down_thread="false" ip_mcast="true"
mcast_send_buf_size="32000"
  |            mcast_port="45568" ucast_recv_buf_size="500000"
use_incoming_packet_handler="false"
  |            mcast_addr="228.8.8.8"
use_outgoing_packet_handler="true" loopback="true"
ucast_send_buf_size="32000" ip_ttl="32"
bind_addr="127.0.0.1"/>
  |             <AUTOCONF down_thread="false"
up_thread="false"/>
  |             <PING timeout="2000" down_thread="false"
num_initial_members="3" up_thread="false"/>
  |             <MERGE2 max_interval="10000" down_thread="false"
min_interval="5000" up_thread="false"/>
  |             <FD_SOCK down_thread="false"
up_thread="false"/>
  |             <FD timeout="20000" max_tries="3"
down_thread="false" up_thread="false" shun="true"/>      

  |             <VERIFY_SUSPECT timeout="1500" down_thread="false"
up_thread="false"/>
  |             <pbcast.NAKACK max_xmit_size="8192"
down_thread="false" use_mcast_xmit="true" gc_lag="50"
up_thread="false"
  |                         
retransmit_timeout="100,200,600,1200,2400,4800"/>
  |             <UNICAST timeout="1200,2400,3600"
down_thread="false" up_thread="false"/>
  |             <pbcast.STABLE stability_delay="1000"
desired_avg_gossip="20000" down_thread="false" max_bytes="0"
up_thread="false"/>
  |             <FRAG frag_size="8192" down_thread="false"
up_thread="false"/>
  |             <VIEW_SYNC avg_send_interval="60000"
down_thread="false" up_thread="false" />
  |             <pbcast.GMS print_local_addr="true"
join_timeout="3000" down_thread="false"
join_retry_timeout="2000" up_thread="false"
shun="true"/>
  |             <pbcast.STATE_TRANSFER down_thread="false"
up_thread="false"/>
  |          </config>
  |       </attribute>
  |    </mbean>
  | 
  |    <mbean code="org.jboss.jms.server.plugin.JDBCJMSUserManagerService"
  |       name="jboss.messaging:service=JMSUserManager"
  |       xmbean-dd="xmdesc/JMSUserManager-xmbean.xml">
  |      
<depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
  |       <depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
  |       <attribute name="DataSource">java:/DefaultDS</attribute>
  |       <attribute name="CreateTablesOnStartup">true</attribute>
  |       <attribute name="SqlProperties"><![CDATA[
  | CREATE_USER_TABLE=CREATE TABLE JMS_USER (USERID VARCHAR(32) NOT NULL, PASSWD
VARCHAR(32) NOT NULL, CLIENTID VARCHAR(128), PRIMARY KEY(USERID))
  | CREATE_ROLE_TABLE=CREATE TABLE JMS_ROLE (ROLEID VARCHAR(32) NOT NULL, USERID
VARCHAR(32) NOT NULL, PRIMARY KEY(USERID, ROLEID))
  | SELECT_PRECONF_CLIENTID=SELECT CLIENTID FROM JMS_USER WHERE USERID=?
  |       ]]></attribute>
  |    </mbean>
  |    
  | 
  | 
  | </server>

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

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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[JBoss Messaging] - Does anyone have a clustered oracle service xml file?