use column name instead of entity property in JPQL

Question

I have JPQL/Hibernate for DA layer. I have a table as following:

CREATE TABLE Log_Tbl
(
id number,
name varchar2(30),
);

and I have a entity for above table as following:

@Entity
@Table(name = "Log_Tbl")
public class ELog
{
  @Column(name = "id")
  private long entity_id;

  @Column(name = "name") 
  private String entity_name;
}

and map Log entity to Log_Tbl table by jpa; I have two JPQL queries as following:

select ELog from ELog where entity_name = 'Job'
select ELog from ELog where name = 'Job'

Both queries returned the correct result. My question is:

Why does the second query return the correct result although I used the column name instead of the entity_name property?

@NeilStockton but second query executed and answered fine also — Sam
– Sam, Commented Dec 7, 2014 at 17:37
and as I said, it is invalid JPQL, and if it works in your JPA implementation then you can't rely on it in ANY other — Neil Stockton
– Neil Stockton, Commented Dec 7, 2014 at 17:49
@NeilStockton I means is your answer, really it is dependent to JPA implementation? (in my situation its Hibernate) — Sam
– Sam, Commented Dec 7, 2014 at 18:33

Community · Accepted Answer · 2017-05-23 11:51:23Z

4

To quote a post to a similar (if not duplicate) question

When you use something that isn't known by Hibernate in the WHERE clause of an HQL query (e.g. a function that is not registered in the SQL dialect), Hibernate acts smartly and passes it directly to the database.

So, it does work but it is vendor specific and probably wouldn't work if you switched your JPA implementation.

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Dec 8, 2014 at 11:12

Predrag Maric

24.5k5 gold badges57 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sam Over a year ago

Yes, My goal is ensure that it is vendor specific and maybe not worked on another JPA implementations.

Collectives™ on Stack Overflow

use column name instead of entity property in JPQL

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related