Hi,

Thanks for the quick reply.

When I say embedded I  mean like in HSQLDB, which allows to embed the db server in the application instead of starting the db server in a separete process accepting connections from all clients.

My requirements are that the end user should not have to deal with the database directly, like start and stop it, not even need to install/configure it separetely.  But I would like to access the data through JDBC driver because the libraries I'm working with require it. I also would like a small footprint.

If that's not possible, then I would like to be able to start and stop the server through the application, even if it runs in a separete process.

The application allows the user to analyse and audit a large volume of data on different tables and MonetDB seems to be really fast for this.

Each user project will have its own set of tables so it would be nice to be able to set the database files where the user chooses for each project. If that's not possible I'll have to stick with different schemas for each project.

I'm still having some problems importing large tables (> 10 million rows divided in 10 files with 1 million rows each) when MonetDB is reporting the following error

SQLException:sql:Failed to extend the BAT, perhaps disk full

and on the console appears many times the follwing:

Is there any configuration or a way to make MonetDB work with large tables without having more memory available?

Thanks for your help!

Regards,

Luis Fernando