[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: Multiple data sources when using MySQL

[PeterJ]

anonymous wrote : apparently it is not common with MySQL as the database as there is very little information to be found on how to configure JBoss.

http://www.jboss.org/community/docs/DOC-12255

http://www.jboss.org/community/docs/DOC-12244

I have another resource but it not free (though the code is), I can provide a URL if interested.

anonymous wrote : I found out that it failed because there are two local-tx data sources

That should not matter (I typically have two, occasionally a few more). However, the server will complain if two datasource have the same JNDI name.

1) The name "DefaultDS" is scattered across several configuration files. There is nothing magic to that name - you could change all occurrences to "FooBar" and it would still work. The whole point, however, of leaving it at DefaultDS is so that you don't have to hunt down all of those references.

2) See the URLs I gave above (I use both MySQL and PostgreSQL, and in my one production environment we use MySQL)

3) No.

4) No, having multiple *-ds.xml files, each using a different jndi-name and each referencing a different database within MySQL is the way to go.

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4225662#4225662

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4225662