serge 01/09/27 14:10:51
Modified: src/conf sqlResources.xml
Log:
Added sqlDefs for JDBCAlias mailet (if I can figure out how to access this file, I'm
set).
Revision Changes Path
1.4 +9 -0 jakarta-james/src/conf/sqlResources.xml
Index: sqlResources.xml
===================================================================
RCS file: /home/cvs/jakarta-james/src/conf/sqlResources.xml,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- sqlResources.xml 2001/09/13 01:33:26 1.3
+++ sqlResources.xml 2001/09/27 21:10:51 1.4
@@ -152,4 +152,13 @@
</sql>
</sqlDefs>
+<sqlDefs name="org.apache.james.transport.mailets.JDBCAlias">
+ <sql name="tableName">${table}</sql>
+ <sql name="select">SELECT source_email_address
+ FROM ${table}
+ WHERE target_email_address = ?
+ </sql>
+ <sql name="createTable">CREATE TABLE ${table} (source_email_address
VARCHAR(200) NOT NULL, target_email_address VARCHAR(200) PRIMARY
KEY(source_email_address))</sql>
+</sqlDefs>
+
</sqlResources>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
