We're updating the issue view to help you get more done. 

QueryCacheTest.testGetByCompositeId fails on db2-97 -- DB2 SQL Error: SQLCODE=-613

Description

org.hibernate.test.querycache.QueryCacheTest.testGetByCompositeId

Error code 613 description

Stacktrace:

Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DBALLO02.ENTITYWITHSTRINGCOMPOSITEKEY, DRIVER=4.14.113
at com.ibm.db2.jcc.am.ed.a(ed.java:677)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.oo.c(oo.java:2715)
at com.ibm.db2.jcc.am.oo.d(oo.java:2703)
at com.ibm.db2.jcc.am.oo.a(oo.java:2136)
at com.ibm.db2.jcc.am.po.a(po.java:7792)
at com.ibm.db2.jcc.t4.ab.h(ab.java:141)
at com.ibm.db2.jcc.t4.ab.b(ab.java:41)
at com.ibm.db2.jcc.t4.p.a(p.java:32)
at com.ibm.db2.jcc.t4.qb.i(qb.java:135)
at com.ibm.db2.jcc.am.oo.ib(oo.java:2105)
at com.ibm.db2.jcc.am.po.uc(po.java:3628)
at com.ibm.db2.jcc.am.po.b(po.java:4423)
at com.ibm.db2.jcc.am.po.ic(po.java:799)
at com.ibm.db2.jcc.am.po.executeUpdate(po.java:777)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:125)
... 25 more

Output:

1 2 3 4 5 ... 06:36:46,314 DEBUG SQL:104 - create table EntityWithStringCompositeKey (analog varchar(255) not null, device varchar(255) not null, deviceType varchar(255) not null, substation varchar(255) not null, primary key (analog, device, deviceType, substation)) 06:36:46,354 ERROR SchemaExport:425 - HHH000389: Unsuccessful: create table EntityWithStringCompositeKey (analog varchar(255) not null, device varchar(255) not null, deviceType varchar(255) not null, substation varchar(255) not null, primary key (analog, device, deviceType, substation)) 06:36:46,355 ERROR SchemaExport:426 - DB2 SQL Error: SQLCODE=-613, SQLSTATE=54008, SQLERRMC=ANALOG..., DRIVER=4.14.113 ...

Environment

db2-97

Status

Assignee

Brett Meyer

Reporter

Martin Šimka

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

4.2.0.CR2

Priority

Major