DB Logging with DB2 - server fails to start
-------------------------------------------
Key: TEIID-3261
URL:
https://issues.jboss.org/browse/TEIID-3261
Project: Teiid
Issue Type: Bug
Reporter: Jan Stastny
Assignee: Steven Hawkins
When using DB Logging with DB2 database an error occurs during server start:
13:02:15,237 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool
-- 56) HHH000389: Unsuccessful: create table commandlog (id bigint not null,
applicationname varchar(255), executionid varchar(50), modelname varchar(255), principal
varchar(50), queryplan blob(255), requestid varchar(50), row_count integer, sessionid
varchar(50), sourcecommand smallint, sourcerequestid bigint, sqlcmd varchar(8196),
eventtype varchar(10), logtime timestamp, transactionid varchar(256), translatorname
varchar(50), vdbname varchar(255), vdbversion integer, primary key (id))
13:02:15,238 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool
-- 56) DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;DBALLO00,
DRIVER=4.12.55