I created a table use SQL: CREATE TABLE system_signal_info ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, ctime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, mtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, config_def BOOLEAN NOT NULL DEFAULT TRUE, signal_id INT UNSIGNED N…

I do something like: session.createQuery("from SystemSignalInfoHbn where i_signal_id = :signal_id").setParameter("signal_id", it.next().getId()).uniqueResult(); but it cause an error followed(ERROR: Unknown column ‘i_signal_id’ in ‘where clause’): Hibernate: select systemsign0_.id as id1_24_, sys…

You get an error because in your JPQL query you are not referencing an entity property. So, instead of: [image] Ansersion: session.createQuery(“from SystemSignalInfoHbn where i_signal_id = :signal_id”).setParameter(“signal_id”, it.next().getId()).uniqueResult(); You should use: session.cre…

I think I start to get a little sense: Do you mean that: if I query like session.createQuery(“from SystemSignalInfoHbn where signalId = :signal_id”).setParameter(“signal_id”, it.next().getId()).uniqueResult(); and the hibernate will help me use the ‘index-searching’(like search ‘i_signal_id’ wit…

and the hibernate will help me use the ‘index-searching’(like search ‘i_signal_id’ with sql) automaticly? No. That’s not how it works. Again, Hibernate does not do anything related to indexes. The fact that the signal_id column has an index will be considered by the query optimizer. For getting …

I think I understand it now. Really really really thanks!

How can I use a database index with HQL

Hibernate ORM

vlad May 21, 2018, 5:45am 2

You don’t need to map an index in Hibernate mappings. HQL is translated to SQL, and if the DB decides if an index makes sense to be used for the SQL query, it will be used automatically.

Topic		Replies	Views
Hibernate3 force index? Hibernate ORM	0	911	March 10, 2020
Specify index on query Hibernate ORM	1	670	July 29, 2018
How can I make Hibernate ignore my custom index? Hibernate ORM	14	2261	August 2, 2022
Entity Not indexed automatically with JPQL Update Hibernate Search	2	800	March 8, 2019
Hibernate Tools failing to get index info from Postgres tables Hibernate Tools	1	3006	June 20, 2018

How can I use a database index with HQL

Related topics