Hi All. I am trying to use H2 in my project to support a bunch of SQL code initially written with MySQL in mind. One of the things I ran into is the use of the REPLACE INTO TablaName syntax, which is not supported by H2. I see that H2 supports the same syntax using the MERGE keyword, and I'm wondering how other people tackled that problem.
Due to external constraints, I can't change the SQL code in a way that is incompatible with MySQL. I thought about adding a method to search all the SQL commands - just before execution - and replace "REPLACE INTO" with "MERGE INTO", but that seems very heavy handed. I'd appreciate hearing any other ideas. -- 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.
