size of a row (resultset)

Discussion in 'Java' started by Ashly, Sep 12, 2008.

  1. Ashly

    Ashly Guest

    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.
    Ashly, Sep 12, 2008
    #1
    1. Advertising

  2. On 12 Wrz, 01:29, Ashly <> 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/api/java/sql/Blob.html#length()

    Przemek
    tomaszewski.p, Sep 12, 2008
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matrix
    Replies:
    0
    Views:
    559
    Matrix
    Apr 1, 2004
  2. matrix ¿ìÀÖÄñ

    How i know the size of "resultset"?

    matrix ¿ìÀÖÄñ, Apr 3, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    3,414
    matrix ¿ìÀÖÄñ
    Apr 3, 2004
  3. =?ISO-8859-1?Q?Thomas_Gagn=E9?=
    Replies:
    1
    Views:
    469
    Lee Fesperman
    Nov 21, 2003
  4. david.karr
    Replies:
    17
    Views:
    1,132
    Arne Vajhøj
    Aug 23, 2009
  5. D
    Replies:
    0
    Views:
    197
Loading...

Share This Page