Native Queries

[Nikhil Jain]

1. Query createNativeQuery(String sql, Class entityClass)

Does this only work for query returning all values of entity class. For example (select * from employee, employee.class).

I tried this using select name, age from employee, employee.class. This did not work.

I tried the above by using @ResultSetMapping.
@SqlResultSetMapping(name="myquery", entities={@EntityResult(entityClass=Employee.class, fields={@FieldResult(name="name", column="name")})})

Query query = em.createNativeQuery("SELECT name FROM EMPLOYEE", "myquery");
List result = query.getResultList();

[Christophe Verré]

Does this only work for query returning all values of entity class. For example (select * from employee, employee.class).

No, you can select any field of the entity. Note that you don't especially need a FieldResult here. What error did you get ?
[ June 25, 2008: Message edited by: Christophe Verre ]

[Nikhil Jain]

@SqlResultSetMapping(name="myquery", entities={@EntityResult(entityClass=Customer.class, fields={@FieldResult(name="name", column="name")})})

Caused by: java.sql.SQLException: Column 'customerid129_0_' not found.

This works well If I get dont't use @FieldResut & e select * from customer.

I am trying to execute
Query query = em.createNativeQuery("select c.name from customer c", "myquery");

1. I wanted to use @resultset mapping such that I could get customer object & I could use customer.getName().

Am I going in the right direction?

[Nikhil Jain]

Likewise if I use

Query query = em.createNativeQuery("select c.customerId, c.name, c.age from customer c", Customer.class);

this works

but
Query query = em.createNativeQuery("select c.name from customer c", Customer.class);
this does'nt work.
Error: Caused by: java.sql.SQLException: Column 'customerid' not found.

It seems that these only work for queries when it fetches all the columns?

[Mirko Bonasorte]

I have a doubt: have you got a case-sensitive database?
I had the same problem with mysql.

[Nikhil Jain]

I don't think thats the problem with me. Else other queries would'nt have worked?

[Sergio Tridente]

Originally posted by Anu Tilwalli:
Likewise if I use

Query query = em.createNativeQuery("select c.customerId, c.name, c.age from customer c", Customer.class);

this works

but
Query query = em.createNativeQuery("select c.name from customer c", Customer.class);
this does'nt work.
Error: Caused by: java.sql.SQLException: Column 'customerid' not found.

It seems that these only work for queries when it fetches all the columns?

Can you post the complete code (specially the @ResultSetMapping annotation) and the table definition?