Hi Ankit,

I just wanted to know that, is there any limitation of no of database created in main memory mode using Java Application.

There is no fixed limit. How many databases are you planning to create in your application? Thousands? Millions?

Am i able to open multiple database in main memory mode at a time ?.

Yes. If you e.g. use the client/server architecture, every client can have its own main-memory database opened.. Best, Christian