[OPENJPA-2242] Hard coded column size in CAST(? AS VARCHAR(254)) for DB2 caused runtime failure

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.0.1, 2.1.2, 2.2.1, 2.3.0
• Component/s: sql
• Patch Info: Patch Available
• Assignee: Albert Lee
• Reporter: Albert Lee
• Created: 26/Jul/12 18:58
• Updated: 21/Sep/16 14:38

Description

When procedure call is used in criteria builder as described in the following code snippet,
a hard coded column size in CAST(? AS VARCHAR(#)) for DB2 is generated and caused run-time failure with a SQLCODE=-302, SQLSTATE=22001

CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<SimpleEntity> criteriaQuery = cb.createQuery(SimpleEntity.class);
Root<SimpleEntity> simpleEntity = criteriaQuery.from(SimpleEntity.class);

Expression<String> func1 = null;
Expression<Double> func2 = null;
func2 = cb.function(
"st_point",
Double.class,
cb.literal("abcd......"), // error if String.length > 254
cb.literal(1003));
}