select e.employees from Event e

select employee2_.id as id6_, employee2_.personnelNumber as personne2_6_, employee2_.forename as forename6_, employee2_.surname as surname6_ from Events event0_ inner join Events_Employees employees1_ on event0_.id=employees1_.EventId inner join Employees employee2_ on employees1_.EmployeeId=employee2_.id

select e.employees, e.eventType from Event e

select . as col_0_0_, event0_.eventType as col_1_0_, employee2_.id as id6_, employee2_.personnelNumber as personne2_6_, employee2_.forename as forename6_, employee2_.surname as surname6_ from Events event0_ inner join Events_Employees employees1_ on event0_.id=employees1_.EventId inner join Employees employee2_ on employees1_.EmployeeId=employee2_.id

@Entity
@Table(name = "Events")
public class Event extends Persistent {

   /**
    * Versions-ID, die für die Serialisierung verwendet wird.
    */
   private static final long serialVersionUID = 7452522703278983008L;

   @Column(name = "EVENT_TIMESTAMP")
   private Date timestamp;

   @Enumerated(EnumType.STRING)
   private EventType eventType;

   // Kein Cascading
   @ManyToOne(optional = false, fetch = FetchType.LAZY)
   @JoinColumn(name = "MachineId", nullable = false)
   private Machine machine;

   // Kein Cascading
   @ManyToOne(optional = false, fetch = FetchType.LAZY)
   @JoinColumn(name = "OrderItemId", nullable = false)
   private OrderItem orderItem;

   @ManyToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
   @JoinTable(name = "Events_Employees", joinColumns = @JoinColumn(name = "EventId", referencedColumnName = "id"), inverseJoinColumns = @JoinColumn(name = "EmployeeId", referencedColumnName = "id"))
   private List<Employee> employees = new ArrayList<Employee>();

   /**
    * Erstellt eine neue Instanz dieser Klasse.
    */
   public Event() {
   }
...
}

@Entity
@Table(name = "Employees")
public class Employee extends Persistent {

   /**
    * Versions-ID, die für die Serialisierung verwendet wird.
    */
   private static final long serialVersionUID = 849339845014597020L;


   @Column(unique = true, nullable = false)
   private long personnelNumber;

   @Column(length = 50)
   private String forename;

   @Column(length = 50)
   private String surname;

   /**
    * Erstellt eine neue Instanz dieser Klasse.
    */
   public Employee() {
   }
...
}

public class HqlTest {

   public static void main(String[] args) throws IOException {
      java.util.logging.Logger.getLogger("").setLevel(Level.ALL);
      java.util.logging.Logger.getLogger("org").setLevel(Level.INFO);
      java.util.logging.Logger.getLogger("sun").setLevel(Level.INFO);
      java.util.logging.Logger.getLogger("com").setLevel(Level.INFO);
      java.util.logging.Logger.getLogger("net").setLevel(Level.INFO);
      Logger.getLogger("org.hibernate.SQL").setLevel(Level.FINE);
      for (Handler handler : java.util.logging.Logger.getLogger("").getHandlers()) {
         handler.setLevel(Level.ALL);
      }

      
      HibernateDatabaseConfiguration config = new HibernateDatabaseConfiguration();
      config.setConnectionDriverClass("org.firebirdsql.jdbc.FBDriver");
      config.setConnectionUrl("jdbc:firebirdsql:localhost:c:\\Users\\dominik\\wvmonitor\\wvmonitor.fdb");
      config.setConnectionUsername("sysdba");
      config.setConnectionPassword("masterkey");
      config.setShowSql(true);
      config.setDialect("org.hibernate.dialect.FirebirdDialect");
      
      DaoFactory daoFactory = new DaoFactoryImpl(config);
      
      EntityManager em = daoFactory.createEntityManager();
      
      BufferedReader input = new BufferedReader(new InputStreamReader(System.in));
      
      String s = input.readLine();
      while (!s.equals("QUIT")) {
         try {
            System.out.println("Executing: "+s);
            List result = em.createQuery(s).getResultList();
            for (Object obj : result) {
               if (obj instanceof Object[]) {
                  for (Object o : (Object[])obj) {
                     System.out.print(o.toString()+", ");
                  }
                  System.out.println();
               } else {
                  System.out.println(obj.toString());
               }
            }
         } catch (Exception e) {
            e.printStackTrace();
         }
         System.out.println("Nächste Query...");
         s = input.readLine();
      }
      
   }
   
}