ObjectWeb Consortium
Search ObjectWeb Mail Archive: 

Advanced Search - Powered by Google


Mail Archive Home | enhydra List | April 2004 Index

<--  Date Index  --> <--  Thread Index  -->

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



<--  Date Index  --> <--  Thread Index  -->

Reply via email to:

Powered by MHonArc.

Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.