Author: eric
Date: Mon Feb 20 11:29:56 2012
New Revision: 1291205
URL: http://svn.apache.org/viewvc?rev=1291205&view=rev
Log:
Still more file renamed to -template, relying on other modules shipped file
loaded via classpath (JAMES-1376)
Added:
james/app/trunk/src/main/resources/hbase-site-template.xml
- copied unchanged from r1291153,
james/app/trunk/src/main/resources/hbase-site.xml
james/app/trunk/src/main/resources/jcr-repository-template.xml
- copied unchanged from r1291153,
james/app/trunk/src/main/resources/jcr-repository.xml
james/app/trunk/src/main/resources/log4j-template.properties
james/app/trunk/src/main/resources/sqlResources-template.xml
Removed:
james/app/trunk/src/main/resources/hbase-site.xml
james/app/trunk/src/main/resources/jcr-repository.xml
james/app/trunk/src/main/resources/jmx.properties
Added: james/app/trunk/src/main/resources/log4j-template.properties
URL:
http://svn.apache.org/viewvc/james/app/trunk/src/main/resources/log4j-template.properties?rev=1291205&view=auto
==============================================================================
--- james/app/trunk/src/main/resources/log4j-template.properties (added)
+++ james/app/trunk/src/main/resources/log4j-template.properties Mon Feb 20
11:29:56 2012
@@ -0,0 +1,137 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+
+# See http://james.apache.org/server/3/config.html for usage
+
+log4j.rootLogger=DEBUG
+
+log4j.appender.CONS=org.apache.log4j.ConsoleAppender
+log4j.appender.CONS.layout=org.apache.log4j.PatternLayout
+log4j.appender.CONS.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} | %c | %m%n
+
+log4j.appender.FILE=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.FILE.File=../log/james-server.log
+log4j.appender.FILE.layout=org.apache.log4j.PatternLayout
+log4j.appender.FILE.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} | %c | %m%n
+
+log4j.appender.MAILBOXMANAGER=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.MAILBOXMANAGER.File=../log/mailboxmanager.log
+log4j.appender.MAILBOXMANAGER.DatePattern='.'yyyy-MM-dd
+log4j.appender.MAILBOXMANAGER.layout=org.apache.log4j.PatternLayout
+log4j.appender.MAILBOXMANAGER.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} |
%c | %m%n
+
+log4j.appender.IMAPSERVER=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.IMAPSERVER.File=../log/imapserver.log
+log4j.appender.IMAPSERVER.DatePattern='.'yyyy-MM-dd
+log4j.appender.IMAPSERVER.layout=org.apache.log4j.PatternLayout
+log4j.appender.IMAPSERVER.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} | %c
| %m%n
+
+log4j.appender.MAILETCONTAINER=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.MAILETCONTAINER.File=../log/mailetcontainer.log
+log4j.appender.MAILETCONTAINER.DatePattern='.'yyyy-MM-dd
+log4j.appender.MAILETCONTAINER.layout=org.apache.log4j.PatternLayout
+log4j.appender.MAILETCONTAINER.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS}
| %c | %m%n
+
+log4j.appender.DNSSERVICE=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.DNSSERVICE.File=../log/dnsservice.log
+log4j.appender.DNSSERVICE.DatePattern='.'yyyy-MM-dd
+log4j.appender.DNSSERVICE.layout=org.apache.log4j.PatternLayout
+log4j.appender.DNSSERVICE.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} | %c
| %m%n
+
+log4j.appender.POP3SERVER=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.POP3SERVER.File=../log/pop3server.log
+log4j.appender.POP3SERVER.DatePattern='.'yyyy-MM-dd
+log4j.appender.POP3SERVER.layout=org.apache.log4j.PatternLayout
+log4j.appender.POP3SERVER.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} | %c
| %m%n
+
+log4j.appender.SMTPSERVER=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.SMTPSERVER.File=../log/smtpserver.log
+log4j.appender.SMTPSERVER.DatePattern='.'yyyy-MM-dd
+log4j.appender.SMTPSERVER.layout=org.apache.log4j.PatternLayout
+log4j.appender.SMTPSERVER.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} | %c
| %m%n
+
+log4j.appender.LMTPSERVER=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.LMTPSERVER.File=../log/lmtpserver.log
+log4j.appender.LMTPSERVER.DatePattern='.'yyyy-MM-dd
+log4j.appender.LMTPSERVER.layout=org.apache.log4j.PatternLayout
+log4j.appender.LMTPSERVER.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} | %c
| %m%n
+
+log4j.appender.MAILREPOSITORYSTORE=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.MAILREPOSITORYSTORE.File=../log/mailrepositorystore.log
+log4j.appender.MAILREPOSITORYSTORE.DatePattern='.'yyyy-MM-dd
+log4j.appender.MAILREPOSITORYSTORE.layout=org.apache.log4j.PatternLayout
+log4j.appender.MAILREPOSITORYSTORE.layout.ConversionPattern=%-5p
%d{HH:mm:ss,SSS} | %c | %m%n
+
+log4j.appender.USERSREPOSITORY=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.USERSREPOSITORY.File=../log/usersrepository.log
+log4j.appender.USERSREPOSITORY.DatePattern='.'yyyy-MM-dd
+log4j.appender.USERSREPOSITORY.layout=org.apache.log4j.PatternLayout
+log4j.appender.USERSREPOSITORY.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS}
| %c | %m%n
+
+log4j.appender.FETCHMAIL=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.FETCHMAIL.File=../log/fetchmail.log
+log4j.appender.FETCHMAIL.DatePattern='.'yyyy-MM-dd
+log4j.appender.FETCHMAIL.layout=org.apache.log4j.PatternLayout
+log4j.appender.FETCHMAIL.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} | %c |
%m%n
+
+log4j.appender.DOMAINLIST=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.DOMAINLIST.File=../log/domainlist.log
+log4j.appender.DOMAINLIST.DatePattern='.'yyyy-MM-dd
+log4j.appender.DOMAINLIST.layout=org.apache.log4j.PatternLayout
+log4j.appender.DOMAINLIST.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS} | %c
| %m%n
+
+log4j.appender.VIRTUALUSERTABLE=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.VIRTUALUSERTABLE.File=../log/virtualusertable.log
+log4j.appender.VIRTUALUSERTABLE.DatePattern='.'yyyy-MM-dd
+log4j.appender.VIRTUALUSERTABLE.layout=org.apache.log4j.PatternLayout
+log4j.appender.VIRTUALUSERTABLE.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS}
| %c | %m%n
+
+log4j.appender.MAILQUEUEFACTORY=org.apache.log4j.DailyRollingFileAppender
+log4j.appender.MAILQUEUEFACTORY.File=../log/mailqueuefactory.log
+log4j.appender.MAILQUEUEFACTORY.DatePattern='.'yyyy-MM-dd
+log4j.appender.MAILQUEUEFACTORY.layout=org.apache.log4j.PatternLayout
+log4j.appender.MAILQUEUEFACTORY.layout.ConversionPattern=%-5p %d{HH:mm:ss,SSS}
| %c | %m%n
+
+log4j.logger.org.apache.jackrabbit=ERROR, CONS, FILE
+
+log4j.logger.org.apache.xbean.spring=WARN, CONS, FILE
+log4j.logger.org.apache.activemq=WARN, CONS, FILE
+
+log4j.logger.org.apache.camel=WARN, CONS, FILE
+log4j.logger.org.springframework=WARN, CONS, FILE
+log4j.logger.org.apache.james=INFO, CONS, FILE
+
+log4j.logger.james=WARN, CONS, FILE
+log4j.logger=DEBUG, CONS, FILE
+
+log4j.logger.james.mailboxmanager=INFO, MAILBOXMANAGER
+log4j.logger.james.imapserver=INFO, IMAPSERVER
+log4j.logger.james.mailetcontainer=INFO, MAILETCONTAINER
+log4j.logger.james.mailetcontext=INFO, MAILETCONTAINER
+log4j.logger.james.mailspooler=INFO, MAILETCONTAINER
+log4j.logger.james.mailprocessor=INFO, MAILETCONTAINER
+log4j.logger.james.dnsservice=INFO, DNSSERVICE
+log4j.logger.james.pop3server=INFO, POP3SERVER
+log4j.logger.james.smtpserver=INFO, SMTPSERVER
+log4j.logger.james.lmtpserver=INFO, LMTPSERVER
+log4j.logger.james.mailrepositorystore=INFO, MAILREPOSITORYSTORE
+log4j.logger.james.usersrepository=INFO, USERSREPOSITORY
+log4j.logger.james.fetchmail=INFO, FETCHMAIL
+log4j.logger.james.domainlist=INFO, DOMAINLIST
+log4j.logger.james.virtualusertable=INFO, VIRTUALUSERTABLE
+log4j.logger.james.mailqueuefactory=INFO, MAILQUEUEFACTORY
+
Added: james/app/trunk/src/main/resources/sqlResources-template.xml
URL:
http://svn.apache.org/viewvc/james/app/trunk/src/main/resources/sqlResources-template.xml?rev=1291205&view=auto
==============================================================================
--- james/app/trunk/src/main/resources/sqlResources-template.xml (added)
+++ james/app/trunk/src/main/resources/sqlResources-template.xml Mon Feb 20
11:29:56 2012
@@ -0,0 +1,933 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
+ -->
+
+<!-- See http://james.apache.org/server/3/config.html for usage -->
+
+<sqlResources>
+
+<dbMatchers>
+ <dbMatcher db="mssql" databaseProductName="microsoft sql server"/>
+ <dbMatcher db="oracle" databaseProductName="oracle.*"/>
+ <dbMatcher db="mysql" databaseProductName="my.*"/>
+ <dbMatcher db="derby" databaseProductName="derby.*"/>
+ <dbMatcher db="postgresql" databaseProductName="postgres.*"/>
+ <dbMatcher db="hsqldb" databaseProductName="hsql.*"/>
+ <dbMatcher db="sapdb" databaseProductName="sap.*"/>
+ <dbMatcher db="hypersonic" databaseProductName="HypersonicSQL"/>
+ <dbMatcher db="db2" databaseProductName="db2.*"/>
+ <dbMatcher db="ingres" databaseProductName="ingres.*"/>
+</dbMatchers>
+
+<dbOptions>
+ <dbOption name="getBody" value="useBytes"/>
+ <dbOption name="getAttributes" value="useBytes"/>
+ <dbOption db="mssql" name="getBody" value="useBytes"/>
+ <dbOption db="mssql" name="getAttributes" value="useBytes"/>
+ <dbOption db="oracle" name="getBody" value="useBlob"/>
+ <dbOption db="oracle" name="getAttributes" value="useBlob"/>
+ <dbOption db="mysql" name="getBody" value="useBytes"/>
+ <dbOption db="mysql" name="getAttributes" value="useBytes"/>
+ <dbOption db="derby" name="getBody" value="useBytes"/>
+ <dbOption db="derby" name="getAttributes" value="useBytes"/>
+ <dbOption db="postgresql" name="getBody" value="useBytes"/>
+ <dbOption db="postgresql" name="getAttributes" value="useBytes"/>
+ <dbOption db="sapdb" name="getBody" value="useBytes"/>
+ <dbOption db="sapdb" name="getAttributes" value="useBytes"/>
+ <dbOption db="hypersonic" name="getBody" value="useBytes"/>
+ <dbOption db="hypersonic" name="getAttributes" value="useBytes"/>
+ <dbOption db="hsqldb" name="getBody" value="useBytes"/>
+ <dbOption db="hsqldb" name="getAttributes" value="useBytes"/>
+ <dbOption db="db2" name="getBody" value="useBlob"/>
+ <dbOption db="db2" name="getAttributes" value="useBlob"/>
+ <dbOption db="ingres" name="getBody" value="useBytes"/>
+ <dbOption db="ingres" name="getAttributes" value="useBytes"/>
+</dbOptions>
+
+<sqlDefs name="org.apache.james.user.jdbc.JamesUsersJdbcRepository">
+ <sql name="tableName">${table}</sql>
+
+ <!-- Statements used to retrieve all user information for a user from this
repository. -->
+ <sql name="select">SELECT username, pwdHash, pwdAlgorithm, useForwarding,
+ forwardDestination, useAlias, alias
+ FROM ${table}
+ ORDER BY username
+ </sql>
+
+ <!-- Statements used to get all user information for a user with a
particular user name in a -->
+ <!-- case-insensitive fashion from this repository. -->
+ <sql name="selectByLowercaseName">
+ SELECT username, pwdHash, pwdAlgorithm, useForwarding,
+ forwardDestination, useAlias, alias
+ FROM ${table}
+ WHERE lower(username) = ?
+ </sql>
+
+ <sql name="selectByLowercaseName" db="mysql">
+ SELECT username, pwdHash, pwdAlgorithm, useForwarding,
+ forwardDestination, useAlias, alias
+ FROM ${table}
+ WHERE username = ?
+ </sql>
+
+ <!-- Statements used to insert a user into this repository. -->
+ <sql name="insert">INSERT INTO ${table}
+ (username, pwdHash, pwdAlgorithm, useForwarding,
forwardDestination, useAlias, alias)
+ VALUES (?,?,?,?,?,?,?)
+ </sql>
+
+ <!-- Statements used to update information for a user from this
repository. -->
+ <sql name="update">UPDATE ${table} SET
+ pwdHash = ?, pwdAlgorithm = ?, useForwarding = ?,
forwardDestination = ?, useAlias = ?, alias = ?
+ WHERE username = ?
+ </sql>
+
+ <!-- Statements used to delete a user from this repository. -->
+ <sql name="delete">DELETE FROM ${table} WHERE username = ?</sql>
+
+ <!-- Statements used to create the table associated with this class. -->
+ <sql name="createTable" db="hypersonic">CREATE CACHED TABLE ${table}
(username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20),
useForwarding INTEGER, forwardDestination VARCHAR(255), useAlias INTEGER, alias
VARCHAR(255), PRIMARY KEY(username))</sql>
+ <sql name="createTable">CREATE TABLE ${table} (username VARCHAR(64) NOT
NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20), useForwarding SMALLINT,
forwardDestination VARCHAR(255), useAlias SMALLINT, alias VARCHAR(255), PRIMARY
KEY(username))</sql>
+ <!-- An example of a database-specific sql statement
+ <sql name="createTable" db="mssql">CREATE TABLE ${table} (uniqueId
UNIQUEIDENTIFIER, username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50),
pwdAlgorithm VARCHAR(20), useForwarding SMALLINT, forwardDestination
VARCHAR(255), useAlias SMALLINT, alias VARCHAR(255), PRIMARY
KEY(username))</sql>
+ -->
+</sqlDefs>
+
+<sqlDefs name="org.apache.james.user.jdbc.DefaultUsersJdbcRepository">
+ <sql name="tableName">${table}</sql>
+
+ <!-- Statements used to retrieve all user information for a user from this
repository. -->
+ <sql name="select">SELECT username, pwdHash, pwdAlgorithm
+ FROM ${table}
+ </sql>
+
+ <!-- Statements used to insert a user into this repository. -->
+ <sql name="insert">INSERT INTO ${table}
+ (username, pwdHash, pwdAlgorithm)
+ VALUES (?,?,?)
+ </sql>
+
+ <!-- Statements used to update information for a user from this
repository. -->
+ <sql name="update">UPDATE ${table} SET
+ pwdHash = ?, pwdAlgorithm = ?
+ WHERE username = ?
+ </sql>
+
+ <!-- Statements used to delete a user from this repository. -->
+ <sql name="delete">DELETE FROM ${table} WHERE username = ?</sql>
+
+ <!-- Statements used to create the table associated with this class. -->
+ <sql name="createTable" db="hypersonic">CREATE CACHED TABLE ${table}
(username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20),
PRIMARY KEY(username))</sql>
+ <sql name="createTable">CREATE TABLE ${table} (username VARCHAR(64) NOT
NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20), PRIMARY
KEY(username))</sql>
+</sqlDefs>
+
+<sqlDefs name="org.apache.james.user.jdbc.ListUsersJdbcRepository">
+ <!-- An example of defining "default" parameters within the definition
file.
+ This is used if no key parameter is specified in config. -->
+ <parameters key="unknownList"/>
+
+ <sql name="tableName">${table}</sql>
+
+ <!-- Statements used to retrieve all users on a particular list from this
repository. -->
+ <sql name="select">SELECT listSubscriber
+ FROM ${table}
+ WHERE listName = '${key}'
+ </sql>
+
+ <!-- Statements used to insert a user/list mapping into this repository.
-->
+ <sql name="insert">INSERT INTO ${table}
+ (listSubscriber, listName)
+ VALUES (?, '${key}')
+ </sql>
+
+ <!-- Statements used to update a user/list mapping in this repository. -->
+ <sql name="update">UPDATE ${table} SET
+ listSubscriber = ?
+ WHERE listSubscriber = ? AND listName = '${key}'
+ </sql>
+
+ <!-- Statements used to delete a user/list mapping from this repository.
-->
+ <sql name="delete">DELETE FROM ${table}
+ WHERE listSubscriber = ? AND listName = '${key}'
+ </sql>
+
+ <!-- Statements used to create the table associated with this class. -->
+ <sql name="createTable" db="hypersonic">CREATE CACHED TABLE ${table}
(listName VARCHAR(64) NOT NULL, listSubscriber VARCHAR(255) NOT NULL, PRIMARY
KEY(listName, listSubscriber))</sql>
+ <sql name="createTable">CREATE TABLE ${table} (listName VARCHAR(64) NOT
NULL, listSubscriber VARCHAR(255) NOT NULL, PRIMARY KEY(listName,
listSubscriber))</sql>
+</sqlDefs>
+
+<sqlDefs name="org.apache.james.mailrepository.jdbc.JDBCMailRepository">
+
+ <!-- Statements used to check whether a particular message exists in this
repository. -->
+ <sql name="checkMessageExistsSQL">SELECT count(*) FROM ${table} WHERE
message_name = ? AND repository_name = ?</sql>
+
+ <!-- Statements used to update a message stored in this repository. -->
+ <sql name="updateMessageSQL">UPDATE ${table} SET message_state = ?,
error_message = ?, sender = ?, recipients = ?, remote_host = ?, remote_addr =
?, last_updated = ? WHERE message_name = ? AND repository_name = ?</sql>
+
+ <!-- Statements used to update the body of a message stored in this
repository. -->
+ <sql name="updateMessageBodySQL">UPDATE ${table} SET message_body = ?
WHERE message_name = ? AND repository_name = ?</sql>
+
+ <!-- Statements used to update the attributes of a message stored in this
repository. -->
+ <sql name="updateMessageAttributesSQL">UPDATE ${table} SET
message_attributes = ? WHERE message_name = ? AND repository_name = ?</sql>
+
+ <!-- Statements used to insert a message into this repository. -->
+ <sql name="insertMessageSQL">INSERT INTO ${table} (message_name,
+ repository_name, message_state, error_message, sender, recipients,
+ remote_host, remote_addr, last_updated, message_body,
+ message_attributes) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</sql>
+
+ <!-- Statements used to retrieve a message stored in this repository. -->
+ <sql name="retrieveMessageSQL">SELECT message_state, error_message,
sender, recipients, remote_host, remote_addr, last_updated FROM ${table} WHERE
message_name = ? AND repository_name = ?</sql>
+
+ <!-- Statements used to retrieve the body of a message stored in this
repository. -->
+ <sql name="retrieveMessageBodySQL">SELECT message_body FROM ${table} WHERE
message_name = ? AND repository_name = ?</sql>
+
+ <!-- Statements used to retrieve the attributes of a message stored in
this repository. -->
+ <sql name="retrieveMessageAttributesSQL">SELECT message_attributes FROM
${table} WHERE message_name = ? AND repository_name = ?</sql>
+
+ <!-- Statements used to retrieve the size of the body of a message stored
in this repository. -->
+ <!-- NOTE: This statement is optional and need not be implemented for a
particular database to be supported. -->
+ <sql name="retrieveMessageBodySizeSQL" db="mssql">SELECT
datalength(message_body) FROM ${table} WHERE message_name = ? AND
repository_name = ?</sql>
+ <sql name="retrieveMessageBodySizeSQL" db="mysql">SELECT
length(message_body) FROM ${table} WHERE message_name = ? AND repository_name =
?</sql>
+ <sql name="retrieveMessageBodySizeSQL" db="hypersonic">SELECT
length(message_body) FROM ${table} WHERE message_name = ? AND repository_name =
?</sql>
+ <sql name="retrieveMessageBodySizeSQL" db="hsqldb">SELECT
length(message_body) FROM ${table} WHERE message_name = ? AND repository_name =
?</sql>
+ <sql name="retrieveMessageBodySizeSQL" db="postgresql">SELECT
length(message_body) FROM ${table} WHERE message_name = ? AND repository_name =
?</sql>
+ <sql name="retrieveMessageBodySizeSQL" db="oracle">SELECT
dbms_lob.getlength(message_body) FROM ${table} WHERE message_name = ? AND
repository_name = ?</sql>
+ <sql name="retrieveMessageBodySizeSQL" db="db2">SELECT
length(message_body) FROM ${table} WHERE message_name = ? AND repository_name =
?</sql>
+ <sql name="retrieveMessageBodySizeSQL" db="ingres">SELECT
length(message_body) FROM ${table} WHERE message_name = ? AND repository_name =
?</sql>
+ <sql name="retrieveMessageBodySizeSQL" db="derby">SELECT
length(message_body) FROM ${table} WHERE message_name = ? AND repository_name =
?</sql>
+
+ <!-- Statements used to delete a message stored in this repository. -->
+ <sql name="removeMessageSQL">DELETE FROM ${table} WHERE message_name = ?
AND repository_name = ?</sql>
+
+ <!-- Statements used to list all messages stored in this repository. -->
+ <sql name="listMessagesSQL">SELECT message_name, message_state,
last_updated FROM ${table} WHERE repository_name = ? ORDER BY last_updated
ASC</sql>
+
+ <!-- Statements used to create the table associated with this class. -->
+ <sql name="createTable" db="mysql">
+ CREATE TABLE ${table} (
+ message_name varchar (200) NOT NULL,
+ repository_name varchar (100) NOT NULL,
+ message_state varchar (30) NOT NULL ,
+ error_message varchar (200) NULL ,
+ sender varchar (255) NULL ,
+ recipients text NOT NULL ,
+ remote_host varchar (255) NOT NULL ,
+ remote_addr varchar (20) NOT NULL ,
+ message_body longblob NOT NULL ,
+ message_attributes longblob NULL ,
+ last_updated datetime NOT NULL,
+ PRIMARY KEY (repository_name, message_name)
+ )
+ </sql>
+ <sql name="createTable" db="hypersonic">
+ CREATE CACHED TABLE ${table} (
+ message_name varchar (200) NOT NULL,
+ repository_name varchar (255) NOT NULL,
+ message_state varchar (30) NOT NULL ,
+ error_message varchar (200) NULL ,
+ sender varchar (255) NULL ,
+ recipients varchar NOT NULL ,
+ remote_host varchar (255) NOT NULL ,
+ remote_addr varchar (20) NOT NULL ,
+ message_body varchar NOT NULL ,
+ message_attributes varchar NULL ,
+ last_updated timestamp NOT NULL,
+ PRIMARY KEY (repository_name, message_name)
+ )
+ </sql>
+ <sql name="createTable" db="hsqldb">
+ CREATE CACHED TABLE ${table} (
+ message_name varchar (200) NOT NULL,
+ repository_name varchar (255) NOT NULL,
+ message_state varchar (30) NOT NULL ,
+ error_message varchar (200) NULL ,
+ sender varchar (255) NULL ,
+ recipients varchar NOT NULL ,
+ remote_host varchar (255) NOT NULL ,
+ remote_addr varchar (20) NOT NULL ,
+ message_body varchar NOT NULL ,
+ message_attributes varchar NULL ,
+ last_updated timestamp NOT NULL,
+ PRIMARY KEY (repository_name, message_name)
+ )
+ </sql>
+ <sql name="createTable" db="mssql">
+ CREATE TABLE [${table}] (
+ [message_name] [varchar] (200) NOT NULL,
+ [repository_name] [varchar] (255) NOT NULL,
+ [message_state] [varchar] (30) NOT NULL ,
+ [error_message] [varchar] (1000) NULL ,
+ [sender] [varchar] (255) NULL ,
+ [recipients] [text] NOT NULL ,
+ [remote_host] [varchar] (255) NOT NULL ,
+ [remote_addr] [varchar] (20) NOT NULL ,
+ [message_body] [image] NOT NULL ,
+ [message_attributes] [image] NULL ,
+ [last_updated] [datetime] NOT NULL,
+ PRIMARY KEY (repository_name, message_name)
+ )
+ </sql>
+ <sql name="createTable" db="oracle">
+ CREATE TABLE ${table} (
+ message_name varchar2(200) NOT NULL ,
+ repository_name varchar2(255) NOT NULL ,
+ message_state varchar2(30) NOT NULL ,
+ error_message varchar2(200) NULL ,
+ sender varchar2(255) ,
+ recipients varchar2(1000) NOT NULL ,
+ remote_host varchar2(100) NOT NULL ,
+ remote_addr varchar2(20) NOT NULL ,
+ message_body blob NOT NULL ,
+ message_attributes blob NULL ,
+ last_updated date NOT NULL ,
+ PRIMARY KEY (repository_name, message_name)
+ )
+ </sql>
+ <sql name="createTable" db="postgresql">
+ CREATE TABLE ${table} (
+ message_name varchar (200) NOT NULL,
+ repository_name varchar (255) NOT NULL,
+ message_state varchar (30) NOT NULL ,
+ error_message varchar (200) NULL ,
+ sender varchar (255) NULL ,
+ recipients text NOT NULL ,
+ remote_host varchar (255) NOT NULL ,
+ remote_addr varchar (20) NOT NULL ,
+ message_body bytea NOT NULL ,
+ message_attributes bytea NULL ,
+ last_updated timestamp NOT NULL,
+ PRIMARY KEY (repository_name, message_name)
+ )
+ </sql>
+ <sql name="createTable" db="sapdb">
+ CREATE TABLE ${table} (
+ message_name varchar (200) NOT NULL,
+ repository_name varchar (200) NOT NULL,
+ message_state varchar (30) NOT NULL ,
+ error_message varchar (200) NULL ,
+ sender varchar (200) NULL ,
+ recipients long NOT NULL ,
+ remote_host varchar (100) NOT NULL ,
+ remote_addr varchar (20) NOT NULL ,
+ message_body long byte NOT NULL ,
+ message_attributes long byte NULL ,
+ last_updated date NOT NULL,
+ PRIMARY KEY (repository_name, message_name)
+ )
+ </sql>
+ <sql name="createTable" db="db2">
+ CREATE TABLE ${table} (
+ message_name varchar(200) NOT NULL ,
+ repository_name varchar(255) NOT NULL ,
+ message_state varchar(30) NOT NULL ,
+ error_message varchar(200) ,
+ sender varchar(255) ,
+ recipients varchar(1000) NOT NULL ,
+ remote_host varchar(100) NOT NULL ,
+ remote_addr varchar(20) NOT NULL ,
+ message_body blob NOT NULL ,
+ message_attributes blob ,
+ last_updated timestamp NOT NULL ,
+ PRIMARY KEY (repository_name, message_name)
+ )
+ </sql>
+ <sql name="createTable" db="ingres">
+ CREATE TABLE ${table} (
+ message_name varchar (200) NOT NULL,
+ repository_name varchar (255) NOT NULL,
+ message_state varchar (30) NOT NULL ,
+ error_message varchar (200) ,
+ sender varchar (255) ,
+ recipients LONG VARCHAR NOT NULL ,
+ remote_host varchar (255) NOT NULL ,
+ remote_addr varchar (20) NOT NULL ,
+ message_body LONG BYTE NOT NULL ,
+ message_attributes LONG BYTE ,
+ last_updated DATE NOT NULL
+ )
+ </sql>
+ <sql name="createTable" db="derby">
+ CREATE TABLE ${table} (
+ message_name varchar (200) NOT NULL,
+ repository_name varchar (255) NOT NULL,
+ message_state varchar (30) NOT NULL ,
+ error_message varchar (200) ,
+ sender varchar (255) ,
+ recipients long varchar NOT NULL ,
+ remote_host varchar (255) NOT NULL ,
+ remote_addr varchar (20) NOT NULL ,
+ message_body blob NOT NULL ,
+ message_attributes blob ,
+ last_updated timestamp NOT NULL,
+ PRIMARY KEY (repository_name, message_name)
+ )
+ </sql>
+</sqlDefs>
+
+<sqlDefs name="org.apache.james.util.bayesian.JDBCBayesianAnalyzer">
+
+ <sql name="hamTableName">bayesiananalysis_ham</sql>
+ <sql name="spamTableName">bayesiananalysis_spam</sql>
+ <sql name="messageCountsTableName">bayesiananalysis_messagecounts</sql>
+
+ <!-- Statements used to retrieve the message counts. -->
+ <sql name="selectMessageCounts">SELECT HAMCOUNT, SPAMCOUNT FROM
bayesiananalysis_messagecounts</sql>
+
+ <!-- Statements used to initialize the message counts. -->
+ <sql name="initializeMessageCounts">INSERT INTO
bayesiananalysis_messagecounts (HAMCOUNT, SPAMCOUNT) VALUES (0,0)</sql>
+
+ <!-- Statements used to update the ham message counts. -->
+ <sql name="updateHamMessageCounts">UPDATE bayesiananalysis_messagecounts
SET HAMCOUNT=(HAMCOUNT + ?)</sql>
+
+ <!-- Statements used to update the spam message counts. -->
+ <sql name="updateSpamMessageCounts">UPDATE bayesiananalysis_messagecounts
SET SPAMCOUNT=(SPAMCOUNT + ?)</sql>
+
+ <!-- Statements used to retrieve the ham token counts. -->
+ <sql name="selectHamTokens">SELECT TOKEN, OCCURRENCES FROM
bayesiananalysis_ham</sql>
+
+ <!-- Statements used to retrieve the spam token counts. -->
+ <sql name="selectSpamTokens">SELECT TOKEN, OCCURRENCES FROM
bayesiananalysis_spam</sql>
+
+ <!-- Statements used to insert the ham token counts. -->
+ <sql name="insertHamToken">INSERT INTO bayesiananalysis_ham (TOKEN,
OCCURRENCES) VALUES (?,?)</sql>
+
+ <!-- Statements used to insert the spam token counts. -->
+ <sql name="insertSpamToken">INSERT INTO bayesiananalysis_spam (TOKEN,
OCCURRENCES) VALUES (?,?)</sql>
+
+ <!-- Statements used to update the ham token counts. -->
+ <sql name="updateHamToken">UPDATE bayesiananalysis_ham SET
OCCURRENCES=(OCCURRENCES + ?) WHERE (TOKEN=?)</sql>
+
+ <!-- Statements used to update the spam token counts. -->
+ <sql name="updateSpamToken">UPDATE bayesiananalysis_spam SET
OCCURRENCES=(OCCURRENCES + ?) WHERE (TOKEN=?)</sql>
+
+ <!-- Statements used to delete ham tokens. -->
+ <sql name="deleteHamTokens">DELETE FROM bayesiananalysis_ham</sql>
+
+ <!-- Statements used to delete spam tokens. -->
+ <sql name="deleteSpamTokens">DELETE FROM bayesiananalysis_spam</sql>
+
+ <!-- Statements used to delete message counts. -->
+ <sql name="deleteMessageCounts">DELETE FROM
bayesiananalysis_messagecounts</sql>
+
+
+ <!-- Statements used to create the "ham" table (the 'token' field must be
case sensitive). -->
+ <sql name="createHamTable" db="mysql">
+ CREATE TABLE bayesiananalysis_ham (
+ token varchar(128) binary NOT NULL default '',
+ occurrences int(11) NOT NULL default '0',
+ PRIMARY KEY (token)
+ ) TYPE=InnoDB
+ </sql>
+ <sql name="createHamTable" db="mssql">
+ CREATE TABLE [bayesiananalysis_ham] (
+ [token] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL,
+ [occurrences] [int] NOT NULL default (0),
+ PRIMARY KEY (token)
+ )
+ </sql>
+ <sql name="createHamTable" db="derby">
+ CREATE TABLE bayesiananalysis_ham (
+ token varchar(128) NOT NULL,
+ occurrences INTEGER NOT NULL default 0,
+ PRIMARY KEY (token)
+ )
+ </sql>
+ <sql name="createHamTable" db="postgresql">
+ CREATE TABLE bayesiananalysis_ham (
+ token varchar(128) NOT NULL,
+ occurrences int NOT NULL default 0,
+ PRIMARY KEY (token)
+ )
+ </sql>
+
+ <!-- Statements used to create the "spam" table (the 'token' field must be
case sensitive). -->
+ <sql name="createSpamTable" db="mysql">
+ CREATE TABLE bayesiananalysis_spam (
+ token varchar(128) binary NOT NULL default '',
+ occurrences int(11) NOT NULL default '0',
+ PRIMARY KEY (token)
+ ) TYPE=InnoDB
+ </sql>
+ <sql name="createSpamTable" db="mssql">
+ CREATE TABLE [bayesiananalysis_spam] (
+ [token] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL,
+ [occurrences] [int] NOT NULL default (0),
+ PRIMARY KEY (token)
+ )
+ </sql>
+ <sql name="createSpamTable" db="derby">
+ CREATE TABLE bayesiananalysis_spam (
+ token varchar (128) NOT NULL,
+ occurrences INTEGER NOT NULL default 0,
+ PRIMARY KEY (token)
+ )
+ </sql>
+ <sql name="createSpamTable" db="postgresql">
+ CREATE TABLE bayesiananalysis_spam (
+ token varchar (128) NOT NULL,
+ occurrences int NOT NULL default 0,
+ PRIMARY KEY (token)
+ )
+ </sql>
+
+ <!-- Statements used to create the "message counts" table. -->
+ <sql name="createMessageCountsTable" db="mysql">
+ CREATE TABLE bayesiananalysis_messagecounts (
+ hamcount int(11) NOT NULL default '0',
+ spamcount int(11) NOT NULL default '0'
+ ) TYPE=InnoDB
+ </sql>
+ <sql name="createMessageCountsTable" db="mssql">
+ CREATE TABLE [bayesiananalysis_messagecounts] (
+ [hamcount] [int] NOT NULL default (0),
+ [spamcount] [int] NOT NULL default (0)
+ )
+ </sql>
+ <sql name="createMessageCountsTable" db="derby">
+ CREATE TABLE bayesiananalysis_messagecounts (
+ hamcount INTEGER NOT NULL default 0,
+ spamcount INTEGER NOT NULL default 0
+ )
+ </sql>
+ <sql name="createMessageCountsTable" db="postgresql">
+ CREATE TABLE bayesiananalysis_messagecounts (
+ hamcount int NOT NULL default 0,
+ spamcount int NOT NULL default 0
+ )
+ </sql>
+</sqlDefs>
+
+<sqlDefs name="WhiteList">
+
+ <sql name="whiteListTableName">whitelist</sql>
+
+ <!-- Statements used to retrieve a single entry. -->
+ <sql name="selectByPK">SELECT localUser, localHost FROM whitelist where
(localUser=? AND localHost=? AND remoteUser=? AND remoteHost=?)</sql>
+
+ <!-- Statements used to all entries by sender address. -->
+ <sql name="selectBySender">SELECT remoteUser, remoteHost FROM whitelist
where (localUser=? AND localHost=?) ORDER BY remoteUser, remoteHost</sql>
+
+ <!-- Statements used to insert an entry. -->
+ <sql name="insert">INSERT INTO whitelist (localUser, localHost,
remoteUser, remoteHost) VALUES (?,?,?,?)</sql>
+
+ <!-- Statements used to delete an entry. -->
+ <sql name="deleteByPK">DELETE FROM whitelist where (localUser=? AND
localHost=? AND remoteUser=? AND remoteHost=?)</sql>
+
+ <!-- Statements used to create the "whitelist" table. -->
+ <sql name="createWhiteListTable" db="hypersonic">
+ CREATE TABLE whitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ remoteUser varchar (64) NOT NULL,
+ remoteHost varchar (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ ) </sql>
+ <sql name="createWhiteListTable" db="hsqldb">
+ CREATE CACHED TABLE ${table} (
+ CREATE TABLE whitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ remoteUser varchar (64) NOT NULL,
+ remoteHost varchar (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ ) </sql>
+ <sql name="createWhiteListTable" db="mysql">
+ CREATE TABLE whitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) character set latin1 NOT NULL,
+ remoteUser varchar (64) NOT NULL,
+ remoteHost varchar (255) character set latin1 NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ ) TYPE=InnoDB
+ </sql>
+ <sql name="createWhiteListTable" db="mssql">
+ CREATE TABLE [whitelist] (
+ [localUser] [varchar] (64) NOT NULL,
+ [localHost] [varchar] (255) NOT NULL,
+ [remoteUser] [varchar] (64) NOT NULL,
+ [remoteHost] [varchar] (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ )
+ </sql>
+ <sql name="createWhiteListTable" db="oracle">
+ CREATE TABLE whitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ remoteUser varchar (64) NOT NULL,
+ remoteHost varchar (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ )
+ </sql>
+ <sql name="createWhiteListTable" db="postgresql">
+ CREATE TABLE whitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ remoteUser varchar (64) NOT NULL,
+ remoteHost varchar (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ )
+ </sql>
+ <sql name="createWhiteListTable" db="sapdb">
+ CREATE TABLE whitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ remoteUser varchar (64) NOT NULL,
+ remoteHost varchar (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ )
+ </sql>
+ <sql name="createWhiteListTable" db="db2">
+ CREATE TABLE whitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ remoteUser varchar (64) NOT NULL,
+ remoteHost varchar (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ )
+ </sql>
+ <sql name="createWhiteListTable" db="ingres">
+ CREATE TABLE whitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ remoteUser varchar (64) NOT NULL,
+ remoteHost varchar (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ )
+ </sql>
+ <sql name="createWhiteListTable" db="derby">
+ CREATE TABLE whitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ remoteUser varchar (64) NOT NULL,
+ remoteHost varchar (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost, remoteUser, remoteHost)
+ )
+ </sql>
+
+</sqlDefs>
+
+<sqlDefs name="NetworkWhiteList">
+
+ <sql name="networkWhiteListTableName">networkWhitelist</sql>
+
+ <!-- Statements used to retrieve a single entry. -->
+ <sql name="selectNetwork">SELECT network FROM networkWhitelist where
(localUser=? AND localHost=?)</sql>
+
+ <!-- Statements used to create the "whitelist" table. -->
+ <sql name="createNetworkWhiteListTable" db="hypersonic">
+ CREATE TABLE networkWhitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ network varchar (255) NOT NULL,
+ PRIMARY KEY (localUser, localHost)
+ ) </sql>
+ <sql name="createNetworkWhiteListTable" db="hsqldb">
+ CREATE CACHED TABLE ${table} (
+ CREATE TABLE networkWhitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ network varchar (255) NOT NULL
+ ) </sql>
+ <sql name="createNetworkWhiteListTable" db="mysql">
+ CREATE TABLE networkWhitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) character set latin1 NOT NULL,
+ network varchar (255) NOT NULL
+ ) TYPE=InnoDB
+ </sql>
+ <sql name="createNetworkWhiteListTable" db="mssql">
+ CREATE TABLE [networkWhitelist] (
+ [localUser] [varchar] (64) NOT NULL,
+ [localHost] [varchar] (255) NOT NULL,
+ [network] [varchar] (255) NOT NULL
+ )
+ </sql>
+ <sql name="createNetworkWhiteListTable" db="oracle">
+ CREATE TABLE networkWhitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ network varchar (255) NOT NULL
+ )
+ </sql>
+ <sql name="createNetworkWhiteListTable" db="postgresql">
+ CREATE TABLE networkWhitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ network varchar (255) NOT NULL
+ )
+ </sql>
+ <sql name="createNetworkWhiteListTable" db="sapdb">
+ CREATE TABLE networkWhitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ network varchar (255) NOT NULL
+ )
+ </sql>
+ <sql name="createNetworkWhiteListTable" db="db2">
+ CREATE TABLE networkWhitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ network varchar (255) NOT NULL
+ )
+ </sql>
+ <sql name="createNetworkWhiteListTable" db="ingres">
+ CREATE TABLE networkWhitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ network varchar (255) NOT NULL
+ )
+ </sql>
+ <sql name="createNetworkWhiteListTable" db="derby">
+ CREATE TABLE networkWhitelist (
+ localUser varchar (64) NOT NULL,
+ localHost varchar (255) NOT NULL,
+ network varchar (255) NOT NULL
+ )
+ </sql>
+
+</sqlDefs>
+
+<sqlDefs name="GreyList">
+
+ <sql name="greyListTableName">greylist</sql>
+
+ <!-- Statements used to retrieve a single entry. -->
+ <sql name="selectQuery">SELECT create_time,count FROM greylist WHERE
ipaddress = ? AND sender = ? AND recip = ?</sql>
+
+ <!-- Statements used to insert an entry. -->
+ <sql name="insertQuery">INSERT INTO greylist
(ipaddress,sender,recip,count,create_time) values (?,?,?,?,?)</sql>
+
+ <!-- Statements used to delete an entry. -->
+ <sql name="deleteQuery">DELETE FROM greylist WHERE create_time < ? AND
count = 0</sql>
+
+ <!-- Statements used to delete an entry. -->
+ <sql name="deleteAutoWhitelistQuery">DELETE FROM greylist WHERE
create_time < ?</sql>
+
+ <!-- Statements used to delete an entry. -->
+ <sql name="updateQuery">UPDATE greylist SET create_time = ? , count = ?
WHERE ipaddress = ? AND sender = ? AND recip = ?</sql>
+
+ <!-- Statements used to create the "whitelist" table. -->
+ <sql name="createGreyListTable" db="hypersonic">
+ CREATE TABLE greylist (
+ ipaddress varchar (20) NOT NULL,
+ sender varchar (255) NOT NULL,
+ recip varchar (255) NOT NULL,
+ count int NOT NULL,
+ create_time datetime NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ ) </sql>
+
+ <sql name="createGreyListTable" db="hsqldb">
+ CREATE CACHED TABLE ${table} (
+ CREATE TABLE greylist (
+ ipaddress varchar (20) NOT NULL,
+ sender varchar (255) NOT NULL,
+ recip varchar (255) NOT NULL,
+ count int NOT NULL,
+ create_time timestamo NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ ) </sql>
+ <sql name="createGreyListTable" db="mysql">
+ CREATE TABLE greylist (
+ ipaddress varchar (20) NOT NULL,
+ sender varchar (255) NOT NULL,
+ recip varchar (255) NOT NULL,
+ count int NOT NULL,
+ create_time datetime NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ ) TYPE=InnoDB
+ </sql>
+ <sql name="createGreyListTable" db="mssql">
+ CREATE TABLE [greylist] (
+ [ipaddress] [varchar] (20) NOT NULL,
+ [sender] [varchar] (255) NOT NULL,
+ [recip] [varchar] (255) NOT NULL,
+ [count] [int] NOT NULL,
+ [create_time] [datetime] NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ )
+ </sql>
+ <sql name="createGreyListTable" db="oracle">
+ CREATE TABLE greylist (
+ ipaddress varchar2(20) NOT NULL,
+ sender varchar2(255) NOT NULL,
+ recip varchar2(255) NOT NULL,
+ count int NOT NULL,
+ create_time datetime NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ )
+ </sql>
+ <sql name="createGreyListTable" db="postgresql">
+ CREATE TABLE greylist (
+ ipaddress varchar (20) NOT NULL,
+ sender varchar (255) NOT NULL,
+ recip varchar (255) NOT NULL,
+ count int NOT NULL,
+ create_time timestamp NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ )
+ </sql>
+ <sql name="createGreyListTable" db="sapdb">
+ CREATE TABLE greylist (
+ ipaddress varchar (20) NOT NULL,
+ sender varchar (255) NOT NULL,
+ recip varchar (255) NOT NULL,
+ count int NOT NULL,
+ create_time date NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ )
+ </sql>
+ <sql name="createGreyListTable" db="db2">
+ CREATE TABLE greylist (
+ ipaddress varchar (20) NOT NULL,
+ sender varchar (255) NOT NULL,
+ recip varchar (255) NOT NULL,
+ count int NOT NULL,
+ create_time timestamp NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ )
+ </sql>
+ <sql name="createGreyListTable" db="ingres">
+ CREATE TABLE greylist (
+ ipaddress varchar (20) NOT NULL,
+ sender varchar (255) NOT NULL,
+ recip varchar (255) NOT NULL,
+ count int NOT NULL,
+ create_time date NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ )
+ </sql>
+ <sql name="createGreyListTable" db="derby">
+ CREATE TABLE greylist (
+ ipaddress varchar (20) NOT NULL,
+ sender varchar (255) NOT NULL,
+ recip varchar (255) NOT NULL,
+ count int NOT NULL,
+ create_time timestamp NOT NULL,
+ PRIMARY KEY (ipaddress,sender,recip)
+ )
+ </sql>
+</sqlDefs>
+
+<sqlDefs name="org.apache.james.rrt.jdbc.JDBCRecipientRewriteTable">
+
+ <!-- Statements used to check whether a particular message exists in this
repository. -->
+ <sql name="selectMappings" db="derby">select
RecipientRewriteTable.target_address,(RecipientRewriteTable."user" || '@'
||RecipientRewriteTable.domain) from RecipientRewriteTable,
RecipientRewriteTable as VUTDomains where ((RecipientRewriteTable."user") like
? or (RecipientRewriteTable."user") = '*') and (RecipientRewriteTable.domain
like ? or (RecipientRewriteTable.domain = '*')) order by 2 desc</sql>
+ <sql name="selectMappings">select RecipientRewriteTable.target_address
from RecipientRewriteTable, RecipientRewriteTable as VUTDomains where
(RecipientRewriteTable.user like ? or RecipientRewriteTable.user = '*') and
(RecipientRewriteTable.domain like ? or (RecipientRewriteTable.domain = '*'))
order by concat(RecipientRewriteTable.user,'@',RecipientRewriteTable.domain)
desc limit 1</sql>
+ <sql name="selectMappings" db="postgresql">select
RecipientRewriteTable.target_address from RecipientRewriteTable,
RecipientRewriteTable as VUTDomains where (RecipientRewriteTable.user like ? or
RecipientRewriteTable.user = '*') and (RecipientRewriteTable.domain like ? or
(RecipientRewriteTable.domain = '*')) order by (RecipientRewriteTable.user ||
'@' || RecipientRewriteTable.domain) desc limit 1</sql>
+
+ <sql name="selectUserDomainMapping" db="derby">select
RecipientRewriteTable.target_address from RecipientRewriteTable where
RecipientRewriteTable."user" = ? and RecipientRewriteTable.domain = ? </sql>
+ <sql name="selectUserDomainMapping">select
RecipientRewriteTable.target_address from RecipientRewriteTable where
RecipientRewriteTable.user = ? and RecipientRewriteTable.domain = ? </sql>
+
+ <sql name="deleteMapping">delete from RecipientRewriteTable where
RecipientRewriteTable."user" = ? and RecipientRewriteTable.domain = ? and
RecipientRewriteTable.target_address = ?</sql>
+
+ <sql name="updateMapping">update RecipientRewriteTable set
RecipientRewriteTable.target_address = ? where RecipientRewriteTable."user" = ?
and RecipientRewriteTable.domain = ? </sql>
+
+ <sql name="addMapping">insert into RecipientRewriteTable values(?,?,?)
</sql>
+
+ <sql name="selectAllMappings">select * from RecipientRewriteTable </sql>
+
+ <!-- Statements used to create the table associated with this class. -->
+ <sql name="createTable" db="mysql">
+ CREATE TABLE RecipientRewriteTable (
+ user varchar(64) NOT NULL default '',
+ domain varchar(255) NOT NULL default '',
+ target_address varchar(255) NOT NULL default '',
+ PRIMARY KEY (user,domain)
+ )
+ </sql>
+ <!-- TEMPORARY DISABLED -->
+ <!--
+ <sql name="createTable" db="hypersonic">
+ CREATE CACHED TABLE RecipientRewriteTable (
+ user varchar(64) NOT NULL default '',
+ domain varchar(255) NOT NULL default '',
+ target_address varchar(255) NOT NULL default '',
+ PRIMARY KEY (user,domain)
+ )
+ </sql>
+ <sql name="createTable" db="hsqldb">
+ CREATE CACHED TABLE RecipientRewriteTable (
+ user varchar(64) NOT NULL default '',
+ domain varchar(255) NOT NULL default '',
+ target_address varchar(255) NOT NULL default '',
+ PRIMARY KEY (user,domain)
+ )
+ </sql>
+ <sql name="createTable" db="mssql">
+ CREATE TABLE [RecipientRewriteTable] (
+ [user] [varchar] (64) NOT NULL default '',
+ [domain] [varchar] (255) NOT NULL default '',
+ [target_address] [varchar] (255) NOT NULL default '',
+ PRIMARY KEY (user,domain)
+ )
+ </sql>
+ <sql name="createTable" db="oracle">
+ CREATE TABLE RecipientRewriteTable (
+ user varchar2(64) NOT NULL default '',
+ domain varchar2(255) NOT NULL default '',
+ target_address varchar2(255) NOT NULL default '',
+ PRIMARY KEY (user,domain)
+ )
+ </sql>
+ <sql name="createTable" db="sapdb">
+ CREATE TABLE RecipientRewriteTable (
+ user varchar(64) NOT NULL default '',
+ domain varchar(255) NOT NULL default '',
+ target_address varchar(255) NOT NULL default '',
+ PRIMARY KEY (user,domain)
+ )
+ </sql>
+ <sql name="createTable" db="db2">
+ CREATE TABLE RecipientRewriteTable (
+ user varchar(64) NOT NULL default '',
+ domain varchar(255) NOT NULL default '',
+ target_address varchar(255) NOT NULL default '',
+ PRIMARY KEY (user,domain)
+ )
+ </sql>
+ <sql name="createTable" db="ingres">
+ CREATE TABLE RecipientRewriteTable (
+ user varchar(64) NOT NULL default '',
+ domain varchar(255) NOT NULL default '',
+ target_address varchar(255) NOT NULL default '',
+ PRIMARY KEY (user,domain)
+ )
+ </sql>
+ -->
+ <sql name="createTable" db="postgresql">
+ CREATE TABLE RecipientRewriteTable (
+ "user" varchar(64) NOT NULL default '',
+ domain varchar(255) NOT NULL default '',
+ target_address varchar(255) NOT NULL default '',
+ PRIMARY KEY ("user",domain)
+ )
+ </sql>
+ <sql name="createTable" db="derby">
+ CREATE TABLE RecipientRewriteTable (
+ "user" varchar (64) NOT NULL default '',
+ domain varchar (255) NOT NULL default '',
+ target_address varchar (255) NOT NULL default '',
+ PRIMARY KEY ("user",domain)
+ )
+ </sql>
+</sqlDefs>
+
+</sqlResources>
+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
