[jboss-user] [JCA/JBoss] - Re: Datasource failover, sudden disconnection not working

2007-03-23 Thread sebastianlacuesta
Correct, I had to add a parameter in the connection url, I set the socketTimeout in 5000 milliseconds in this way: connection-urljdbc:mysql://192.168.10.210:3306/POK2?socketTimeout=5000|jdbc:mysql://192.168.10.219:3306/POK2?socketTimeout=5000/connection-url For anyone looking at mysql failover,

[jboss-user] [JCA/JBoss] - Datasource failover, sudden disconnection not working

2007-03-22 Thread sebastianlacuesta
I have a problem using datasource failover with MySQL. My setup is JBoss at host A, and mysql in host B, replicated in host A. I have followed the instructions in JBossJCADatabaseFailover. When I stop mysql at machine B with /etc/init.d/mysql stopfailover works flawlessly, but if I disconnect

[jboss-user] [Clustering/JBoss] - Re: Problem with datasources, they start, but my apps cannot

2007-03-05 Thread sebastianlacuesta
Excellent, I deleted the jms configuration, and copied the one in default, made the necesary changes, and it worked. The problem with PokQueryDs was that in the AS, the pool was named PokQueryDS (that makes me feel like dumb). Thanks for all. View the original post :

[jboss-user] [Clustering/JBoss] - Re: Problem with datasources, they start, but my apps cannot

2007-03-01 Thread sebastianlacuesta
Well, in the default config it seems that JMS uses the hypersonic db, and I read everywhere that this is a bad idea in a production environment (I couldn't find why), so I changed the DefaultDS to use mysql locally, and then I changed the DataSourceBinding at mysql-jdbc2-service.xml to use it,

[jboss-user] [Clustering/JBoss] - Problem with datasources, they start, but my apps cannot use

2007-02-28 Thread sebastianlacuesta
Hi, I'm having a very strange behavior with a cluster. The main problem is that I have diferent datasources, that they appear to start correctly, when I try to use them I get a NullPointerException. There are some other strange things that occur: The first node starts without problem, no

[jboss-user] [Clustering/JBoss] - Re: Problem with datasources, they start, but my apps cannot

2007-02-28 Thread sebastianlacuesta
Yes, I get the same Incomplete Deployment listing on all servers, except the first I start, no matter which of all is. I don't want JMS being clustered, I want it standalone for each server. The DefaultDS uses a local mysql in each server. I have two more datasources which they point to two