How to add SQL Server datasource in Wildfly 14.0.1

[sunil.sindhu2]

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.

[mayerw01]

You may check this link JDBC Driver / DataSource Setup · HAL Management Console

My module.xml looks like this:

<module xmlns="urn:jboss:module:1.3" name="com.mssql">

<resources>

    <resource-root path="mssql-jdbc-7.0.0.jre10.jar"/>

  </resources>

  <dependencies>

    <module name="javax.api"/>

    <module name="javax.transaction.api"/>

  </dependencies>

</module>

The driver and datasource definitions can be easily done via the Management console via Configuration -> Subsystems -> Datasources & Drivers

The url might look like:

jdbc:sqlserver://{hostname}:1433;databaseName={databaseName};instanceName={InstanceName}

[simkam]

Hi,

when defined <datasource-class> has precedence over <driver-class>. So either undefine it and <driver-class> will be used or set connection properties instead of connection-url.

http://wildscribe.github.io/WildFly/14.0/subsystem/datasources/data-source/ExampleDS/connection-properties/index.html