MessageFormat assemblyIdFormat = new MessageFormat(type + "_" + "{0,number,0000}");
MessageFormat assemblyIdFormat = new MessageFormat(type + "-" + "{0,number,0000}"); substitutions.put(":assembly_type", CMT_TYPE);
    private String insertAssembly(Connection dbConnection, String type) throws SQLException {        MessageFormat assemblyIdFormat = new MessageFormat(type + "_" + "{0,number,0000}");        String assemblyId = getNextId(dbConnection, QUERY_MAX_ASSEMBLY, assemblyIdFormat);        substitutions.put(":assembly_id", assemblyId);        substitutions.put(":description", "TestPopulateDb " + new Date().toString());        Statement stmt = dbConnection.createStatement();        executeUpdate(stmt, dbp.getQuery(INSERT_ASSEMBLY, substitutions));        executeUpdate(stmt, dbp.getQuery(INSERT_TRIAL_ASSEMBLY, substitutions));        stmt.close();        return assemblyId;    }