aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authordrecchia <danilo@deltatecnologia.com>2016-06-06 09:11:00 -0300
committerdrecchia <danilo@deltatecnologia.com>2016-06-06 09:11:00 -0300
commitd1f602835eff3df33261ce16620c51fb291c0763 (patch)
tree68cd189d91f5795ccd7c03669764516f4a513e3c
parent9c4f58c2bac0b2cad025f3ac3e79e88511a0b857 (diff)
downloadtraccar-server-d1f602835eff3df33261ce16620c51fb291c0763.tar.gz
traccar-server-d1f602835eff3df33261ce16620c51fb291c0763.tar.bz2
traccar-server-d1f602835eff3df33261ce16620c51fb291c0763.zip
- Fix hikari connection check sql.
-rw-r--r--debug.xml4
-rw-r--r--setup/unix/traccar.xml4
-rw-r--r--setup/windows/traccar.xml4
-rw-r--r--src/org/traccar/database/DataManager.java2
4 files changed, 13 insertions, 1 deletions
diff --git a/debug.xml b/debug.xml
index a70940108..7cd2023b9 100644
--- a/debug.xml
+++ b/debug.xml
@@ -54,6 +54,10 @@
<entry key='database.changelog'>./database/changelog-master.xml</entry>
+ <entry key='database.checkConnection'>
+ SELECT 1;
+ </entry>
+
<entry key='database.selectServers'>
SELECT * FROM server;
</entry>
diff --git a/setup/unix/traccar.xml b/setup/unix/traccar.xml
index a0233e601..bf2c5ef70 100644
--- a/setup/unix/traccar.xml
+++ b/setup/unix/traccar.xml
@@ -32,6 +32,10 @@
<entry key='database.password'></entry>
<entry key='database.changelog'>/opt/traccar/data/changelog-master.xml</entry>
+
+ <entry key='database.checkConnection'>
+ SELECT 1;
+ </entry>
<entry key='database.selectServers'>
SELECT * FROM server;
diff --git a/setup/windows/traccar.xml b/setup/windows/traccar.xml
index 5748f3993..d43e7373a 100644
--- a/setup/windows/traccar.xml
+++ b/setup/windows/traccar.xml
@@ -33,6 +33,10 @@
<entry key='database.changelog'>[CHANGELOG]</entry>
+ <entry key='database.checkConnection'>
+ SELECT 1;
+ </entry>
+
<entry key='database.selectServers'>
SELECT * FROM server;
</entry>
diff --git a/src/org/traccar/database/DataManager.java b/src/org/traccar/database/DataManager.java
index ad7c4478b..4e69d1d8e 100644
--- a/src/org/traccar/database/DataManager.java
+++ b/src/org/traccar/database/DataManager.java
@@ -117,7 +117,7 @@ public class DataManager implements IdentityManager {
hikariConfig.setJdbcUrl(config.getString("database.url"));
hikariConfig.setUsername(config.getString("database.user"));
hikariConfig.setPassword(config.getString("database.password"));
- hikariConfig.setConnectionInitSql("SELECT 1 FROM DUAL");
+ hikariConfig.setConnectionInitSql(config.getString("database.checkConnection"));
hikariConfig.setIdleTimeout(600000);
int maxPoolSize = config.getInteger("database.maxPoolSize");