import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class TestMariaDb {
    /* test table schema:
        CREATE TABLE `test` (
            `column1` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT uuid(),
            `column2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
            PRIMARY KEY (`column1`)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    */
    
    
    public static void main(String args[]) throws Exception {
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/forms?user=root");
        String sql = "SELECT t.* FROM test t WHERE 1 = 2";
        PreparedStatement stmt = conn.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
        stmt.execute();
        ResultSet rs = stmt.getResultSet();
        rs.moveToInsertRow();
        rs.updateString("column2", "x");
        rs.insertRow();
    }
    
}