question regaring to "The length of the Procedure parameter"

[katherine]

Hi,

I wrote a procedure in my view model. The procedure takes a "blob" data type as input parameter.

I was testing my code and noticed that when the input blob contains 20000 of double precision values, executing the procedure throws exceptions:

org.teiid.core.TeiidComponentException : TEIID20013 java.net.SocketException: Connection reset by peer: socket write error.

if I change the input blob to contains only 1000 of double precision values, it works fine.

In my view model, I set the "Length" of the procedure parameter to 2000000000. What is the unit of the length?

What is the maximum length of the "blob" data type that Teiid allows?

Can someone help me on this?

Thank you.

Katherine

[rareddy]

There is no limit on BLOB/CLOB/SQLXML types.  Which version of Teiid? How are you building your blob? is it serializable?

[shawkins]

The length limit is effectively 2^31-1 (the max signed 32 bit int).  For blobs/sqlxml length is the byte length and for clobs is the character length.  In any case the metadata here should not be causing the exception.

As for the exception if you are on 8.3, you may be hitting https://issues.jboss.org/browse/TEIID-2505 you should try using the 8.4 client driver.

Steve