SQL Query should support named parameters or JPA-style positional parameters

Description

We get deprecation warning from Hibernate when running with GigaSpaces 14.x or 15.0. There is no run-time error, but a warning always indicates a potential problem, and messes up our monitoring tools in Production environment:

org.hibernate.hql.internal.ast.HqlSqlWalker - [DEPRECATION] Encountered positional parameter near line 1, column 88 in HQL: [FROM com.cbksec.fortune.common.domain.message.AccountMessage WHERE (messageDateTime >= ? and tradingAccountId = ?) AND (Lifecycle_Stage='HISTORY')]. Positional parameter are considered deprecated; use named parameters or JPA-style positional parameters instead.

Currently GigaSpaces query interface does not support named parameters or JPA-style positional parameters. If I attempt to include in GigaSpaces SQLQuery a named parameter (for example, "myProperty = :myValue"), or a JPA-style positional parameter (for example, "myProperty = ?1"), GigaSpaces query parser reports a syntax error.

Please make sure that in normal case GigaSpaces is able to run without runtime warnings. A warning shall indicate an abnormal condition, not the usual daily case.

Acceptance Test

None

Assignee

Unassigned

Reporter

Yuval Dori

Labels

None

Priority

Medium

SalesForce Case ID

None

Fix versions

None

Commitment Version/s

None

Due date

None

Product

XAP

Edition

Premium

Platform

All
Configure