Is it possible to write JPQL to search over embedded Map? For example we have Article entity having Map<String, String> ‘data’ which is converted to JSON using @Converter. This means no additional table is created, only additional column to store JSON. Now I have to write a query which will filter…

If the underlying column type is a JSON-like DDL type, then the JPQL functions key and value won’t work, as these functions only work if you map to tables. You will have to use the proprietary JSON functions of your DBMS( MySQL :: MySQL 8.0 Reference Manual :: 12.18.3 Functions That Search JSON Value…

Thanks a lot! So far it looks like I’ll stick to additional table rather than overengineering JSON field. For the most of searches I use Lucene and this one is to use with autocomplete where I need substrings from one to ‘n’ characters in length and Lucene is not the best tool for such a case. [ad…

I don’t know if I would say using JSON here is overengineered. I just think that your use case, filtering JSON key-value-pairs where the key and the value have to match a pattern, is a bit complicated to implement. We can certainly make some things easier, like extracting values for multiple (static…

Hi! I found slightly better solution - stored procedure. It’s more portable to some other database because MySQL specific thing “json_search” is now wrapped inside stored procedure and Java part is only call to this procedure. Every new database should implement “findByBeginsWith()” and Java part …

@beikov Are there new features with hibernate 6.2 that make it possible to search in embedded maps?

Please create a new topic for this question and add some more details about what you are trying to achieve.

JPQL on embedded Map

Hibernate ORM

Christian_Thiel May 22, 2023, 11:10am 8

@beikov Thanks for the quick reply. I created this topic.

Topic		Replies	Views
Search in embedded Map stored as Jsonb Hibernate ORM	1	871	May 22, 2023
Create FunctionContributor for postgres jsonb operators Hibernate ORM	1	159	September 23, 2025
Hibernate query language for JSONB (PostgreSQL) syntax Hibernate ORM	0	2024	December 11, 2019
Set of string-tupels as parameter for IN Hibernate ORM	2	1001	December 22, 2023
Search on a jpaquery Hibernate Search	1	349	February 2, 2023

JPQL on embedded Map

Related topics