You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by Vinod_mit <vi...@gmail.com> on 2007/05/25 16:41:37 UTC

configuring mysql persistant adapter

Hi friends
iam trying to connect mysql with acitvemq here is my code

    <persistenceAdapter>
      
      <journaledJDBC dataSource="#mysql-ds"/>
      
    </persistenceAdapter>

and here is the description, i have copied
mysql-connector-java-5.0.5-bin.jar in activemq lib directory
here is my mysql

    <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url"
value="jdbc:mysql://localhost/activemq?relaxAutoCommit=true"/>
    <property name="username" value=""/>
    <property name="password" value=""/>
    <property name="poolPreparedStatements" value="true"/>
  </bean>

when i start activemq i get these errors

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableCon
nectionFactory (Communications link failure due to underlying exception:

can any one tell me what is the problem.
or u can mail me : vinu.mm@gmail.com
-- 
View this message in context: http://www.nabble.com/configuring-mysql--persistant-adapter-tf3816505s2354.html#a10804331
Sent from the ActiveMQ - User mailing list archive at Nabble.com.

Re: configuring mysql persistant adapter

Posted by Bruce Snyder <br...@gmail.com>.
On 5/25/07, Vinod_mit <vi...@gmail.com> wrote:
>
> Hi friends
> iam trying to connect mysql with acitvemq here is my code
>
>     <persistenceAdapter>
>
>       <journaledJDBC dataSource="#mysql-ds"/>
>
>     </persistenceAdapter>
>
> and here is the description, i have copied
> mysql-connector-java-5.0.5-bin.jar in activemq lib directory
> here is my mysql
>
>     <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
> destroy-method="close">
>     <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
>     <property name="url"
> value="jdbc:mysql://localhost/activemq?relaxAutoCommit=true"/>
>     <property name="username" value=""/>
>     <property name="password" value=""/>
>     <property name="poolPreparedStatements" value="true"/>
>   </bean>
>
> when i start activemq i get these errors
>
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableCon
> nectionFactory (Communications link failure due to underlying exception:
>
> can any one tell me what is the problem.
> or u can mail me : vinu.mm@gmail.com

I'd try to use another pooler like c3p0 to make sure it's not an issue
with DBCP. Below is an example configuration for it:

<bean id="mysql-ds" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
  <property name="driverClass" value="com.mysql.jdbc.Driver">
  <property name="jdbcUrl" value="jdbc:mysql://localhost:3306">
  <property name="user" value="user">
  <property name="password" value="pass">
  <property name="minPoolSize" value="5">
  <property name="maxPoolSize" value="10">
  <property name="acquireIncrement" value="3">
</bean>

Bruce
-- 
perl -e 'print unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'

Apache Geronimo - http://geronimo.apache.org/
Apache ActiveMQ - http://activemq.org/
Apache ServiceMix - http://servicemix.org/
Castor - http://castor.org/

Re: configuring mysql persistant adapter

Posted by Jonas Lim <jl...@exist.com>.
Hi,

I wonder if it's an issue with mysql  driver/server  compatibility.  
Have you tried using other versions of the mysql connector?

Regards,
Jonas

Regards,
Jonas

Vinod_mit wrote:
> Hi friends
> iam trying to connect mysql with acitvemq here is my code
>
>     <persistenceAdapter>
>       
>       <journaledJDBC dataSource="#mysql-ds"/>
>       
>     </persistenceAdapter>
>
> and here is the description, i have copied
> mysql-connector-java-5.0.5-bin.jar in activemq lib directory
> here is my mysql
>
>     <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
> destroy-method="close">
>     <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
>     <property name="url"
> value="jdbc:mysql://localhost/activemq?relaxAutoCommit=true"/>
>     <property name="username" value=""/>
>     <property name="password" value=""/>
>     <property name="poolPreparedStatements" value="true"/>
>   </bean>
>
> when i start activemq i get these errors
>
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableCon
> nectionFactory (Communications link failure due to underlying exception:
>
> can any one tell me what is the problem.
> or u can mail me : vinu.mm@gmail.com
>