Step by step Jboss data source configuration for SQL server
Â
Jboss datasource configuration involves the below steps
1-Download required jar file
2-From the Jboss console start the deployment using the jar file downloaded from step 1
3-Now go to data source and select the deployment from step 2
4-Give the connection strings and test the connection to the database
1- login to jboss server & check the java version
[root@Node1 ~]# java -version
openjdk version "1.8.0_65"
OpenJDK Runtime Environment (build 1.8.0_65-b17)
OpenJDK 64-Bit Server VM (build 25.65-b01, mixed mode)
2- Now login to the Microsoft server to download the jdbc driver for sql server
after we unzip the folder in our local system we will see the the required jar files .
3-Now login to the Jboss console with userid/pwd
for me it is admin/Jboss2020
4-Now we will deploy the jar file
select Deployments > Add > Upload a new deployment > Brows the jar file >verify the upload > Finish
5- Once jar file is deployed we will add the data source to the Jboss server
Configuration >subsystem > Datasource > Non-XA(for single instance) > Add
6- Now we select the data source for the required databases
7-Click on the jarfile we added in previous step
8-Here we will give the db source details(connection strings ) for connectivity to the sql server database (change the hostname ,databasename,username,password)
9-press finish and test the connection
