Setting up MS SQL Server with JBoss

[tony1929]

Hi I have just started using JBoss today, amd I am trying to set up a MS SQL Server 7 database as a datasource.

I am following the document Using MS SQL Server with JBoss.

But have run into a problem, according to the doc, I need to add my driver to the file jboss.jcml.

But this file does not exist in my vesrion of JBoss.
jboss-3.2.0RC2_tomcat.4.1.18.

Can anyone tell me what the new name is or where I can down load the docs that go with this version.

I did download getting started with Vesrion 3, but it was not very helpful where setting up datasources was concerned.

Thanks for any help Tony

[tony1929]

Further investigation has revealed the following files in the examples directory:

mssql-ds.xml
mssql-service.xml
mssql-xa-ds.xml
mssql-xa-service.xml

I guess the way forward is to copy these into the JBOSS server directory and modify them for my use.

I am not sure where they should be copied to, I guess it should be the


C:\jboss-3.2.0RC2_tomcat.4.1.18\server\default\conf directory, as this contains all the xml files that are needed at start-up.

Am I correct in this thanks for any help.

Cheers Tony

[hans_tw]

> Further investigation has revealed the following
> files in the examples directory:
>
> mssql-ds.xml
> mssql-service.xml
> mssql-xa-ds.xml
> mssql-xa-service.xml
>
> I guess the way forward is to copy these into the
> JBOSS server directory and modify them for my use.
>
> I am not sure where they should be copied to, I guess
> it should be the
>
You sould copy the mssql-xxx.xml to $JBOSS_HOME/server/all(or default,minimal)/deploy/ and modify the parameter.
It should work.
>
> C:\jboss-3.2.0RC2_tomcat.4.1.18\server\default\conf
> directory, as this contains all the xml files that
> are needed at start-up.
>
> Am I correct in this thanks for any help.
>
> Cheers Tony

[tony1929]

Thanks for the help. that helped a lot.

Cheers Tony