db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: Problems assigning null to VARCHAR FOR BIT DATA types
Date Mon, 10 Apr 2006 08:10:46 GMT
>>>>>>>>>>>> Wynne Crisman wrote (2006-04-09 17:25:17):
> Is it possible to assign a null value to a VARCHAR FOR BIT DATA column?  I
> am getting the following exception from the derby driver:
>
> SQL Exception: An attempt was made to get a data value of type 'VARCHAR ()
> FOR BIT DATA' from a data value of type 'BLOB'.

Seems to me that you have done setNull(n, Types.BLOB) while you should
have done setNull(n, Types.BINARY)

-- 
Bernt Marius Johnsen, Database Technology Group, 
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

Mime
View raw message