Cloudscape (Derby) issue with BLOB fields

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)


.

Relevant Pages

  • Re: Simple question about using JDBC to access DB2
    ... I want to use JDBC to access DB2 database. ... PreparedStatements are allowed to use String concatenation: ... private void connectToDatabase() { ... } catch (SQLException sql_excp) { ...
    (comp.lang.java.help)
  • Re: Access newbie picture question
    ... While the DBPix control is an excellent reccomendation your statement ... LoadSaveJpeg.zip contains a database demonstrating how to use the Intel ... >>> I have to store some pictures in the database. ... is there a way to display the FileOpen ...
    (microsoft.public.access.forms)
  • Re: 2GB size limitation workaround
    ... the database back to a file. ... Roger dot Carlson at Spectrum-Health dot Org ... > way to convert the embedded pictures to a linked one or do ... >>If you need to load them in an external program, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Convert jpg to bmp
    ... when asked to confirm (this will remove the jpg from the database). ... way to go with inserting pictures, ... an EMF file in the OLE cell but only to have the filename show, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Connect to access
    ... connection to the database, then query or update the database. ... } catch (SQLException sql_excp) { ... String queryTableSQL = "select lastname, workdept, salary, hiredate ... Statement queryTableStmt = null; ...
    (comp.lang.java.programmer)