<hibernate-mapping>
    <class name="be.xxx.model.LoggingLine" table="SXXX_LOGGING_LINE">
        <id name="id" column="LGLN_ID" unsaved-value="0">
            <generator class="increment" />
        </id>
        <many-to-one name="app" class="be.xxx.model.Application" column="APP_ID_FK" not-null="true" />
        <property name="logDate" column="LGLN_TIME_LOG_DATE" not-null="true" />
        <property name="sessionId" column="LGLN_SESSION_ID" not-null="true" />
        <property name="userId" column="LGLN_USER_ID" not-null="false" />
        <property name="url" column="LGLN_URL" not-null="true" />
        <property name="action" column="LGLN_ACTION" not-null="false" />
        <property name="delta" column="LGLN_DELTA" not-null="true" />
    </class>
</hibernate-mapping>

<hibernate-mapping>
    <class name="be.xxx.model.Application" table="SXXX_APPLICATION">
        <id name="id" column="APP_ID" unsaved-value="0">
            <generator class="increment" />
        </id>
        <property name="name" column="APP_NAME" not-null="true" />
        <property name="code" column="APP_CODE" not-null="true" />
        <property name="type" column="APP_TYPE" not-null="true" />
    </class>
</hibernate-mapping>

SELECT TO_CHAR( LGLN_TIME_LOG_DATE,'YYYYMMDDHH24MI') tijd, count(TO_CHAR( LGLN_TIME_LOG_DATE,'YYYYMMDDHH24MI')) freq
FROM SXXX_LOGGING_LINE
GROUP BY TO_CHAR( LGLN_TIME_LOG_DATE,'YYYYMMDDHH24MI')
ORDER BY TO_CHAR( LGLN_TIME_LOG_DATE,'YYYYMMDDHH24MI') ;

    public List getCountPerMinute(int applicationId, Date beginDatum, Date eindDatum) {
            String[] id = { "id" };
            Object[] appId = { new Integer(applicationId) };
            List listApp=getHibernateTemplate().findByNamedParam("select a from Application as a where a.id=:id order by a.id", id, appId );
            Application a = (Application)listApp.get(0);
            SimpleDateFormat df = new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
            String[] app= {"app","bdate","edate"};
            Object[] appApp = {a,df.format(beginDatum),df.format(eindDatum)};
            String sql="SELECT l.logDate, ";
            sql+="COUNT(l.logDate)";
            sql+="FROM LoggingLine as l ";
            sql+="WHERE l.app=:app ";
            sql+="AND l.logDate BETWEEN to_date(:bdate,'DD/MM/YYYY HH24:MI:SS') AND to_date(:edate,'DD/MM/YYYY HH24:MI:SS') ";
            sql+="GROUP BY l.logDate ";
            sql+="ORDER BY l.logDate ";
            List listCount = getHibernateTemplate().findByNamedParam(sql,app,appApp); 
            return listCount;
    }

            String sql="SELECT to_char(l.logDate,'YYYYMMDDHH24MI') , ";
            sql+="COUNT(to_char(l.logDate,'YYYYMMDDHH24MI')) ";
            sql+="FROM LoggingLine as l ";
            sql+="WHERE l.app=:app ";
            sql+="AND l.logDate BETWEEN to_date(:bdate,'DD/MM/YYYY HH24:MI:SS') AND to_date(:edate,'DD/MM/YYYY HH24:MI:SS') ";
            sql+="GROUP BY to_char(l.logDate,'YYYYMMDDHH24MI') ";
            sql+="ORDER BY to_char(l.logDate,'YYYYMMDDHH24MI')";

DEBUG - SessionFactoryUtils.getSession(324) [HTTPThreadGroup-3] | Opening Hibernate session
DEBUG - SessionImpl.<init>(220) [HTTPThreadGroup-3] | opened session at timestamp: 11726591728
DEBUG - QueryPlanCache.getHQLQueryPlan(70) [HTTPThreadGroup-3] | unable to locate HQL query plan in cache; generating (SELECT to_char(l.logDate,'YYYYMMDDHH24MI') , COUNT(to_char(l.logDate,'YYYYMMDDHH24MI')) FROM LoggingLine as l WHERE l.app=:app AND l.logDate BETWEEN to_date(:bdate,'DD/MM/YYYY HH24:MI:SS') AND to_date(:edate,'DD/MM/YYYY HH24:MI:SS') GROUP BY to_char(l.logDate,'YYYYMMDDHH24MI') ORDER BY to_char(l.logDate,'YYYYMMDDHH24MI'))
DEBUG - QueryTranslatorImpl.compile(214) [HTTPThreadGroup-3] | compiling query
DEBUG - SessionFactoryUtils.doClose(734) [HTTPThreadGroup-3] | Closing Hibernate session
DEBUG - SessionImpl.close(273) [HTTPThreadGroup-3] | closing session
DEBUG - ConnectionManager.cleanup(373) [HTTPThreadGroup-3] | connection already null in cleanup : no action
ERROR - ClickstreamDAOHibernate.getCountPerMinute(217) [HTTPThreadGroup-3] | org.springframework.orm.hibernate3.HibernateQueryException: undefined alias: to_char [SELECT to_char(l.logDate,'YYYYMMDDHH24MI') , COUNT(to_char(l.logDate,'YYYYMMDDHH24MI')) FROM be.xxx.model.LoggingLine as l WHERE l.app=:app AND l.logDate BETWEEN to_date(:bdate,'DD/MM/YYYY HH24:MI:SS') AND to_date(:edate,'DD/MM/YYYY HH24:MI:SS') GROUP BY to_char(l.logDate,'YYYYMMDDHH24MI') ORDER BY to_char(l.logDate,'YYYYMMDDHH24MI')]; nested exception is org.hibernate.QueryException: undefined alias: to_char [SELECT to_char(l.logDate,'YYYYMMDDHH24MI') , COUNT(to_char(l.logDate,'YYYYMMDDHH24MI')) FROM be.xxx.model.LoggingLine as l WHERE l.app=:app AND l.logDate BETWEEN to_date(:bdate,'DD/MM/YYYY HH24:MI:SS') AND to_date(:edate,'DD/MM/YYYY HH24:MI:SS') GROUP BY to_char(l.logDate,'YYYYMMDDHH24MI') ORDER BY to_char(l.logDate,'YYYYMMDDHH24MI')]

    public List getCountPerMinute(int applicationId, Date beginDatum,
                                  Date eindDatum) {
        Application a = getApplication(applicationId);
        String sql =
            "SELECT to_char(l.logDate,'YYYYMMDDHH24MI') , COUNT(to_char(l.logDate,'YYYYMMDDHH24MI')) FROM LoggingLine as l WHERE l.app=:app AND l.logDate BETWEEN to_date(:bdate,'DD/MM/YYYY HH24:MI:SS') AND to_date(:edate,'DD/MM/YYYY HH24:MI:SS') GROUP BY to_char(l.logDate,'YYYYMMDDHH24MI') ORDER BY to_char(l.logDate,'YYYYMMDDHH24MI')";
        Query query = getQuery(a, sql);
        SimpleDateFormat df = new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
        query.setParameter("bdate", df.format(beginDatum));
        query.setParameter("edate", df.format(eindDatum));
        return query.list();
    }

    private Query getQuery(Application a, String sql) {
        Session session = this.getSession();
        Query query = session.createQuery(sql);
        query.setCacheable(true);
        query.setParameter("app", a);
        return query;
    }

<prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>

<prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>