HSAdmin Backend Domains, E-Mail, Datenbanken
Peter Hormanns
2012-09-21 0f3f06780e709e0ce887db17b8f26ed56c13fe40
correct JPQL on select greylisting domains
1 files modified
2 ■■■ changed files
hsarback/src/de/hsadmin/mods/dom/DomainProcessorFactory.java 2 ●●● patch | view | raw | blame | history
hsarback/src/de/hsadmin/mods/dom/DomainProcessorFactory.java
@@ -193,7 +193,7 @@
    
    private Processor createPostgreyConfiguration(EntityManager em) throws ProcessorException {
        ArrayList<Map<String, String>> domsMaps = new ArrayList<Map<String, String>>();
        Query query = em.createQuery("SELECT DISTINCT dom FROM Domains WHERE NOT EXISTS " +
        Query query = em.createQuery("SELECT DISTINCT dom FROM Domains dom WHERE NOT EXISTS " +
            "( SELECT postgreyDom FROM Domains postgreyDom " +
            "   WHERE postgreyDom.domainoptions.name = :option" +
            "         AND postgreyDom.name = dom.name )");