[JBoss-user] How to use two Datasources with CMP ?

[Francesco Marchioni]

Hi jBossUsers, I have 2 tables on two different DB (MySql - PostgreSql). How can I use CMP with 2 Datasources ? jaws.xml and standardjaws.xml don't let me specify more then 1 datasource inside.... With BMP I can get a connection from the pools without problems.... but how can I achieve it with CMP ? If this is not possible I must think that distributed transactions are only possible with BMP.... otherwise how can I have two "create()" on different DB on the same transaction ? Thanks Francesco