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


https://download.microsoft.com/download/4/0/8/40815588-bef6-4715-bde9-baace8726c2a/sqljdbc_8.2.2.0_enu.zip

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











37 views1 comment