Hi, After your init string just add "MODE=Oracle" and then H2 will be compatible with your Oracle SQL. The different capabilities of the mode setting is somewhere mentioned on the website, but can't find it right now.
Kind Regards, Nitai On Mon, Jan 11, 2010 at 6:10 PM, Paluee <[email protected]> wrote: > Hi There, > On your website under SQL support, see link: > http://www.h2database.com/html/features.html#other_settings > > There is a line that says:: > > "Compatibility modes for IBM DB2, Apache Derby, HSQLDB, MS SQL Server, > MySQL, Oracle, and PostgreSQL." > > The way i interpret this statement is that in H2 database there is a > way to set a variable to choose among the different dialects of SQL on > the above databases mentioned. > > > If my interpretation is correct, how to I set the SQL dialect I wish > to use in my code? > > Any help is greatly appreciated. > > Sincerely, > > Paluee > > -- > 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. > > > > -- See for yourself how easy it is to manage files today. Join the revolution! Razuna SaaS On-Demand - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Follow us on Twitter http://twitter.com/razunahq
-- 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.
