1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<!-- Global confiduration -->
<entry key="database.driver">org.h2.Driver</entry>
<entry key="database.url">jdbc:h2:/home/user/Documents/database</entry>
<entry key="database.user">sa</entry>
<entry key="database.password"></entry>
<!-- Database refresh delay in seconds -->
<entry key="database.refreshDelay">300</entry>
<!-->
Create database:
CREATE TABLE devices (id INT, imei VARCHAR(16))
CREATE TABLE positions (device_id INT, time TIMESTAMP, is_valid BOOLEAN, latitude DOUBLE, longitude DOUBLE, speed DOUBLE, course DOUBLE, power DOUBLE)
<-->
<!-->
id - Integer
imei - String
<-->
<entry key="database.selectDevice">
SELECT id, imei
FROM devices
</entry>
<!-->
device_id - Integer
time - Date
valid - Boolean
latitude - Double
longitude - Double
speed - Double
course - Double
power - Double (NULL for some protocols)
extended_info - String (XML)
<-->
<entry key="database.insertPosition">
INSERT INTO positions (device_id, time, is_valid, latitude, longitude, speed, course, power)
VALUES (:device_id, :time, :valid, :latitude, :longitude, :speed, :course, :power)
</entry>
<!-- Xexun server configuration -->
<entry key="xexun.enable">true</entry>
<entry key="xexun.port">5000</entry>
<entry key="xexun.resetDelay">0</entry>
<!-- Gps103 server configuration -->
<entry key="gps103.enable">true</entry>
<entry key="gps103.port">5001</entry>
<entry key="gps103.resetDelay">0</entry>
<!-- Tk103 server configuration -->
<entry key="tk103.enable">true</entry>
<entry key="tk103.port">5002</entry>
<entry key="tk103.resetDelay">0</entry>
<!-- Gl100 server configuration -->
<entry key="gl100.enable">true</entry>
<entry key="gl100.port">5003</entry>
<entry key="gl100.resetDelay">0</entry>
<!-- Gl200 server configuration -->
<entry key="gl200.enable">true</entry>
<entry key="gl200.port">5004</entry>
<entry key="gl200.resetDelay">0</entry>
<!-- T55 server configuration -->
<entry key="t55.enable">true</entry>
<entry key="t55.port">5005</entry>
<entry key="t55.resetDelay">0</entry>
<!-- Xexun 2 server configuration -->
<entry key="xexun2.enable">true</entry>
<entry key="xexun2.port">5006</entry>
<entry key="xexun2.resetDelay">0</entry>
<!-- AVL-08 server configuration -->
<entry key="xexun2.enable">true</entry>
<entry key="xexun2.port">5007</entry>
<entry key="xexun2.resetDelay">0</entry>
</properties>
|
