Re: [enhydra] BLOB Size

["Sasa Bojanic" <s.bojanic@xxxxxxxxxxxxxx>]

Hi,

we tested DB2 sql scripts on DB2 version 8.1, and we had no problems.
The BLOB size depends on the size of  Java objects representing complex XPDL 
types. In our testWRD.xpdl example, this size is not so
big, so you could probably use 1024, but some of our users intend to use 
objects which size will be up to 1MB.
So, it depends on your XPDL processes!

Regards,
Sasa.

BTW, could you please subscribe and send questions to shark's mailing list!

----- Original Message -----
From: <gigsvoo@xxxxxxxxx>
To: <enhydra@xxxxxxxxxxxxx>
Sent: Thursday, April 29, 2004 11:27 AM
Subject: [enhydra] BLOB Size


> Hello there,
>
> I am running Enhydra Shark using IBM DB2 ver 7.2, I need to know the .sql 
> files written to setup the Shark BLOB size to be
defined, does anyone know the size in KB?
>
> I hit the following error:
>
> Create table ProcessData
> (
> Process  DECIMAL(19,0)  NOT NULL    ,
> VariableDefinitionId  VARCHAR(254)  NOT NULL    ,
> VariableValue  BLOB NOT NULL    ,
> oid  DECIMAL(19,0)  NOT NULL    ,
> version  INTEGER NOT NULL
> )
> [IBM][CLI Driver][DB2/NT] SQL0604N  The length, precision, or scale 
> attribute for column, distinct type, structured type,
attribute of structured type, function, or type mapping "VARIABLEVALUE" is 
not valid.  SQLSTATE=42611
>
> Error : Because OnErrorContinue Attribute is false application is terminated
> org.webdocwf.util.loader.LoaderException: SQLException:
>
> I check the sql file, for IBM DB2, we need to set the BLOB size like this:
>
> BLOB(1024)
>
> Could anyone please help.
>
> Thanks
>
> Neo
>
>


--------------------------------------------------------------------------------


>
> --
> You receive this message as a subscriber of the enhydra@xxxxxxxxxxxxx 
> mailing list.
> To unsubscribe: mailto:enhydra-unsubscribe@xxxxxxxxxxxxx
> For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>