activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lin.Zhang" <ygdra...@gmail.com>
Subject ActiveMQ persistence extremely slow with JDBC
Date Fri, 10 Oct 2008 00:45:25 GMT

Hi, we got a problem when using journal configured with JDBC, here are some
details:

We configured the journal with an Oracle datasource, but it is *extremely*
slow when sending messages to ActiveMQ, about 1.5 minutes per message...,
and our config file looks like below:

<persistenceAdapter>
      <journaledJDBC dataDirectory="${activemq.base}/data"
dataSource="#oracle-ds"/>
</persistenceAdapter>

...

<bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
      <property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
      <property name="url"
value="jdbc:oracle:thin:@10.10.10.13:1521:D15IDB01"/>
      <property name="username" value="user"/>
      <property name="password" value="pass"/>
      <property name="maxActive" value="50"/>
      <property name="poolPreparedStatements" value="true"/>
</bean>

The interesting thing is that on some database, it is not slow. And if the
persistence is disabled, there is no performance problems. I'm really
confused and don't know whether it is an ActiveMQ problem or Oracle
configuration problem. 

If anybody has this kind of problem before or has any clue about it, please
give me some help. Thanks a lot. I can provide more details if needed.
-- 
View this message in context: http://www.nabble.com/ActiveMQ-persistence-extremely-slow-with-JDBC-tp19910036p19910036.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message