[teiid-issues] [JBoss JIRA] (TEIID-2976) Using new database logging extension, getting error that indicates column isn't long enough

[Andrej Šmigala (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrej Šmigala reopened TEIID-2976:
-----------------------------------


It appears 100 is still not enough, as I get the following:
{code}
org.h2.jdbc.JdbcSQLException: Value too long for column "TRANSACTIONID VARCHAR(100)": "'TransactionImple < ac, BasicAction: 0:ffff0a221e8b:29f70065:54450202:1a statu
s: ActionStatus.RUNNING >' (102)"; SQL statement:
insert into commandlog (applicationname, executionid, modelname, principal, queryplan, requestid, rowcount, sessionid, sourcecommand, sourcerequestid, sqlcmd, eventtype, logtim
e, transactionid, translatorname, vdbname, vdbversion, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-168]
{code}

This is with XA transaction involving Oracle 11g and DB2 8.1 datasources

> Using new database logging extension, getting error that indicates column isn't long enough
> -------------------------------------------------------------------------------------------
>
>                 Key: TEIID-2976
>                 URL: https://issues.jboss.org/browse/TEIID-2976
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>            Reporter: Van Halbert
>            Assignee: Ramesh Reddy
>            Priority: Critical
>             Fix For: 8.7.1
>
>
> Getting the following sporadically:
> 11:57:57,538 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (pool-2-thread-1) Value too long for column "TRANSACTIONID VARCHAR(50)": "'TransactionImple < ac, BasicAction: 0:ffffc0a80102:307704ce:5388aa39:169 status: ActionStatus.RUNNING >' (103)"; SQL statement:
> insert into commandlog (id, applicationname, executionid, modelname, plan, principal, requestid, rowcount, sessionid, sourcecommand, sourcerequestid, sqlcmd, eventtype, logtime, transactionid, translatorname, vdbname, vdbversion) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-168]



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)