top of page

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











159 views1 comment
bottom of page