Hi guys -
I am in the process of setting up a VirtualUserTable, James 2.1, W2K and MSSQL
for the repository.
I converted the MySQL to M$SQL (se below) and am now processing with throwing
JDBC exceptions.
All seems well -
<mailet match="All" class="JDBCVirtualUserTable">
<table>db://maildb/VirtualUserTable</table>
<sqlquery>
SELECT TOP 1 VT.target_address
FROM VirtualUserTable AS VT, VirtualUserTable AS VTD
WHERE (VT.[user] like ? OR VT.[user] like '\%') AND
(VT.domain like ? OR (VT.domain like '\%' and VTD.domain like
?))
ORDER BY (VT.[user] + '@' + VT.domain) DESC;
</sqlquery>
</mailet>
For the entry in the Virtual table, I have Bubba, some.com, and validUser as the
records in the table.
I send mail to [EMAIL PROTECTED] and I get about 20 entries in the spool log that
James has successfully spooled the mail - but to where I know not.
Yes, some.com is handled by James .....
Suggestions as to where I should look ??
Thanks,
Alan
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
