SQLite_byte_insert_test.java

public class ByteSaveTest {
  private static final String TABLE = "test_table";
  //The statement used to build the table I'm testing on
  private static final String BUILD_TABLE_STATEMENT =
          "CREATE TABLE IF NOT EXISTS " + TABLE + " (id varchar(32) NOT NULL UNIQUE, test BLOB NOT NULL, PRIMARY KEY (id));";

  //The test method
  void runTest(String id) {
      Bukkit.getLogger().info("Insert Result: " + saveByte(id, new byte[30]));
  }

  boolean saveByte(String rowID, byte[] byteTest) {
      Connection connection = null;
      PreparedStatement statement = null;
      boolean result = false;
      try {
          connection = getConnection();//this method is elsewhere, and is confirmed to work
          statement = connection.prepareStatement("INSERT INTO " + TABLE + " (id, test) VALUES(?, ?);");
          statement.setString(1, rowID);
          statement.setBytes(2, byteTest);
          result = (statement.executeUpdate() != 0);
      } catch (Exception e) {
          Bukkit.getLogger().warning(SQLiteDatabase.sqlError);
          ErrorLogger.log(e);
      } finally {
          try {
              if (connection != null) connection.close();
              if (statement != null) statement.close();
          } catch (SQLException e) {
              Bukkit.getLogger().warning(SQLiteDatabase.sqlError);
              ErrorLogger.log(e);
          }
      }
      return result;
  }
}