ReportDAO reportDAO = new ReportDAO();
Report report = new Report();
report.setName("reportTest");
report.setUser(user.findById(1l));
ReportDesign design = new ReportDesign();
design.setMappingAxis("x");
design.setColumnAlias(columnAlias.findById(99999l));
design.setReport(report);
report.setReportType(type.findById(1l));
ArrayList<ReportDesign> designs = new ArrayList<ReportDesign>();
designs.add(design);
report.setDesigns(designs);
RowAliasFilter rowAliasFilter = new RowAliasFilter();
rowAliasFilter.setReport(report);
rowAliasFilter.setRowAlias(rowAlias.findById(99999l));
rowAliasFilter.setFilterType(filterType.findById(1l));
rowAliasFilter.setValue("rowFilter");
ArrayList<RowAliasFilter> rowFilters = new ArrayList<RowAliasFilter>();
rowFilters.add(rowAliasFilter);
report.setRowAliasFilters(rowFilters);
ColumnFilter columnFilter = new ColumnFilter();
columnFilter.setColumnAlias(columnAlias.findById(99999l));
columnFilter.setFilterType(filterType.findById(1l));
columnFilter.setReport(report);
columnFilter.setValue("columnFilter");
ArrayList<ColumnFilter> columnFilters = new ArrayList<ColumnFilter>();
columnFilters.add(columnFilter);
report.setColumnFilters(columnFilters);
reportDAO.session = session;
reportDAO.transaction = reportDAO.session.getTransaction();
long reportId = reportDAO.save(report);
long designId = design.getId();
long rowAliasFilterId = rowAliasFilter.getId();
long columnFilterId = columnFilter.getId();
ResultSet rs1 = stmt.executeQuery("select * from rowFilter where id="
+ rowAliasFilterId);