suppress switch warning when using an IDE with jd1.7 warnings
fix resource memory leak introduced by PreparedStatements that were never being closed