Using MSSQLServer as default datasource

[juang]

Hi,

I just started to evaluate JBoss, and I wanted to set MSSQLServer as the default database, using the aveconnect jdbc driver. I did the following things:

-updated standardjaws.xml to use the MSSQLServer type mapping.
-updated standardjbosscmp-jdbc.xml to use the MSSQLServer datasource mapping.
-removed hsqldb-service.xml from the deploy directory
-updated the mssql-service.xml file with JNDI name "DefaultDS"
-copied the mssql-service.xml file to the deploy directory
-copied the driver's jar file to the lib directory

After doing all this, when JBoss starts and tries to deploy the CD application, it fails with the following error:

org.jboss.deployment.DeploymentException: DefaultDS not bound



Thanks very much for your help.

juan

[davidjencks]

If you are using jboss 3.0 rc1, please see http://main.jboss.org/forums/thread.jsp?forum=67&thread=13366

Note that the location of example files has changed from location indicated in the manual.

If this does not help, check your startup log for messages, and jndiview to see what is actually bound, and post with more information.

[shodson]

What if we're using 2.4.4? How do we do it there?

[davidjencks]

,for 2.4.4, modify the appropriate mbean in jboss.jcml, and don't use any of the jboss 3 config stuff.