[jboss-jira] [JBoss JIRA] (DROOLS-1067) Oracle DB issue for findTasksByVariableAndValue

[Maciej Swiderski (JIRA)]

    [ https://issues.jboss.org/browse/DROOLS-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13167753#comment-13167753 ] 

Maciej Swiderski commented on DROOLS-1067:
------------------------------------------

this is not really kie server issue but general jbpm issue and is caused by JBPM-4889 (https://github.com/droolsjbpm/jbpm/commit/c56837e9efee4d7f4c3b931887561639954f8c58) as it set default size of column to 5000 which makes it too big for regular varchar in Oracle and makes it a LONG/LOB that cannot be used in queries. I'll lower it down to 4000 which is max for varchar2

> Oracle DB issue for findTasksByVariableAndValue
> -----------------------------------------------
>
>                 Key: DROOLS-1067
>                 URL: https://issues.jboss.org/browse/DROOLS-1067
>             Project: Drools
>          Issue Type: Bug
>          Components: kie server
>    Affects Versions: 6.4.0.Beta2
>         Environment: Kie server 6.4.0-SNAPSHOT
> Database - Oracle 11gR2
>            Reporter: Karel Suta
>            Assignee: Maciej Swiderski
>              Labels: reported-by-qe
>         Attachments: stacktrace.txt
>
>
> Tried to run Kie server integration tests against database Oracle 11gR2. Got an error listed as attachment in test UserTaskServiceIntegrationTest.testFindTasksByVariableAndValue() .
> Error is thrown when test calls: taskClient.findTasksByVariableAndValue("yoda", "_string", "john is working on it", null, 0, 10)



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)