2 Replies Latest reply on Nov 13, 2018 4:01 AM by simkam

    How to add SQL Server datasource in Wildfly 14.0.1

    Sunil Sindhu Newbie

      recently migrated from Wildfly 11 to Wildfly 14.

       

      same data source configurations works for Wildfly 11 but not for Wildfly 14.

       

      Getting following Warning message on wildfly 14.0.1 server start:

       

      17:20:06,872 WARN  [org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer] (MSC service thread 1-3) IJ020020: Connection Properties for DataSource: 'java:/HEC_care' is empty, try to use driver-class: 'com.microsoft.sqlserver.jdbc.SQLServerDriver' and connection-url: 'jdbc:sqlserver://192.168.10.123:1433;DatabaseName=TEST' to connect database

       

      following are the connection and driver configurations:

       

      <datasource jndi-name="java:/HEC_care" pool-name="HEC_care" enabled="true" use-java-context="true">

                          <connection-url>jdbc:sqlserver://192.168.10.123:1433;DatabaseName=TEST</connection-url>

                          <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

                          <datasource-class>com.microsoft.sqlserver.jdbc.SQLServerDataSource</datasource-class>

                          <driver>sqlserver</driver>

                          <security>

                              <user-name>test</user-name>

                              <password>test</password>

                          </security>

                      </datasource>

       

      <driver name="sqlserver" module="com.microsoft">

                              <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

                              <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

                              <datasource-class>com.microsoft.sqlserver.jdbc.SQLServerDataSource</datasource-class>

                          </driver>

       

      I did reviewed multiple forums but no luck yet.

      any help is appreciated.