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

["Vadim Pesochinskiy (JIRA)" <ib...@incubator.apache.org>]

     [ http://issues.apache.org/jira/browse/IBATIS-87?page=comments#action_60527 ]
     
Vadim Pesochinskiy commented on IBATIS-87:
------------------------------------------

Hi Clinton,

Do you have any comments on this issue? 

I am trying to sell the idea of using iBATIS in my company (oatsystems.com). 

There are few improvements that I will need to implement - this one (minor) and DB password encryption, which is a hard requirement for any enterprise software. Current idea is to wrap the Reader returned from your Resource class and unencrypt password there. It is a bit of a hack, it would be nice if there was some kind of PasswordEncryption interface, implementation of which could be provided to iBATIS. Thank you.


> 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