I have recently started using H2 for unit testing. Our general approach to database design has been a multi-table approach for object hierarchies, so for instance having a Vehicle class with Car and Motorcycle subclasses, all three get their own tables. Vehicle contains all properties common to the 3, and then Car and Motorcycle tables have the attributes unique to that subclass.
In our production environment we use Oracle as the DB. One of the constructs Oracle provides is INSERT ALL which would facilitate a query such as: INSERT ALL INTO VEHICLE (vehicle columns) VALUES (vehicle prop values) INTO CAR (car columns) VALUES (car prop values). select 1 from dual Is there any way to make this type of INSERT statement work on H2 so that I can continue using H2 for my unit testing? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
