I forgot to say I am using JBoss3.0.0.
Did you find any doc on this. I am looking for similar.
1. Have one service file in the deploy directory for each data source.
2. Make sure that each data source has a unique JNDI name.
3. Have the bean(s) connect to the data sources through JNDI lookups using those unique names paired with DataSource objects.
if you are using JAAS security for your beans then there is an extra step but you haven't mentioned anything like that.
The deadlock issues have to be resolved in your database or in your bean code (i.e. locking and unlocking tables, checking for table locks, etc.)
Hope it helps,
Thanks for your response.
This looks interesting.
Can you please explain the point 3 in detail with example?