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


From e42ac7f82e408e0e7307cb3b508489e580cc5b15 Mon Sep 17 00:00:00 2001
From: CVSz <seaza@msn.com>
Date: Wed, 16 Nov 2016 18:58:14 +0700
Subject: Change jre8 to jre7 by default

<version>6.1.0.jre7</version> <!-- edit to 6.1.0.jre8 if you used jre8 -->
bcoz we can't install both of one dependency
---
 pom.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/pom.xml b/pom.xml
index 6e63bf0f7..b71377b49 100644
--- a/pom.xml
+++ b/pom.xml
@@ -130,7 +130,7 @@
         <dependency>
             <groupId>com.microsoft.sqlserver</groupId>
             <artifactId>mssql-jdbc</artifactId>
-            <version>6.1.0.jre8</version> <!-- Newer versions require Java 8 -->
+            <version>6.1.0.jre7</version> <!-- edit to 6.1.0.jre8 if you used jre8 -->
         </dependency>
 
     </dependencies>
-- 
cgit v1.2.3