JBoss DataSource Configuration and Test

JBoss DataSource Configuration and Test

This demo will show you how to do JBoss DataSource Configuration and Test it on running JBoss server.

Here we will configure MSSQL database with JBoss server test our connection using JSP file. Please follow below steps:

  • Copy jtds-1.2.jar to server\default\lib folder
  • Copy below mssql-ds.xml file to server\default\deploy directory:

  • As you see above database name is “test” using default with MS SQL Server 2000.
  • Please don’t forget to change URL and username/password based on your environment.

 

Test using sample JDBC client:

  • Please create folder name: “jdbcclient.war” inside \server\default\deploy directory and create below jsp file and keep inside “jdbcclient.war” folder:

 

  • Now start your JBoss server (If you are using window operating system then go to jboss-xxx\bin folder and double click run.bat file to start the server:
  • Cut and paste this URL in your browser: http://localhost:8080/jdbcclient/client.jsp where you see list of users in the user table:

JBoss DataSource Configuration and Test

For more information please visit this JBoss tutorial

Leave a Reply

Your email address will not be published. Required fields are marked *