Cloudscape (Derby) issue with BLOB fields

Thread view:

Ante Sabo - 08 Jul 2005 14:12 GMT

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)

Reply to this Message

Dyreatnews@sun.com - 15 Jul 2005 08:00 GMT

[snip]

> 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)

Hi, I took the liberty of forwarding your post to
derby-user@db.apache.org. Hopefully, there will be someone there that
can help out.

Signature

dt

However, experience shows that for many people and many applications a
dose of paranoia is reasonable - Bjarne Stroustrup

Reply to this Message

Ante Sabo - 15 Jul 2005 14:02 GMT

ok, thanks, I supposed to write them for bug, but they require many details.
I just wanted to see if someone else
is experiencing same problem...

Reply to this Message

Dyreatnews@sun.com - 15 Jul 2005 14:50 GMT

> ok, thanks, I supposed to write them for bug, but they require many details.
> I just wanted to see if someone else
> is experiencing same problem...

I think I have seen others complain about running out of memory too, but
their app did not look anything like yours, so I think it is a more general
problem.

It is my impression though, that the people reading derby-user (and
derby-dev) are NOT following this group. And since many of them are
Cloudscape developers it is good to keep them informed.

Consider joining one or more of the mailing-lists,
or file a JIRA-issue for the problem.

See
http://incubator.apache.org/derby

for more info.

Signature

dt

However, experience shows that for many people and many applications a
dose of paranoia is reasonable - Bjarne Stroustrup

Reply to this Message

Cloudscape (Derby) issue with BLOB fields

Free Magazines