configure jboss-4.0.0 with MS SQL server 2000

[Krishna Nagadev]

hi,
any one can help me.
I have configured jboss for MS SQL2000 as specified in the following link,
http://www.onjava.com/pub/a/onjava/2004/02/25/jbossjdbc.html
But i could not get it,
any one can give me the steps to follow.I struck with this for last 3 days. plz help me.

with advanced thanks
and ragards
Infant papa

[Paul Sturrock]

Well that link will go only some of the way to help, since it doesn't mention MSSQL. The most basic configuration required is to define a DataSource and put the appropriate driver classes into the CLASSPATH. Your DataSource file will look something like this:

<datasources>
  <local-tx-datasource>
    <jndi-name>datasourceName</jndi-name>
    <connection-url>[whatever]</connection-url>
    <driver-class>com.driver.package.Driver</driver-class>
    <max-pool-size>100</max-pool-size>
    <user-name>sa</user-name>
    <password>sa</password>
  </local-tx-datasource>
</datasources>

And is deployed in the "deploy" directory of whichever server you are running. The Driver classes go to the lib directory of the same server. Make sense?

[Krishna Nagadev]

thanks paul,
i got it now