In ur jbosscmp-jdbc.xml,
1) change the datasource to whatever is the JNDI Name of ur SQL Server datasource
2) Change the datasource-mapping to MS SQLSERVER or MS SQLSERVER2000 (depending on what version you got).
Look for the datasource-mapping in standardjbosscmp-jdbc.xml in the <JBOSS_DIST>/server/conf dir.
THisis the jbosscmp-jdbc.xml file i am using .
if i go to the standardjbosscmp-jdbc.xml and change the default datasource to MSSQLDS it works fine and the SQL SERVER is used for CMP . but i want to keep the default to the Hypersonic SQL and only for this CDBean use the datasource i have specified in the above mentioned file .
why is that not working . it still mapst he CDBean to the hypersonic sql instead of SQL server . it simply ignored the datasource i am telling it to use .
i have another related problem . the jboss server usest he source that i specify in the standardjaws file in the config directory
i simply ignores wat ever data source is mentioned any where else and uses the one set as default in this file .