From e910d9337a35fad663c978ff9121ed64ca28af91 Mon Sep 17 00:00:00 2001 From: Abyss777 Date: Thu, 14 Jul 2016 15:21:43 +0500 Subject: - Fixed saving parent group when creating new group. - Fixed storing device and group if parent group is not defined. - Fixed Warning in browser console about missed requirements. --- src/org/traccar/database/QueryBuilder.java | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'src/org/traccar/database') diff --git a/src/org/traccar/database/QueryBuilder.java b/src/org/traccar/database/QueryBuilder.java index 73569ac2a..477434fb5 100644 --- a/src/org/traccar/database/QueryBuilder.java +++ b/src/org/traccar/database/QueryBuilder.java @@ -175,7 +175,11 @@ public final class QueryBuilder { public QueryBuilder setLong(String name, long value) throws SQLException { for (int i : indexes(name)) { try { - statement.setLong(i, value); + if (value == 0) { + statement.setNull(i, Types.INTEGER); + } else { + statement.setLong(i, value); + } } catch (SQLException error) { statement.close(); connection.close(); -- cgit v1.2.3