From 5a6ada817e6c8d32ecf6993db0ac65839358c600 Mon Sep 17 00:00:00 2001
From: CVSz <seaza@msn.com>
Date: Wed, 16 Nov 2016 18:05:17 +0700
Subject: Add lib for Microsoft JDBC Drivers with maven

[INFO] Copying mssql-jdbc-6.1.0.jre8.jar to /root/traccar/target/lib/mssql-jdbc-6.1.0.jre8.jar

sample config for mssql

<entry key='database.driverFile'>lib/mssql-jdbc-6.1.0.jre8.jar</entry>
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
<entry key='database.url'>jdbc:sqlserver://[serverName][\instanceName];user=[userName];password=[password];databaseName=[database];</entry>
<entry key='database.user'>[userName]</entry>
<entry key='database.password'>[password]</entry>
---
 pom.xml | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/pom.xml b/pom.xml
index 24c3b442e..6e63bf0f7 100644
--- a/pom.xml
+++ b/pom.xml
@@ -127,6 +127,11 @@
             <artifactId>jxls-poi</artifactId>
             <version>1.0.11</version>
         </dependency>
+        <dependency>
+            <groupId>com.microsoft.sqlserver</groupId>
+            <artifactId>mssql-jdbc</artifactId>
+            <version>6.1.0.jre8</version> <!-- Newer versions require Java 8 -->
+        </dependency>
 
     </dependencies>
 
-- 
cgit v1.2.3