It is possible to use a java method to decide which table to store the EJB in CMP. However I don't have a clue to store my EJB(CMP) into different database without restart the server. Any of your solution will be highly appreciated.
In, jbosscmp-jdbc.xml, it is only one declaring of the dataource .
Any other way to have 1 more datasource declaration?
Is there anyone can solve the problem in CMP rather then to rework the programes into BMP?