james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nor...@apache.org
Subject svn commit: r488298 - /james/server/trunk/src/conf/sqlResources.xml
Date Mon, 18 Dec 2006 15:07:19 GMT
Author: norman
Date: Mon Dec 18 07:07:18 2006
New Revision: 488298

URL: http://svn.apache.org/viewvc?view=rev&rev=488298
Log:
Fix sqlStrings for vut

Modified:
    james/server/trunk/src/conf/sqlResources.xml

Modified: james/server/trunk/src/conf/sqlResources.xml
URL: http://svn.apache.org/viewvc/james/server/trunk/src/conf/sqlResources.xml?view=diff&rev=488298&r1=488297&r2=488298
==============================================================================
--- james/server/trunk/src/conf/sqlResources.xml (original)
+++ james/server/trunk/src/conf/sqlResources.xml Mon Dec 18 07:07:18 2006
@@ -1010,8 +1010,8 @@
 <sqlDefs name="org.apache.james.vut.JDBCVirtualUserTable">
 
     <!-- Statements used to check whether a particular message exists in this repository.
-->
-    <sql name="selectMappings" db="derby">select VirtualUserTable.target_address,(VirtualUserTable."user"
|| '@' ||VirtualUserTable.domain) from VirtualUserTable, VirtualUserTable as VUTDomains where
((VirtualUserTable."user") like ? or (VirtualUserTable."user") like '%') and (VirtualUserTable.domain
like ? or (VirtualUserTable.domain like '%' and VUTDomains.domain like ?)) order by 2 desc</sql>
-    <sql name="selectMappings">select VirtualUserTable.target_address from VirtualUserTable,
VirtualUserTable as VUTDomains where (VirtualUserTable.user like ? or VirtualUserTable.user
like '%') and (VirtualUserTable.domain like ? or (VirtualUserTable.domain like '%' and VUTDomains.domain
like ?)) order by concat(VirtualUserTable.user,'@',VirtualUserTable.domain) desc limit 1"
</sql>
+    <sql name="selectMappings" db="derby">select VirtualUserTable.target_address,(VirtualUserTable."user"
|| '@' ||VirtualUserTable.domain) from VirtualUserTable, VirtualUserTable as VUTDomains where
((VirtualUserTable."user") like ? or (VirtualUserTable."user") like '\%' escape '\') and (VirtualUserTable.domain
like ? or (VirtualUserTable.domain like '\%' escape '\' and VUTDomains.domain like ?)) order
by 2 desc</sql>
+    <sql name="selectMappings">select VirtualUserTable.target_address from VirtualUserTable,
VirtualUserTable as VUTDomains where (VirtualUserTable.user like ? or VirtualUserTable.user
like '\%') and (VirtualUserTable.domain like ? or (VirtualUserTable.domain like '\%' and VUTDomains.domain
like ?)) order by concat(VirtualUserTable.user,'@',VirtualUserTable.domain) desc limit 1</sql>
     
     <sql name="selectUserDomainMapping" db="derby">select VirtualUserTable.target_address
from VirtualUserTable where VirtualUserTable."user" = ? and VirtualUserTable.domain = ? </sql>
     <sql name="selectUserDomainMapping">select VirtualUserTable.target_address from
VirtualUserTable where VirtualUserTable.user = ? and VirtualUserTable.domain = ? </sql>



---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


Mime
View raw message