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
