<div dir="ltr">Heya qmx!<div><br></div><div>we was in the middle of switching from pure orm.xml to hbm.xml (in order to allow column indexing in JPA 2.0),</div><div><br></div><div>when we found out the 'sequence' generator does not really work with MySQL (the MySQL adapter complains about not supporting that configuration).</div><div><br></div><div><br></div><div><a href="https://github.com/aerogear/aerogear-unifiedpush-server/commit/2a8fc6b70be82307da06a01050070a4eff201085">https://github.com/aerogear/aerogear-unifiedpush-server/commit/2a8fc6b70be82307da06a01050070a4eff201085</a><br></div><div><br></div><div><br></div><div>So Gunnar recommended 'enhanced-sequence' which should basically be a sequence that use fallback strategy and it should be compliant with how Hibernate operates for JPA 2.0 sequence configuration.</div><div><br></div><div>I would be perfectly happy with any solution that would allow us to use the same strategy as before, but the problem is we didn't find one.</div><div><br></div><div><br></div><div>Do someone has any suggestions?</div><div><br></div><div>~ Lukas</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 14, 2015 at 1:11 AM, Douglas Campos <span dir="ltr"><<a href="mailto:qmx@qmx.me" target="_blank">qmx@qmx.me</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Howdy!<div><br></div><div>While working on rebasing the migration PR I've noticed that Lukas moved my 'category_seq' generator to the shiny-new 'enhanced-sequence' generator.</div><div><br></div><div>Does anyone remembers the reasoning for the change? I'm asking because we do want a sequence-style generator BUT with individual sequence-like tables when using mysql. The reason for this is SEVERE contention with InnoDB tables under load - something that is prone to happen when you go with the `hibernate_sequence` magic table.</div><div><br></div><div>I might be missing something.....HALP? :)</div><div><br></div><div>[]'z</div></div>
<br>_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br></blockquote></div><br></div>