Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column STRINGVALUE_: STRINGDECODE

[santy79]

Hi,

I'm facing an issue when I try to pass a huge string value between jBPM and ESB.

I'm getting "Caused by:org.h2.jdbc.JdbcSQLException: Value too long for column STRINGVALUE_: STRINGDECODE" exception.

I'm attaching the processDefinition.xml and jboss-esb.xml for reference. From my first ESB service, I'm sending 2 small string values. Those are getting passed to the subsequent nodes. But from my second ESB service, I'm setting a huge response in the message body and sending it back to bpm. This is where i'm getting the exception mentioned. Please help.

Also, I've attached the issue log. Here, you could see a huge XML data that is getting printed. I'm setting this value in the ESB message and passing it to bpm.

Note:- Without changing the table column length how to proceed further with huge XMLs passing back and forth.

[ray.ploski]

Since there are no long-running nor human-based tasks you should consider using splitter and aggregation functions of JBossESB.  Your configuration may look somewhat like this and you can then remove the process-definition and the concerns of large response values.

{code:XML}
<?xml version = "1.0" encoding = "UTF-8"?>

<jbossesb

    xmlns="http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.2.0.xsd"
 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 
    xsi:schemaLocation="http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.2.0.xsd http://anonsvn.jboss.org/repos/labs/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.2.0.xsd"
    parameterReloadSecs="5">
    <services>
        <service category="apicategory" name="apiservice" description="Service">
            <actions mep="RequestResponse">
                <action name="operation" process="process">
                </action>
                <!--  Split the execution to multiple services simultaneously -->
                <action name="SplittingRouter">
                    <property name="destinations">
                        <route-to service-category="remixcategory" service-name="remixservice" />
                        <route-to service-category="rmscategory" service-name="rmsservice" />
                    </property>
                </action>
            </actions>
        </service>
 
        <service category="remixcategory" description="Service"
            invmScope="GLOBAL" name="remixservice">
            <actions mep="RequestResponse">
                <action name="operation" process="process" />
            </actions>
            <action name="routeToAggregator">
                <property name="destinations">
                    <route-to service-category="epscategory" service-name="epsservice" />
                </property>
            </action>
        </service>

        <service category="rmscategory" description="Service"
            invmScope="GLOBAL" name="rmsservice">
            <actions mep="RequestResponse">
                <action name="operation" process="process" />
            </actions>
            <action name="routeToAggregator">
                <property name="destinations">
                    <route-to service-category="epscategory" service-name="epsservice" />
                </property>
            </action>
        </service>

        <service 
              category="epscategory" name="epsservice" 
              invmScope="GLOBAL"
              description="Aggregates messages">
              <actions mep="RequestResponse">
                    <!--  Wait for the aggregation of the multiple streams for no more than 60000 ms -->
                  <action name="Aggregator">
                      <property name="timeoutInMillies" value="60000"/>
                  </action>
                  <!-- add transformation action to aggregate the attachments into 1 message -->
                 <action class="com.bby.esb.EPS" name="operation" process="process"/>
              </actions>
          </service>             
    </services>
</jbossesb>
{code}