activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Strachan" <>
Subject Re: Data size bigger than max size for this type
Date Fri, 30 Mar 2007 10:45:20 GMT
On 3/30/07, ron55test <> wrote:
> The column is of type blob.
> This is what the table structure is as created by activemq:
>    (    "ID" NUMBER(32,0) NOT NULL ENABLE,
>         "CONTAINER" VARCHAR2(250),
>         "MSGID_PROD" VARCHAR2(250),
>         "MSGID_SEQ" NUMBER(32,0),
>         "MSG" BLOB,
>          PRIMARY KEY ("ID")
> )

It looks like the BLOB type is 4Gb long

so I'm not sure thats the problem. I suspect it may be due to the  way
in which the JDBC code works with the BLOB column type. This article
appears to suggest that the preferred way to work with Oracle BLOBs is
using the Blob type

so I've patched trunk of the Oracle adapter to use this approach
instead. Any chance you could build trunk and see if this fixes your

I've raised this issue to track the issue



View raw message