RC1 + MySql help needed.

[g_andre]

Is any change concerning datasource between JB3 beta and RC1? I am desperately trying to use RC1 with mysql database( I had no problem with RC1). Anyone managed to do it.

Thanks.

[g_andre]

Sorry something unclear in the prev mail.

Is there any change concerning datasource between JB3 beta and RC1? I am desperately trying to use RC1 with mysql database( I had no problem with JB3 beta). Anyone managed to do it.

Thanks.

[davidjencks]

I'm not sure the new examples made it into the rc1 package. Get a new sample config from cvs at jbosscx/src/etc/example-config. Note that you have to have matching entries between mysql-service.xml and login-conf.xml. This is set up already for hsqldb-service. There are additional comments in the jdatastore-service.xml on how to do it.

[rsal]

Have you gotten MySql working with RC1 yet?

/rick

[g_andre]

It is working no problem. Follow the recomendation above, look for conf/login-config.xml rather than login-conf.xml.
Thanks.

[davidjencks]

For more information...
http://main.jboss.org/forums/thread.jsp?forum=67&thread=13366

thanks
david jencks

[rsal]

David,

Is it possible to enable more than one MySql DataSource with the new config files??

Thanks,
/rick

[davidjencks]

Sure, just be sure the object names are different in all the mbeans (I like using the name=xxx key for this), the jndi names are different, and that each one has its own security configuration set up correctly.

Note that mysql does not support xa transactions in any way, so you should not try to include both dbs in the same transaction and expect consistent results (on failure). The mysql xadatasource implementation provides an xa interface but not the semantics, and you should get marginally better performance using the LocalTx wrapper.

If you do need real xa semantics the only free solution I know of is firebird with the jca-jdbc driver.