Hi all,
I am getting exception while tyring to use Aggregate function as
follows in Hibernate3.0.
String SQL_QUERY = "select SUM(creation_date) from
customer_account";
SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
Session session = sessionFactory.openSession();
Query query = session.createSQLQuery(SQL_QUERY);
Configuration Details:
************************
I am using Hibernate3.0 with MYSql Database.
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<property name="dialect">org.hibernate.dialect.MySQLMyISAMDialect</property>
Exception Got:
*****************
SQLException.
Note:
******
I am able run this query successfully when i dont use Aggregate function.
Pls Help me regarding this dialect problem.
Thanks in Advance,
sundar.