Netbeans HQL problem

roxviper · **Joined:** Sun Apr 12, 2009 5:19 pm **Posts:** 1

Hello ,

In short terms my problem looks like this :

I have a java project made in netbeans . I've mapped my database with hibernate (POJO file)

the from 'table' works perfectly for all my tables but when i want to use select from statement i get org.hibernate.QueryException: Unable to resolve path

Examples used Clients table ( ClientID FirstName LastName)

select Clients.FirstName from Clients
select FirstName from Clients
select a.FirstName from Clients a
select firstName from Clients

java mapping xml

<hibernate-mapping>
<class catalog="airport" name="complete.entity.Clients" table="clients">
<id name="clientId" type="java.lang.Integer">
<column name="ClientID"/>
<generator class="identity"/>
</id>
<property name="firstName" type="string">
<column length="50" name="FirstName" not-null="true"/>
</property>
<property name="lastName" type="string">
<column length="50" name="LastName" not-null="true"/>
</property>
</class>
</hibernate-mapping>

ethnarch · **Joined:** Tue Aug 01, 2006 9:24 pm **Posts:** 120

Quote:

select Clients.FirstName from Clients
select FirstName from Clients
select a.FirstName from Clients a
select firstName from Clients

Your syntax is wrong make sure that your column is the name of the property on the pojo and that you use the alias in the from clause not full class name.

If you have a class like this

Code:

public class Clients{
   String firstName;
}

then you would want your select to look like this

Code:

SELECT a.firstName FROM Clients a

[/quote]