As well as adding mssql-ds.xml should I also use the mssql-service.xml file.
So far as I have already written I have just deployed the modified mssql-ds.xml file and the mssqlserver.jar.
I have no idea what else I should do to get the datasource set up.
Cheers For any help Tony
I have a feeling that the warning may just be a red herring.
When I try to run the application I get the following error :
java.rmi.RemoteException: Unable to get shortcut DAO: Unable to get data source: Unable to get datasource for <jdbc/webconnect>: javax.naming.NameNotFoundException: jdbc not bound.
So I do have a datasource problem.
This is my datasource file mssql-ds.xml
Do I need to add anything to my jboss.xml
<?xml version="1.0" encoding="UTF-8" ?>
Thanks for any help Tony
The warning is a red herring and can be ignored. You should only use the *-ds.xml files, not the *-service.xml files (at least if you want to remain sane:-)
Check in jndiview in the jmx console to see exactly what the datasource is getting bound under. Perhaps you are looking up jdbc/webconnect rather than java:/jdbc/webconnect? Datasources are only available in the jvm in which they are deployed.