fix the name of a column in the test
close the connection and sleep to make sure the data is sent