[JAMES-880] bug with sql query for postgresql jdbc driver

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.3.1
• Fix Version/s: 3.0-M1
• Environment: Debian Etch. Java 1.6.0_10, 32bit.
• Assignee: Eric Charles
• Reporter: Daniel Dettlaff
• Created: 17/Nov/08 02:43
• Updated: 14/Aug/10 12:21
• Resolved: 14/Aug/10 12:21

Description

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.