Map in Hibernate a table to MEMORY (HEAP) in XML

Question

This question is not about caching.
I need this in-memory table for many small updates and complicated queries.
I must have it on a server shared between several nodes.

MySQL have MEMORY (HEAP) Storage Engine which is exactly what I need.

Can I tell Hibernate to create such a table, when defining a <class> or a '` in the XML?
Is there another solution?

Thanks!

Mikko Maunu · Accepted Answer · 2012-06-17 19:49:15Z

1

No, you cannot generate those tables via Hibernate. Hibernate chooses storage engine based to dialect, and for MySQL 5 available dialects are MySQL5InnoDBDialect and MySQL5Dialect.

If it is really important to generate database structure via Hibernate, then you can of course go and create dialect yourself. As you see from the source of MySQL5InnoDBDialect, it boils down to "ENGINE = MEMORY".

answered Jun 17, 2012 at 19:49

Mikko Maunu

42.3k11 gold badges143 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Poni Over a year ago

Nice idea, I like it a lot and might go for it. Thank you!

Collectives™ on Stack Overflow

Map in Hibernate a table to MEMORY (HEAP) in XML

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related