com.mysql.jdbc.Driver jdbc:mysql://localhost/gts?allowMultiQueries=true root root 300 SELECT imeiNumber AS id, imeiNumber AS imei FROM Device WHERE imeiNumber <> ''; DO 0; DO 0; DO 0; DO 0; START TRANSACTION; UPDATE Device SET lastValidLatitude = :latitude, lastValidLongitude = :longitude, lastGPSTimestamp = UNIX_TIMESTAMP(:time), lastUpdateTime = UNIX_TIMESTAMP(NOW()) WHERE imeiNumber = :device_id; SELECT @accountID := accountID, @deviceID := deviceID FROM Device WHERE imeiNumber = :device_id; INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, heading, altitude, rawData, creationTime) VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed, :course, :altitude, '', UNIX_TIMESTAMP(NOW())); COMMIT; true 8082 false /home/user/Documents/tracker-server.log true 5000 0 true 5001 0 true 5002 0 true 5003 0 true 5004 0 true 5005 0 true 5006 0 true 5007 0 true 5008 0