InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Thanks Peter

Yes I set resultsOnDisk=1
because I got an out of memory error ... ;-)

But I don't understand why IDB keeps the temp opened ? maybe it is a bug in
my app where
I forgot to close the result set ... but the garbage should do this job as
well ? is it done in a finalize method of idb result set ?

Thanks.






----- Original Message -----
From: Peter Hearty <peter.hearty@lutris.com>
To: <instantDB@enhydra.org>
Sent: Wednesday, February 07, 2001 1:26 PM
Subject: Re: InstantDB: Too many open files


> Daniel
>
> I think Linux can place a limit on the number of open files. Try
> typing "linux Too many open files" into Google - you should get quite a
> few pointers to potential solutions.
>
> IDB uses one file per table - including one per results set. You could
> reduce the number of files that it opens at once by making sure that
> you have
>
> resultsOnDisk=0
>
> in the database properties file and by making sure that all ResultSet
> objects are explicitly closed (rather than just letting the GC close
> them).
>
> Pete
>
> ----- Original Message -----
> From: <dherlemont@yats.com>
> Date: Wednesday, February 7, 2001 11:46 am
> Subject: InstantDB: Too many open files
>
> >
> > Hello,
> > I got the following exception : is it a problem of IDB or JVM or
> > LINUX ?
> >
> > erreur:java.sql.SQLException: IO problem:
> > java.io.FileNotFoundException:..../idb/tmp/db$tmp$8828.tbl (Too
> > many open files)
> >
> > Thanks for help.
> >
> > Daniel HERLEMONT
> > YATS Consulting
> >
> >
> > -------------------------------------------------------------------
> > ----------
> > To unsubscribe from this mailing list, send email to
> > majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the
> > body of the email.
> > If you have other questions regarding this mailing list, send
> > email to
> > the list admin at owner-instantdb@enhydra.org.
> >
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.