XSD schema build a wrong nested tags auto-complete and validation. Fixed version http://jkniv.sf.net/schema/sqlegance/sqlegance-0.5.1.xsd
Add timeout attribute at select, insert, update and delete tags.
Query using functions with colon : generate error at parser.
select id, name from Roles where dt = to_date(:dt,‘YYYY-MM-DD HH24:MI:SS’) and name = :name and status = :status
'YYYY-MM-DD HH24:MI:SS' error was fixed at parser.
Before:
<statements .. xmlns:xi="http://www.w3.org/2001/XInclude" <xi:include href="/my-other-sql-file.xml" /> ...
Now:
<statements .. <include href="/my-other-sql-file.xml" /> ...
<where> <if test="name != null"> AND name = #{name} </if> ...