diff options
| author | drecchia <danilo@deltatecnologia.com> | 2016-06-06 09:11:00 -0300 |
|---|---|---|
| committer | drecchia <danilo@deltatecnologia.com> | 2016-06-06 09:11:00 -0300 |
| commit | d1f602835eff3df33261ce16620c51fb291c0763 (patch) | |
| tree | 68cd189d91f5795ccd7c03669764516f4a513e3c | |
| parent | 9c4f58c2bac0b2cad025f3ac3e79e88511a0b857 (diff) | |
| download | traccar-server-d1f602835eff3df33261ce16620c51fb291c0763.tar.gz traccar-server-d1f602835eff3df33261ce16620c51fb291c0763.tar.bz2 traccar-server-d1f602835eff3df33261ce16620c51fb291c0763.zip | |
- Fix hikari connection check sql.
| -rw-r--r-- | debug.xml | 4 | ||||
| -rw-r--r-- | setup/unix/traccar.xml | 4 | ||||
| -rw-r--r-- | setup/windows/traccar.xml | 4 | ||||
| -rw-r--r-- | src/org/traccar/database/DataManager.java | 2 |
4 files changed, 13 insertions, 1 deletions
@@ -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"); |