Base bug storing large files in a blob

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Base bug storing large files in a blob

Andrew Pitonyak

The following message was posted to the OOo Forum:

http://www.oooforum.org/forum/viewtopic.phtml?p=390589

I repeat the message here:

******************

I am working with OpenOffice basic, HSQlDB 2.0.

I have a table for attachments in my DB.
When i upload a File that is big for example 32 MB or 72MB in my table
which has BLOB datatype which has a length of 1073741824 - i get an EOF
exception at the following line in my code

oSimpleFileAccess.writeFile(staticpath & FileName, oBinaryField1)

BASIC runtime error.
An exception occured.
Type: com.sun.star.sdbc.SQlException
Message: org.hsqldb.HsqlException: java.io.EOFException

This is the point at which i get the BLOB data that is saved in my table
and write it to a defined path and then read it from there. When i
upload small files ....everything works smoothly.

**************

Sounds like a bug to me... Is this plausible?

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Base bug storing large files in a blob

Frank Schönheit
Hi Andrew,

sorry for the delay, hope the answer is still of some use.

> ******************
>
> I am working with OpenOffice basic, HSQlDB 2.0.
>
> I have a table for attachments in my DB.
> When i upload a File that is big for example 32 MB or 72MB in my table
> which has BLOB datatype which has a length of 1073741824 - i get an EOF
> exception at the following line in my code
>
> oSimpleFileAccess.writeFile(staticpath & FileName, oBinaryField1)
>
> BASIC runtime error.
> An exception occured.
> Type: com.sun.star.sdbc.SQlException
> Message: org.hsqldb.HsqlException: java.io.EOFException
>
> This is the point at which i get the BLOB data that is saved in my table
> and write it to a defined path and then read it from there. When i
> upload small files ....everything works smoothly.
>
> **************
>
> Sounds like a bug to me... Is this plausible?

Sure. Would need investigation whether this is on HSQL or OOo side, but
pretty much sounds like a bug to me as well.

Ciao
Frank

--
ORACLE
Frank Schönheit | Software Engineer | [hidden email]
Oracle Office Productivity: http://www.oracle.com/office

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]