[JBPAPP-1895] ANN-823 - Unit tests fail because Insert into ... values(upper(?)) fails on DB2 - Red Hat Issue Tracker

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Done
Affects Version/s: EAP 5.0.0, 4.2.0.GA_CP08, 4.3.0.GA_CP07, EAP 5.0.1.CR1, EAP 5.0.1.CR2, EAP 5.0.1, 4.2.0.GA_CP09, 4.3.0.GA_CP08
Fix Version/s: EAP_EWP 5.1.0, 4.3.0.GA_CP09, 4.2.0.GA_CP10
Component/s: Hibernate
Labels:
None
Environment:

DB2 V91

Affects:

Release Notes
Workaround Description:

Hide

The solution is to use a CAST around the parameter marker to tell DB2 what
type to expact. For example:
UPPER(CAST(? AS CHAR(10))
UPPER(CAST(? AS VARCHAR(50))
The Db2 knows what type to use for the parameter marker and the function can
be properly resolved.

http://bytes.com/topic/db2/answers/182742-sql0418n-error-untyped-parameter-markers-cannot-used-some-cases

Show
The solution is to use a CAST around the parameter marker to tell DB2 what type to expact. For example: UPPER(CAST(? AS CHAR(10)) UPPER(CAST(? AS VARCHAR(50)) The Db2 knows what type to use for the parameter marker and the function can be properly resolved. http://bytes.com/topic/db2/answers/182742-sql0418n-error-untyped-parameter-markers-cannot-used-some-cases
Release Notes Docs Status:
Not Required

is related to

JBPAPP-948 HHH-3501 - ASTParserLoadingTest testing unsupported queries for DB2