HSQL Select column AS Alias - java.sql.SQLException

krisreid · **Joined:** Sun Oct 11, 2009 7:17 pm **Posts:** 8

Hi

I have the below SQL query

Code:

String SQL_QUERY = "SELECT c.ID AS customerName, com.name AS companyName FROM customers c, company com";
      
System.out.println(SQL_QUERY);
   
Session s = HibernateUtil.getCurrentSession();
s.createSQLQuery(SQL_QUERY).list();

This results in java.sql.SQLException: Column 'ID' not found.

Why? O'why?
Has been driving me nuts. The SQL is valid as I copy/past the println into mysql and it loves it!

Cheers

Kris