HELP - MultiDatabase using JBOSS

[Nguyen Quoc Nguyen]

Please help me - how to configure jboss to run muilti database
when you configure some file
1. mssql-ds.xml
2. standardjaws.xml
3. standardjbosscmp-jdbc.xml
4. and login-config.xml
the JBoss 4.0 server is configured to be used with a MS SQL Server database.
You only run Only one database that you locate it at mssql-ds.xml
Now, i want to run 2 database at 2 application but mssql-ds.xml can not configure another database
Please Help configure to run 2 database

[Mark Spritzler]

Basically, even though the file name is mssql-ds.xml.

Anything before the "-ds.xml" could be anything and it would still be a datasource. JBoss looks for xxx-ds.xml and deploys a datasource. so you can have two files

mssqlA-ds.xml and mssqlB-ds.xml and you have two different datasources and they point to two different databases.

Mark