Configuring file descriptors

Derby databases create one file per table or index. Some operating systems limit the number of files an application can open at one time.

If the default is a low number, such as 64, you might run into unexpected IOExceptions (wrapped in SQLExceptions). If your operating system lets you configure the number of file descriptors, set this number to a higher value.

Related concepts