how to connect to msSql & progress from jboss simulataneouse

[hihowru]

Hi all,
In one of my JSP i need info from One DB which is in MsSql and other info which is in ProgressDB. So I have 1 sqlServer-service.xml and progress-service.xml.
The problem i am having is for the first time only one
Datasource is active and am able to get one connection which is either MsSql or ProgressDB.

If i rename any of the file ,they are reloaded resulting to connection establlishment to both DBs.

Is there any settings to be done to create both connnection pools at the start up of the server.

Because of this prob. for the first time my jsp is not working.

For sample pl . refer the files.

[sridharsa]

Hi,
I am a newbie to JBoss too and don't profess to knowing much about the workings of JBoss. From your -ds.xml file, I saw that u have the same JNDI name for both your datasources. So, SQLServer might be overriding your Progress datasource.

Change that and check again.

All the best.
Sridhar.