Re: [jrf-user] Nullable Blobs

[Thom C. <TCa...@ps...>]

We had a similar problem on Oracle.

A solution that worked for us was to set the default value for the blob
field to be "empty_blob()",
which is distinctly different from <null>, and everything was happy.

I do not know if this is a common function available in other
databases, so yours would definitely
be a more universal approach.

Thom

>>> "Cinq - Glaucio Polzin de Oliveira" <g.p...@ci...>
11/19/2002 9:29:12 PM >>>

Hi,
I was using Blobs with JRF and MySql. I had problems when my blob
column was nullable (new NullableColumnOption() in my setup method).
When it is null and I tried to save it, I got a NullPointerException.
It happened because the method getColumnValueFrom in the
net.sf.jrf.column.columnspecs.BlobColumnSpec class was not testing if
the BlobWrapper is null or not:
BlobWrapper b = (BlobWrapper) value;
b.storeData(stmt, position, super.i_sqlType);
when b is null, I get a NullPointerException.

I've found a very simple solution: verify if b is not null:
BlobWrapper b = (BlobWrapper) value;
if (b != null)
   b.storeData(stmt, position, super.i_sqlType);
else
   stmt.setNull(position, null, super.i_sqlType);

I did the same thing when this is selected from the database in the
getColumnValueFrom from the same class:
Blob value = jrfResultSet.getBlob(this.getColumnIdx());
return (value == null ? null : new BlobWrapper(value));

Am I wrong? Did someone have this problem?
I am using the 'IBM Websphere Studio Application Developer' to
program.
Thanks

Glaucio

__________________________________
Cinq Technologies - http://www.cinq.com.br 
------------------------------------------------------- This sf.net
email is sponsored by: To learn the basics of securing your web site
with SSL, click here to get a FREE TRIAL of a Thawte Server Certificate:
http://www.gothawte.com/rd524.html
_______________________________________________ jrf-user mailing list
jrf...@li...
https://lists.sourceforge.net/lists/listinfo/jrf-user