I once set up H2 and HSQL db in-memory databases. I think you put special configs in the JDBC connection information to make it run in-memory. I don't think you'll be able to use connection pooling with an in-memory database because each JDBC connection would start a new in memory DB instance.
> Hi,
> TimerPool is configured as an embedded database, but
> I would like to have an in-memory database. Embedded
> mode works for me perfectly, but I would like to get
> rid of the database file.
>
> Regards
> Marcin Kwapisz
[Message sent by forum member 'rdelaplante' (ryan_at_ijws.com)]
http://forums.java.net/jive/thread.jspa?messageID=380121