[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [xmlblaster] JdbcQueuePlugin won't load



Ops, I didn't read this before answering you the other email. I will look at the readme file and fix it adequately

Michele


Michael Atighetchi wrote:
I noticed a warning about useTopic=false (although I don't set it that
way in the property file). After looking at the template property
files supplied with xmlblaster, I added the following entries

persistence/defaultPlugin=JDBC,1.0
queue/defaultPlugin=JDBC,1.0
useTopicStore=true

This seems to tell xmlblaster to use the database for storing messages
(at least I'm getting sql exceptions that way ... I'm sure I can fix
those).

So, I suggest you add to the documentation in xmlBlaster/src/java/org/xmlBlaster/util/queue/jdbc/README
http://www.xmlblaster.org/xmlBlaster/doc/requirements/queue.jdbc.postgres.html
http://www.xmlblaster.org/xmlBlaster/doc/requirements/queue.jdbc.oracle.html
http://www.xmlblaster.org/xmlBlaster/doc/requirements/queue.jdbc.html



that these flags have to be set.

Michael


On Tue, Feb 25, 2003 at 06:46:02PM -0500, Michael Atighetchi wrote:

I have a xmlblaster scenario with 2 clients that communicate with
eatch other via talking to a xmlblaster slave instance (which in turn
talks to a master).

I'd like to change the master so that it stores messages in a mysql
database instead of keeping them in RAM. First, I changed the qos key
on publishing messages to "<qos> <persistent /> </qos>". I also added the
following line to the xmlblaster.properties file of the master:

ProtocolPlugin[JDBC][1.0]=org.xmlBlaster.protocol.jdbc.JdbcDriver
CbProtocolPlugin[JDBC][1.0]=org.xmlBlaster.protocol.jdbc.CallbackJdbcDriver
QueuePlugin[JDBC][1.0]=org.xmlBlaster.util.queue.jdbc.JdbcQueuePlugin
JdbcDriver.drivers=org.gjt.mm.mysql.Driver
queue.persistent.url=<...>
queue.persistent.user=<...>
queue.persistent.password=<...>
cb.queue.persistent.url=<...>
cb.queue.persistent.user=<...>
cb.queue.persistent.password=<...>

cb.queue.persistent.connectionPoolSize=3
cb.queue.persistent.connectionBusyTimeout=90000
cb.queue.persistent.maxWaitingThreads=300
cb.queue.defaultPlugin=RAM,1.0
cb.queue.persistent.tablePrefix=xmlBlaster
cb.queue.persistent.tableAllocationIncrement=2

NOTE: assume reasonable entries for <...>


Upon starting up the master node, I see that the JdbcDriver initializes correctly: [Feb 25, 2003 6:31:08 PM INFO  JdbcDriver-/node/psq1] Started successfully JDBC driver with loginName=__sys__jdbc

However, I don't see any printout for the JdbcQueuePlugin, but lots of
printout for RamQueuePlugin.

Upon starting up the clients, messages are still kept in RAM in the
master, and not put into the mysql database.

How can I change the configuration to use jdbc for storing messages ?

Michael









--
Michele Laghi
mailto:laghi at swissinfo.org
tel. +46 8 7492952 / mob. +46 70 4103964
http://www.geocities.com/laghi2000
http://www.xmlBlaster.org