In this video, we will see how to configure Wildfly to connect to SQL Server Database via JDBC Driver. You will learn how to configure Module.xml and Standalone.xml to access pubs database on SQL Server.
Module.xml
1 2 3 4 5 6 7 8 9 10 |
<module xmlns="urn:jboss:module:1.3" name="com.microsoft.sqlserver.jdbc"> <resources> <resource-root path="mssql-jdbc-9.2.1.jre8.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> </dependencies> </module> |
Standalone.xml
1 2 3 4 |
<driver name="MsSQLServer12" module="com.microsoft.sqlserver.jdbc"> <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver </driver-class> </driver> |
Categories: JSP