[ http://issues.apache.org/jira/browse/IBATIS-87?page=comments#action_61684 ] Vadim Pesochinskiy commented on IBATIS-87: ------------------------------------------
This solution will help to create custom work-arounds. I believe implementing this feature will add a lot of value for a little effort. > Add notion of DB specific SQL statements > ---------------------------------------- > > Key: IBATIS-87 > URL: http://issues.apache.org/jira/browse/IBATIS-87 > Project: iBatis for Java > Type: New Feature > Components: SQL Maps > Environment: Any > Reporter: Vadim Pesochinskiy > Priority: Minor > > This is probably not very impressive idea, but I will throw it in anyway. > What if we add a DatabaseType property and have SqlMap lookup proper query > for it in the same manner as Java internationalization works. DB type > attribute can have an arbitrary value, which is only used get proper query. > E.g. > Queries: > getOrder.sqlserver > getOrder > If DataBaseType is 'sqlserver' - 'getOrder.sqlserver' query is picked, if > DataBaseType=oracle or DataBaseType=postgres 'getOrder' sql will be executed. > I can implement it, if you don't mind :). Thanks. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
