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

View raw message