Hi folks, I wonder could you offer some advice?
We use H2 for in-memory integration testing of Java MicroServices instead of Oracle (our production DB platform). In our test framework we have an interceptor which allows us to massage Oracle SQL statements to into something H2 friendly. One Oracle SQL statement I'm struggling with is 'SELECT MY_SEQ.NEXTVAL NEXTVAL FROM DUAL CONNECT BY LEVEL <= 10' In Oracle this allows multiple sequence numbers to be returned as separate rows from a single select statement. Can anyone think of a way I could mimic the Oracle SQL behaviour by rewriting it to something H2 compliant? Thanks, Paul -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
