Datenbanktreiber SQL Server hinzufügen

Aus hilfma.at
Zur Navigation springen Zur Suche springen

Path to jar:

modules\system\layers\base\com\microsoft\sqlserver\main


standalone.xml

<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>

module.xml

<module xmlns="urn:jboss:module:1.3" name="com.microsoft.sqlserver">
    <resources>
        <resource-root path="mssql-jdbc-8.2.2.jre11.jar" />
    </resources>
    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
    </dependencies>
</module>

Connection

                    <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=REPO</connection-url>
                    <driver>sqlserver</driver>

mssql-jdbc_auth-8.2.2.x64.dll nach jdk\bin Folder kopieren