I currently use multiple dbs/datasources and I do use similar configuration in jboss.jcml.
You might not have declared your datasources in the entities jaws.xml (instead the default DS is used):
They were not defined in jaws.xml. However it still does not work. Maybe I am doing it wrong in jaws.xml. I now have:
.... as before
(I also tried testdb1ds and testdb2ds instead of MYDB1 and MYDB2 above)
it looks like you use multiple DS in a single ejb app?
I have several apps, however, each one uses a single (different) DS (that is declared in jaws.xml, NOT standardjaws.xml).
I have no experience with declaring multiple datasources in a single application. I do not think it will work this way:
I'm about 80% sure you can't do this in 2.2.2. Theres a good chance you can in 2.4.4, although you would have to declare the datasource with the ejb you want it to use. It is definitely possible with jboss 3 cmp2 -- see jbosscmp-jdbc.dtd for how.