Download and install a SQL Server JDBC driver to use in this tutorial; then make the driver available to the JBoss application server.
Install a JDBC Driver
As this tutorial uses SQL Server, you need a SQL Server-compatible JDBC driver. Download the Microsoft JDBC SQL Server 4.0 driver using this link, and install it using the
Install Instructions on the download page:
Download JDBC Drivers
The name of the driver file is
sqljdbc4.jar. Be sure to take note of the location of this file after installing it.
Configure the JDBC Driver in JBoss
To make the JDBC driver available to JBoss, you must place it in the appropriate directory, and configure it by creating an XML configuration file.
- Copy the JDBC Driver to JBoss
- To run your application, the JBoss application server must find an SQL Server JDBC driver file in a specific subdirectory of your JBoss installation directory. You must create the subdirectory and copy the
sqljdbc4.jar file as follows:
- At a command prompt or using Explorer, change to your JBoss installation's
modules\com directory.
- Create the following subdirectory structure:
microsoft\sqlserver\main
- Change to the
modules\com\microsoft\sqlserver\main directory.
- Copy the downloaded
sqljdbc4.jar file to the
modules\com\microsoft\sqlserver\main directory.
- Create a
module.xml file
- The
module.xml file provides JDBC driver configuration required by JBoss.
- In the
modules\com\microsoft\sqlserver\main directory, create a new file,
module.xml, using any text editor.
- Copy the following contents into the file:
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.microsoft.sqlserver">
<resources>
<resource-root path="sqljdbc4.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>
- Save the file and exit the editor.