com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/[DATABASE]?allowMultiQueries=true [USER] [PASSWORD] 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 true [LOG] true 5000 true 5001 true 5002 true 5003 true 5004 true 5005 true 5006 true 5007 true 5008 true 5009 true 5010 true 5011 true 5012 true 5013 true 5014 true 5015 true 5016 true 5017