You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by "Norman Maurer (JIRA)" <se...@james.apache.org> on 2010/07/30 13:01:19 UTC
[jira] Updated: (JAMES-880) bug with sql query for postgresql jdbc
driver
[ https://issues.apache.org/jira/browse/JAMES-880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Norman Maurer updated JAMES-880:
--------------------------------
Fix Version/s: 3.0-M1
> 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
> Assignee: Norman Maurer
> Priority: Blocker
> Fix For: 3.0-M1
>
> Original Estimate: 0.33h
> Remaining Estimate: 0.33h
>
> 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