I need to execute a SELECT with GROUP_CONCAT but I recieved this error all the time. This is the query: “select bk.categoria,GROUP_CONCAT(bk.nombre),GROUP_CONCAT(bk.id) from modelos.Productos as bk where bk.code=‘25416854168746541’ group by bk.categoria ORDER BY bk.categoria,bk.nombre ASC” And th…

I finally solve that adding a configuration on the sessionfactoryutil: import org.hibernate.cfg.Configuration; import org.hibernate.dialect.function.StandardSQLFunction; import org.hibernate.type.StringType; // ... private static SessionFactory sessionFactory; static { Configuration c…

I cant use group_concat in queries

Hibernate ORM

absant1 May 13, 2018, 2:52pm 5

Thank you so much vlad

Topic		Replies	Views
java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.AggregateNode Hibernate ORM	1	1860	July 14, 2022
Hibernate throws "Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause" - SQL Server Hibernate ORM	1	5935	November 23, 2018
Migration of dialect to Hibernate 6 Hibernate ORM	29	22147	October 26, 2023
HQL group by eror Hibernate ORM	1	145	August 26, 2024
Criteria - Select vs Group By with case Hibernate ORM	4	708	August 2, 2023

I cant use group_concat in queries

Related topics