[comp.lang.java.databases] Cloudscape (Derby) issue with BLOB fields

[Dy...@Sun.COM]

Hi all,

I have a problem with filling data into cludscape database. I have a 
procedure which reads some 4000 pictures (10k in average) from mysql 
database and put those in cloudscape database.
Procedure is written in Java and use jdbc drivers.

After some 1000 pictures written I got SQLException with no stack trace and 
with "java.lang.OutOfMemoryError" message.

So, I suppose jdbc driver caught OutOfMEmoryException and wrapped it with 
new SQLException which I got...

Is someone experiencing the same problem? Can cloudscape handle 200MB of 
BLOBs? How can cludscape deal with 'stress' situations (I mean when I wan't 
need to put in it 200 megs of something in it) 

Re: [comp.lang.java.databases] Cloudscape (Derby) issue with BLOB fields

[David Van Couvering <Da...@Sun.COM>]

Hm, this seems to be a theme.  Dyre, did you check to see if he's
closing his prepared statements?

Looks like we may need to fix this bug sooner rather than later...

David

Dyre.Tjeldvoll@Sun.COM wrote:
> 
> ------------------------------------------------------------------------
> 
> Subject:
> Cloudscape (Derby) issue with BLOB fields
> From:
> "Ante Sabo" <as...@baron.foi.hr>
> Date:
> Fri, 8 Jul 2005 15:12:04 +0200
> 
> 
> Hi all,
> 
> I have a problem with filling data into cludscape database. I have a 
> procedure which reads some 4000 pictures (10k in average) from mysql 
> database and put those in cloudscape database.
> Procedure is written in Java and use jdbc drivers.
> 
> After some 1000 pictures written I got SQLException with no stack trace and 
> with "java.lang.OutOfMemoryError" message.
> 
> So, I suppose jdbc driver caught OutOfMEmoryException and wrapped it with 
> new SQLException which I got...
> 
> Is someone experiencing the same problem? Can cloudscape handle 200MB of 
> BLOBs? How can cludscape deal with 'stress' situations (I mean when I wan't 
> need to put in it 200 megs of something in it) 
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> 
>