activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Strachan" <james.strac...@gmail.com>
Subject Re: JDBC Master-Slave doesn' work with DB2
Date Thu, 08 Mar 2007 08:26:57 GMT
On 3/8/07, James Strachan <james.strachan@gmail.com> wrote:
> We've never tested JDBC Master-Slave with DB2. I suspect that there
> needs to be some work on the SQL required for DB2.
>
> I've raised a JIRA to track this
> http://issues.apache.org/activemq/browse/AMQ-1193

I've just fixed this in trunk. I wonder do you fancy a local build to
see if it fixes your issue?
http://activemq.apache.org/building.html

Or try tomorrow's 4.2-SNAPSHOT distro

James

>
> On 2/28/07, Matías Cobiella <matiascobiella@yahoo.com> wrote:
> >
> > JDBC Master-Slave doesn' work with DB2
> >
> >
> > I have two brokers in a JDBC MASTER-SLAVE configuration.
> >
> > When BrokerA starts it becomes the MASTER:
> >
> > INFO  BrokerService                  - Using Persistence Adapter:
> > JDBCPersistenceAdaptor(org.apache.commons.dbcp.BasicDataSource
> > INFO  BrokerService                  - ActiveMQ null JMS Message Broker
> > (MASTER) is starting
> > INFO  BrokerService                  - For help or more information please
> > see: http://incubator.apache.org/activemq/
> > INFO  ManagementContext              - JMX consoles can connect to
> > service:jmx:rmi:///jndi/rmi://localhost:1299/jmxrmi
> > INFO  JDBCPersistenceAdapter         - Database driver recognized:
> > [ibm_db2_jdbc_universal_driver_architecture]
> > INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> > lock to become the Master broker
> > INFO  DefaultDatabaseLocker          - Becoming the master on dataSource:
> > org.apache.commons.dbcp.BasicDataSource@60991f
> > INFO  TransportServerThreadSupport   - Listening for connections at:
> > tcp://MT13412:11111
> >
> > But when BrokerB starts it becomes the MASTER too:
> >
> > INFO  BrokerService                  - Using Persistence Adapter:
> > JDBCPersistenceAdaptor(org.apache.commons.dbcp.BasicDataSource
> > INFO  BrokerService                  - ActiveMQ null JMS Message Broker
> > (SLAVE) is starting
> > INFO  BrokerService                  - For help or more information please
> > see: http://incubator.apache.org/activemq/
> > INFO  ManagementContext              - JMX consoles can connect to
> > service:jmx:rmi:///jndi/rmi://localhost:12980/jmxrmi
> > INFO  JDBCPersistenceAdapter         - Database driver recognized:
> > [ibm_db2_jdbc_universal_driver_architecture]
> > INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> > lock to become the Master broker
> > INFO  DefaultDatabaseLocker          - Becoming the master on dataSource:
> > org.apache.commons.dbcp.BasicDataSource@f47396
> > INFO  TransportServerThreadSupport   - Listening for connections at:
> > tcp://MT13412:22222
> >
> >
> > Both Brokers uses this db config:
> >
> >   <bean id="db2datasource" class="org.apache.commons.dbcp.BasicDataSource">
> >     <property name="driverClassName" value="com.ibm.db2.jcc.DB2Driver"/>
> >     <property name="url" value="jdbc:db2://10.250.0.73:60152/DBCCCD"/>
> >     <property name="username" value="dbcccd"/>
> >     <property name="password" value="cccd00"/>
> >   </bean>
> >
> >
> >
> > I think this problem looks like a MySQL issue but for DB2:
> >
> > http://issues.apache.org/activemq/browse/AMQ-992
> >
> >
> > Am I doing something wrong? Or its a SQL bug.
> >
> > Thanks in Advance for your help.
> >
> > Matías.
> > --
> > View this message in context: http://www.nabble.com/JDBC-Master-Slave-doesn%27-work-with-DB2-tf3323814s2354.html#a9240339
> > Sent from the ActiveMQ - User mailing list archive at Nabble.com.
> >
> >
>
>
> --
>
> James
> -------
> http://radio.weblogs.com/0112098/
>


-- 

James
-------
http://radio.weblogs.com/0112098/

Mime
View raw message