Connect Keycloack on Azure App Service with db sql external PaaS

Configuring the server
1

Hi All,
I put my keycloak on Azure App Service and works with internal db.
But i want to connect keycloak to external sql server db (on azure ) and when i change configuration in stanalone.xml i getting error.

module.xml

<?xml version="1.0" ?> 
<dependencies>
    <module name="javax.api"/>
    <module name="javax.transaction.api"/>
</dependencies>

standalone.xml (datasources)

    <subsystem xmlns="urn:jboss:domain:datasources:6.0">
        <datasources>
            <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}">
                <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>
                <driver>h2</driver>
                <security>
                    <user-name>sa</user-name>
                    <password>sa</password>
                </security>
            </datasource>
            <datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}">
                <connection-url>jdbc:sqlserver://database-name-qa-keycloak-sql.database.windows.net:1433;database=keycloack</connection-url>
                <driver>sqlserver</driver>
                <security>
                    <user-name>myadmin</user-name>
                    <password>mypassword</password>
                </security>
                 <validation>
                  <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"/>
                </validation>
              <statement>
                <track-statements>true</track-statements>
              </statement>
              <timeout>
                <blocking-timeout-millis>6000</blocking-timeout-millis>
                <allocation-retry>3</allocation-retry>
              </timeout>
            </datasource>
            ​<driver name="sqlserver" module="com.microsoft.sqlserver">
                    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
                    <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
                </driver> 
            <drivers>
                <driver name="h2" module="com.h2database.h2">
                    <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                </driver>
            </drivers>
        </datasources>
2

And my error :

0-15T06:06:55.139056988Z JAVA_OPTS already set in environment; overriding default settings with values: -Dserver.port=8080
2021-10-15T06:06:55.336404469Z =========================================================================
2021-10-15T06:06:55.336532680Z
2021-10-15T06:06:55.336555381Z JBoss Bootstrap Environment
2021-10-15T06:06:55.336561982Z
2021-10-15T06:06:55.336566382Z JBOSS_HOME: /home/site/wwwroot
2021-10-15T06:06:55.336593285Z
2021-10-15T06:06:55.336620287Z JAVA: /usr/lib/jvm/zulu-11-azure-jre-headless-tools_11.43.55-11.0.9.1-linux_musl_x64/bin/java
2021-10-15T06:06:55.336625587Z
2021-10-15T06:06:55.336630188Z JAVA_OPTS: -server -Dserver.port=8080 --add-exports=java.base/sun.nio.ch=ALL-UNNAMED --add-exports=jdk.unsupported/sun.misc=ALL-UNNAMED --add-exports=jdk.unsupported/sun.reflect=ALL-UNNAMED
2021-10-15T06:06:55.336634888Z
2021-10-15T06:06:55.336639288Z =========================================================================
2021-10-15T06:06:55.336643489Z
2021-10-15T06:06:55.349377552Z Picked up JAVA_TOOL_OPTIONS: -Xmx9797M -Djava.net.preferIPv4Stack=true
2021-10-15T06:06:56.211513652Z e[0m06:06:56,188 INFO [org.jboss.modules] (main) JBoss Modules version 1.11.0.Final
2021-10-15T06:06:57.151486731Z e[0me[0m06:06:57,150 INFO [org.jboss.msc] (main) JBoss MSC version 1.4.12.Final
2021-10-15T06:06:57.168509162Z e[0me[0m06:06:57,168 INFO [org.jboss.threads] (main) JBoss Threads version 2.4.0.Final
2021-10-15T06:06:57.376465842Z e[0me[0m06:06:57,375 INFO [org.jboss.as] (MSC service thread 1-3) WFLYSRV0049: Keycloak 15.0.2 (WildFly Core 15.0.1.Final) starting
2021-10-15T06:06:58.739632021Z e[0me[0m06:06:58,737 INFO [org.wildfly.security] (ServerService Thread Pool – 19) ELY00001: WildFly Elytron version 1.15.3.Final
2021-10-15T06:06:59.940028620Z e[0me[0m06:06:59,939 INFO [org.jboss.as.controller] (Controller Boot Thread) OPVDX002: Failed to pretty print validation error: null
2021-10-15T06:06:59.942526529Z e[0me[31m06:06:59,941 ERROR [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0055: Caught exception during boot: org.jboss.as.controller.persistence.ConfigurationPersistenceException: WFLYCTL0085: Failed to parse configuration
2021-10-15T06:06:59.942552132Z at org.jboss.as.controller@15.0.1.Final//org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:143)
2021-10-15T06:06:59.942558232Z at org.jboss.as.server@15.0.1.Final//org.jboss.as.server.ServerService.boot(ServerService.java:403)
2021-10-15T06:06:59.942562633Z at org.jboss.as.controller@15.0.1.Final//org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:416)
2021-10-15T06:06:59.942566933Z at java.base/java.lang.Thread.run(Unknown Source)
2021-10-15T06:06:59.942571433Z Caused by: javax.xml.stream.XMLStreamException: com.ctc.wstx.exc.WstxParsingException: Received non-all-whitespace CHARACTERS or CDATA event in nextTag().
2021-10-15T06:06:59.942575634Z at [row,col {unknown-source}]: [158,17]
2021-10-15T06:06:59.942579534Z at org.jboss.as.connector@23.0.2.Final//org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:651)
2021-10-15T06:06:59.942583634Z at org.jboss.as.connector@23.0.2.Final//org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:205)
2021-10-15T06:06:59.942588235Z at org.jboss.staxmapper@1.3.0.Final//org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:122)
2021-10-15T06:06:59.942605836Z at org.jboss.staxmapper@1.3.0.Final//org.jboss.staxmapper.XMLExtendedStreamReaderImpl.handleAny(XMLExtendedStreamReaderImpl.java:69)
2021-10-15T06:06:59.942611037Z at org.jboss.as.server@15.0.1.Final//org.jboss.as.server.parsing.StandaloneXml_16.parseServerProfile(StandaloneXml_16.java:673)
2021-10-15T06:06:59.942615537Z at org.jboss.as.server@15.0.1.Final//org.jboss.as.server.parsing.StandaloneXml_16.readServerElement(StandaloneXml_16.java:243)
2021-10-15T06:06:59.942620137Z at org.jboss.as.server@15.0.1.Final//org.jboss.as.server.parsing.StandaloneXml_16.readElement(StandaloneXml_16.java:140)
2021-10-15T06:06:59.942624038Z at org.jboss.as.server@15.0.1.Final//org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:144)
2021-10-15T06:06:59.942628638Z at org.jboss.as.server@15.0.1.Final//org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:52)
2021-10-15T06:06:59.942632638Z at org.jboss.staxmapper@1.3.0.Final//org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:122)
2021-10-15T06:06:59.942636639Z at org.jboss.staxmapper@1.3.0.Final//org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:76)
2021-10-15T06:06:59.942640639Z at org.jboss.as.controller@15.0.1.Final//org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:126)
2021-10-15T06:06:59.942644839Z … 3 more
2021-10-15T06:06:59.942649940Z Caused by: com.ctc.wstx.exc.WstxParsingException: Received non-all-whitespace CHARACTERS or CDATA event in nextTag().
2021-10-15T06:06:59.942654040Z at [row,col {unknown-source}]: [158,17]
2021-10-15T06:06:59.942657941Z at org.codehaus.woodstox//com.ctc.wstx.sr.StreamScanner.constructWfcException(StreamScanner.java:634)
2021-10-15T06:06:59.942661841Z at org.codehaus.woodstox//com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:504)
2021-10-15T06:06:59.942665841Z at org.codehaus.woodstox//com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:488)
2021-10-15T06:06:59.942669842Z at org.codehaus.woodstox//com.ctc.wstx.sr.BasicStreamReader.nextTag(BasicStreamReader.java:1223)
2021-10-15T06:06:59.942673742Z at org.jboss.staxmapper@1.3.0.Final//org.jboss.staxmapper.XMLExtendedStreamReaderImpl.nextTag(XMLExtendedStreamReaderImpl.java:152)
2021-10-15T06:06:59.942677742Z at org.jboss.as.connector@23.0.2.Final//org.jboss.as.connector.subsystems.datasources.DsParser.parseDataSources(DsParser.java:208)
2021-10-15T06:06:59.942681743Z at org.jboss.as.connector@23.0.2.Final//org.jboss.as.connector.subsystems.datasources.DsParser.parse(DsParser.java:189)
2021-10-15T06:06:59.942685843Z at org.jboss.as.connector@23.0.2.Final//org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:644)
2021-10-15T06:06:59.942689943Z … 14 more
2021-10-15T06:06:59.942694144Z
2021-10-15T06:06:59.943392302Z e[0me[31m06:06:59,943 FATAL [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0056: Server boot has failed in an unrecoverable manner; exiting. See previous messages for details.
2021-10-15T06:06:59.968474411Z e[0me[0m06:06:59,967 INFO [org.jboss.as] (MSC service thread 1-4) WFLYSRV0050: Keycloak 15.0.2 (WildFly Core 15.0.1.Final) stopped in 19ms
2021-10-15T06:07:00.114283566Z e[0mFinished running startup file ‘sh /home/site/wwwroot/bin/standalone.sh’. Exit code: ‘1’.
2021-10-15T06:07:00.114322470Z Custom startup complete. Now, exiting with exit code ‘1’
2021-10-15T06:07:00.664Z ERROR - Container keyclocack-test_0_f5108291 for site keyclocack-test has exited, failing site start
2021-10-15T06:07:00.668Z ERROR - Container keyclocack-test_0_f5108291 didn’t respond to HTTP pings on port: 8080, failing site start. See container logs for debugging.
2021-10-15T06:07:00.671Z INFO - Stopping site keyclocack-test because it failed during startup.