Mail Archive Home | enhydra List | April 2004 Index
| <-- Date Index --> | <-- Thread Index --> |
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 --> |
Powered by MHonArc.
Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.