james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From se...@apache.org
Subject cvs commit: jakarta-james/src/conf sqlResources.xml
Date Thu, 27 Sep 2001 21:10:51 GMT
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: james-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-dev-help@jakarta.apache.org


Mime
View raw message