7 Replies Latest reply on Jan 9, 2007 12:22 AM by Bas Ven

    Does anyone have a clustered oracle service xml file?

    Bas Ven Newbie

      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@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>


        • 1. Re: Does anyone have a clustered oracle service xml file?
          Bas Ven Newbie

          PS: somewhere in there is still a MEDIUMBLOB entry that was changed to BLOB in my file. I assumed the ds file to be named oracle-ds.xml in placed it in the deploy directory (and removed the mysql-ds.xml one).

          • 2. Re: Does anyone have a clustered oracle service xml file?
            Tim Fox Master

            We should shortly (probably sometime in the next 2 weeks) have a working Oracle pm config.

            Right now we only have a mysql config.

            I am loathed to do one right now since the schema is still subject to change for a while yet, and we don't want to test etc and then find out we have to do it all over again.

            • 3. Re: Does anyone have a clustered oracle service xml file?
              Bas Ven Newbie

              I noticed a bunch of definitions were missing from the oracle file (see below) but still the same error. Unfortunately turning on logging doesn't help :-(
              Will see what to do next.


              CREATE_IDX_MESSAGE_REF_PAGE_ORD
              UPDATE_PAGE_ORDER
              LOAD_PAGED_REFS
              LOAD_UNPAGED_REFS
              UPDATE_RELIABLE_REFS_NOT_PAGED
              SELECT_MIN_MAX_PAGE_ORD
              SELECT_EXISTS_REF
              INC_CHANNELCOUNT
              DEC_CHANNELCOUNT
              MESSAGE_EXISTS



              • 4. Re: Does anyone have a clustered oracle service xml file?
                Tim Fox Master

                The only working config we currently have is MySQL.

                I can guarantee the others won't work and probably shouldn't be in SVN.

                We have deliberately done it this way, since it is a pain having to keep them all up to date during the development process.

                Once we are code complete, we'll convert the working mysql config into oracle, postgressql, sybase, etc configs. This is pretty easy, but as I say, we don't want to do it now since the schema is still subject to change.

                • 5. Re: Does anyone have a clustered oracle service xml file?
                  Bas Ven Newbie

                   

                  "timfox" wrote:
                  The only working config we currently have is MySQL.

                  I can guarantee the others won't work and probably shouldn't be in SVN.

                  We have deliberately done it this way, since it is a pain having to keep them all up to date during the development process.

                  Once we are code complete, we'll convert the working mysql config into oracle, postgressql, sybase, etc configs. This is pretty easy, but as I say, we don't want to do it now since the schema is still subject to change.


                  Thanks Tim, makes sense. Any idea when code complete can be expected? I need to get my team moving here and discuss if we want to spend time to pull in mysql into our product installation or get MQ working in a clustered environment for the time being.



                  • 6. Re: Does anyone have a clustered oracle service xml file?
                    Tim Fox Master

                    Right now, we're looking at code complete by the end of the month.

                    The idea is that the February will be spent testing and stressing the system, so we only want to apply fixes and optimisations in that month.

                    • 7. Re: Does anyone have a clustered oracle service xml file?
                      Bas Ven Newbie

                      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.