[jira] Closed: (IBATIS-87) Add notion of DB specific SQL statements

["Brandon Goodin (JIRA)" <ib...@incubator.apache.org>]

     [ http://issues.apache.org/jira/browse/IBATIS-87?page=history ]
     
Brandon Goodin closed IBATIS-87:
--------------------------------

    Resolution: Won't Fix

See for http://issues.apache.org/jira/browse/IBATIS-94 for more viable solution.

> 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