XmlBlaster Logo

REQUIREMENT

queue.jdbc.db2

XmlBlaster Logo


Type NEW
Priority LOW
Status INWORK
Topic XmlBlaster queuing facility with DB2 backend store.
Des
cription

DB2 is available on http://www.ibm.com where you can find all necessary information and instructions on how to make DB2 run.

xmlBlaster works fine with DB2, but extensive tests have not been made.

Example
Java 
#Add to CLASSPATH 
# /opt/ibm/db2/V9.7/java/db2jcc.jar
# /opt/ibm/db2/V9.7/java/db2jcc_license_cu.jar

# DB2 express C 9.7, using com.ibm.db2.jcc.DB2Driver
# db2stop
# db2start
# db2 create database xmlblast
# db2 connect to xmlblast user db2inst1
# db2 get dbm cfg
# db2 list applications
# The Port is typically something like 50000 or 50003
JdbcStorage[DB2]=org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin,\
            url=jdbc:db2://localhost:50001/xmlblast,\
            user=db2inst1,\
            password=secret,\
            connectionPoolSize=1,\
            connectionBusyTimeout=90000,\
            maxWaitingThreads=300,\
            tableNamePrefix=XB_,\
            entriesTableName=ENTRIES,\
            dbAdmin=true
Configure

These parameters allow to configure a cache queue running with postgres

Property Default Description Hot Impl
QueuePlugin[CACHE][1.0] org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin specifies the cache implementing class to be used yes yes
queue/maxEntries 1000 specifies the maximum number of entries allowed in this queue yes yes
queue/maxBytes 10485760 (10MB) specifies the maximum total size allowed in this queue yes yes
queue/persistent/url jdbc:db2://linux:50001/xmlblast the url which specifies where to find the DB. yes yes
queue/persistent/user xmlblaster The db user under which to run yes yes
queue/persistent/password secret The password used together with the user 'xmlblaster' yes yes
Additionally the configuration parameters for the ram queue and the jdbc queue must be defined.

NOTE: Configuration parameters are specified on command line (-someValue 17) or in the xmlBlaster.properties file (someValue=17). See requirement "util.property" for details.
Columns named Impl tells you if the feature is implemented.
Columns named Hot tells you if the configuration is changeable in hot operation.

See API org.xmlBlaster.util.queue.I_Queue
See API org.xmlBlaster.util.queue.jdbc.CacheQueuePlugin
See API org.xmlBlaster.util.queue.QueuePluginManager
See API org.xmlBlaster.util.queue.I_QueueEntry
See API org.xmlBlaster.util.qos.storage.QueuePropertyBase
See API org.xmlBlaster.util.I_Plugin
See API org.xmlBlaster.util.Global
See REQ queue
See TEST org.xmlBlaster.test.classtest.queue.I_QueueTest
See TEST org.xmlBlaster.test.classtest.queue.JdbcQueueTest
See TEST org.xmlBlaster.test.classtest.queue.CacheQueueTest

This page is generated from the requirement XML file xmlBlaster/doc/requirements/queue.jdbc.db2.xml

Back to overview