SQL Server is a comprehensive data management and analysis solution to build, deploy, and manage enterprise applications. In this section, we will configure JBoss application server with SQL Server 2000 and SQL Server 2005. Copy the SQL Server JDBC 4.0 JAR file to JBoss server as we did with the other databases. I-net software's Merlia JDBC drivers support JDBC 4.0, where the Merlia driver ZIP file Merlia_Trial_7.02.zip
may be obtained from http://www.inetsoftware.de/products/jdbc/mssql/merlia/. Extract the Merlia ZIP file to a directory, add Merlia.jar
to the JBoss's installation /server/default/lib
directory, and set the JAVA_HOME
environment variable to JDK 6.0. We also have to copy the SQL Server data source file to the JBoss server deploy directory. Copy docs\examples\jca\mssql-ds.xml
for non-transactional data source, or \docs\examples\jca\mssql-xa-ds.xml
for transactional data source to the \server\default\deploy
directory.
Modify the mssql...