CODEWITHSUNDEEP
javaoracle-databasehibernatehql
learner
learner

Reputation: 461

org.hibernate.hql.internal.ast.QuerySyntaxException: expecting CLOSE, found '('

I have to read a multivalue field in oracle and values are of float type.i have to find all the rows with field value having 3.1.

So my HQL query is

select d.NAME, d.FLOATCOMMA_MV from cc_mv_test d where :param1 in elements (TO_BINARY_FLOAT(d.FLOATCOMMA_MV))

and after using TO_BINARY_FLOAT i am getting error org.hibernate.hql.internal.ast.QuerySyntaxException: expecting CLOSE, found '(' near line 1.

Please help.

Upvotes: 0

Views: 1411

Answers (1)

Maciej Kowalski
Maciej Kowalski

Reputation: 26502

This is a native query, not HQL.

Use session.createSQLQuery("query").list() method.

Keep in mind that the return type will be List<Object[]>.

Upvotes: 1

Related Questions