Derby SQL Dialect Support
May 27th, 2009 by Alexey ChmutovMaia brings you the support of Apache Derby SQL dialect. Just as with all others, you can set it at project, folder and individual file levels either via Project Settings section of Settings dialog:
Or by invoking a quick-fix on any error marker inside of an .sql file with Alt+Enter shortcut:
Tags: Database Tools, Derby, Maia

May 27th, 2009 at 3:08 pm
BTW, PostgreSQL support is on the roadmap??
May 27th, 2009 at 5:01 pm
Ooh - Derby support is nice.
Any roadmap plans for MS SQL Server? There’s a fair number of enterprise Java applications running against that..
May 27th, 2009 at 5:54 pm
Interesting…. how do you do the “change Oracle dialect to…”?
its that in house code or do you leverage an open source library?
May 27th, 2009 at 8:10 pm
While we’re asking for more dialect support, how about DB2? Or are DB2 and Derby close enough?
May 28th, 2009 at 6:13 am
Phil, dialect to…” action doesn’t transform the file. It just suggests to assign other dialect to the file.
(to possibly fix errors)
In fact, “change
May 28th, 2009 at 10:16 pm
How about H2Database ?