private void fillDbTables() throws Exception { for (Category cat : categories) categoryDAO.create(cat); for (Producer p : producers) producerDAO.create(p); Long idProducer = producerDAO.getByName("Apple").getId(); Long idCategory = categoryDAO.getByName("Tablet").getId(); commodity.setIdProducer(idProducer); commodity.setIdCategory(idCategory); commodityDAO.create(commodity); commodity = commodityDAO.getByName("Ipad4"); commodityView.setIdCommodity(commodity.getId()); }