size of a row (resultset)
 

Hi All,

I am new to this group.

I have a problem. I need to construct an XML with the contents of a
database row, But the XML should be less than 500MB. The select query
returns 100 rows and each row contains a BLOB field. Is there any way
to calculate the size of a row in bytes?

Waiting for your help. Thanks in advance.

Best Regards,
Ashly.

Re: size of a row (resultset)
 

On 12 Wrz, 01:29, Ashly <ashly....@gmail.com> wrote:
> Hi All,
>
> I am new to this group.
>
> I have a problem. I need to construct an XML with the contents of a
> database row, But the XML should be less than 500MB. The select query
> returns 100 rows and each row contains a BLOB field. Is there any way
> to calculate the size of a row in bytes?
>
> Waiting for your help. Thanks in advance.
>
> Best Regards,
> Ashly.

Maybe this link will be helpful:
http://java.sun.com/javase/6/docs/ap...b.html#length()

Przemek