james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Dettlaff (JIRA)" <server-...@james.apache.org>
Subject [jira] Created: (JAMES-880) bug with sql query for postgresql jdbc driver
Date Mon, 17 Nov 2008 02:44:51 GMT
bug with sql query for postgresql jdbc driver
---------------------------------------------

                 Key: JAMES-880
                 URL: https://issues.apache.org/jira/browse/JAMES-880
             Project: JAMES Server
          Issue Type: Bug
    Affects Versions: 2.3.1
         Environment: Debian Etch. Java 1.6.0_10, 32bit. 
            Reporter: Daniel Dettlaff
            Priority: Blocker


It's BLOCKER when someone needs to get server for Virtual Users (virtual mail accounts like
in tutorial here: http://wiki.apache.org/james/VirtualUserTable )

Problem:

in file: JDBCVirtualUserTable.java
line: 150

should be:

query = getInitParameter("sqlquery","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");

instead of:

query = getInitParameter("sqlquery","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");


So.. there should be doubled \\ cause postgresql on select did not select wanted row correctly
with default ".. LIKE '\%' .." and there should be ".. LIKE '\\%' .. " statement in query.
After adding this fix it works perfectly.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
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