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 no...@apache.org on 2010/03/28 16:06:02 UTC
svn commit: r928399 - in /james/server/trunk:
core-function/src/main/java/org/apache/james/mailrepository/
remotemanager/src/main/java/org/apache/james/remotemanager/core/
spring-deployment/src/main/config/james/
Author: norman
Date: Sun Mar 28 14:06:01 2010
New Revision: 928399
URL: http://svn.apache.org/viewvc?rev=928399&view=rev
Log:
Remove SpoolRepository implementations, cause we use JMS now (JAMES-976)
Removed:
james/server/trunk/core-function/src/main/java/org/apache/james/mailrepository/FileSpoolRepository.java
james/server/trunk/core-function/src/main/java/org/apache/james/mailrepository/JDBCSpoolRepository.java
james/server/trunk/spring-deployment/src/main/config/james/spoolrepository.xml
Modified:
james/server/trunk/remotemanager/src/main/java/org/apache/james/remotemanager/core/CoreCmdHandlerLoader.java
james/server/trunk/spring-deployment/src/main/config/james/mailstore.xml
james/server/trunk/spring-deployment/src/main/config/james/spring-beans.xml
james/server/trunk/spring-deployment/src/main/config/james/sqlResources.xml
Modified: james/server/trunk/remotemanager/src/main/java/org/apache/james/remotemanager/core/CoreCmdHandlerLoader.java
URL: http://svn.apache.org/viewvc/james/server/trunk/remotemanager/src/main/java/org/apache/james/remotemanager/core/CoreCmdHandlerLoader.java?rev=928399&r1=928398&r2=928399&view=diff
==============================================================================
--- james/server/trunk/remotemanager/src/main/java/org/apache/james/remotemanager/core/CoreCmdHandlerLoader.java (original)
+++ james/server/trunk/remotemanager/src/main/java/org/apache/james/remotemanager/core/CoreCmdHandlerLoader.java Sun Mar 28 14:06:01 2010
@@ -32,10 +32,10 @@ public class CoreCmdHandlerLoader implem
private final static String ADDSPAMCMDHANDLER = AddSpamCmdHandler.class.getName();
private final static String ADDUSERCMDHANDLER = AddUserCmdHandler.class.getName();
private final static String COUNTUSERSCMDHANDLER = CountUsersCmdHandler.class.getName();
- private final static String DELETESPOOLCMDHANDLER = DeleteSpoolCmdHandler.class.getName();
+ //private final static String DELETESPOOLCMDHANDLER = DeleteSpoolCmdHandler.class.getName();
private final static String DELUSERCMDHANDLER = DelUserCmdHandler.class.getName();
private final static String EXPORTBAYESIANDATACMDHANDLER = ExportBayesianDataCmdHandler.class.getName();
- private final static String FLUSHSPOOLCMDHANDLER = FlushSpoolCmdHandler.class.getName();
+ //private final static String FLUSHSPOOLCMDHANDLER = FlushSpoolCmdHandler.class.getName();
private final static String HELPCMDHANDLER = HelpCmdHandler.class.getName();
private final static String IMPORTBAYESIANDATACMDHANDLER = ImportBayesianDataCmdHandler.class.getName();
@@ -45,10 +45,10 @@ public class CoreCmdHandlerLoader implem
private final static String LISTMAPPINGCMDHANDLER = ListMappingCmdHandler.class.getName();
private final static String LISTMATCHERSCMDHANDLER = ListMatchersCmdHandler.class.getName();
private final static String LISTPROCESSORSCMDHANDLER = ListProcessorsCmdHandler.class.getName();
- private final static String LISTSPOOLCMDHANDLER = ListSpoolCmdHandler.class.getName();
+ //private final static String LISTSPOOLCMDHANDLER = ListSpoolCmdHandler.class.getName();
private final static String LISTUSERSCMDHANDLER = ListUsersCmdHandler.class.getName();
private final static String MEMSTATCMDHANDLER = MemStatCmdHandler.class.getName();
- private final static String MOVEMAILSCMDHANDLER = MoveMailsCmdHandler.class.getName();
+ //private final static String MOVEMAILSCMDHANDLER = MoveMailsCmdHandler.class.getName();
private final static String QUITCMDHANDLER = QuitCmdHandler.class.getName();
private final static String REMOVEDOMAINCMDHANDLER = RemoveDomainCmdHandler.class.getName();
private final static String REMOVEMAPPINGCMDHANDLER = RemoveMappingCmdHandler.class.getName();
@@ -78,10 +78,10 @@ public class CoreCmdHandlerLoader implem
commands.add(ADDSPAMCMDHANDLER);
commands.add(ADDUSERCMDHANDLER);
commands.add(COUNTUSERSCMDHANDLER);
- commands.add(DELETESPOOLCMDHANDLER);
+ //commands.add(DELETESPOOLCMDHANDLER);
commands.add(DELUSERCMDHANDLER);
commands.add(EXPORTBAYESIANDATACMDHANDLER);
- commands.add(FLUSHSPOOLCMDHANDLER);
+ //commands.add(FLUSHSPOOLCMDHANDLER);
commands.add(HELPCMDHANDLER);
commands.add(IMPORTBAYESIANDATACMDHANDLER);
commands.add(LISTALLMAPPINGSCMDHANDLER);
@@ -90,10 +90,10 @@ public class CoreCmdHandlerLoader implem
commands.add(LISTMAPPINGCMDHANDLER);
commands.add(LISTMATCHERSCMDHANDLER);
commands.add(LISTPROCESSORSCMDHANDLER);
- commands.add(LISTSPOOLCMDHANDLER);
+ //commands.add(LISTSPOOLCMDHANDLER);
commands.add(LISTUSERSCMDHANDLER);
commands.add(MEMSTATCMDHANDLER);
- commands.add(MOVEMAILSCMDHANDLER);
+ //commands.add(MOVEMAILSCMDHANDLER);
commands.add(QUITCMDHANDLER);
commands.add(REMOVEDOMAINCMDHANDLER);
commands.add(REMOVEMAPPINGCMDHANDLER);
Modified: james/server/trunk/spring-deployment/src/main/config/james/mailstore.xml
URL: http://svn.apache.org/viewvc/james/server/trunk/spring-deployment/src/main/config/james/mailstore.xml?rev=928399&r1=928398&r2=928399&view=diff
==============================================================================
--- james/server/trunk/spring-deployment/src/main/config/james/mailstore.xml (original)
+++ james/server/trunk/spring-deployment/src/main/config/james/mailstore.xml Sun Mar 28 14:06:01 2010
@@ -32,14 +32,6 @@
<!-- Set if the messages should be listed sorted. False by default -->
<config FIFO="false"/>
</repository>
- <repository class="org.apache.james.mailrepository.FileSpoolRepository">
- <protocols>
- <protocol>file</protocol>
- </protocols>
- <types>
- <type>SPOOL</type>
- </types>
- </repository>
<!-- JDBC based repositories. These repositories store all message data -->
<!-- in the database. -->
@@ -62,19 +54,6 @@
</config>
</repository>
- <repository class="org.apache.james.mailrepository.JDBCSpoolRepository">
- <protocols>
- <protocol>db</protocol>
- </protocols>
- <types>
- <type>SPOOL</type>
- </types>
- <config>
- <sqlFile>file://conf/sqlResources.xml</sqlFile>
- <maxcache>1000</maxcache>
- </config>
- </repository>
-
<!-- These repositories store message delivery and headers in the DB, and the body to the filesystem -->
<repository class="org.apache.james.mailrepository.JDBCMailRepository">
<protocols>
@@ -88,20 +67,6 @@
<filestore>file://var/dbmail</filestore>
</config>
</repository>
-
- <repository class="org.apache.james.mailrepository.JDBCSpoolRepository">
- <protocols>
- <protocol>dbfile</protocol>
- </protocols>
- <types>
- <type>SPOOL</type>
- </types>
- <config>
- <sqlFile>file://conf/sqlResources.xml</sqlFile>
- <filestore>file://var/dbmail</filestore>
- <maxcache>1000</maxcache>
- </config>
- </repository>
<!-- The mbox repository is designed for MAIL only; SPOOL performance would be less than ideal-->
<repository class="org.apache.james.mailrepository.MBoxMailRepository">
Modified: james/server/trunk/spring-deployment/src/main/config/james/spring-beans.xml
URL: http://svn.apache.org/viewvc/james/server/trunk/spring-deployment/src/main/config/james/spring-beans.xml?rev=928399&r1=928398&r2=928399&view=diff
==============================================================================
--- james/server/trunk/spring-deployment/src/main/config/james/spring-beans.xml (original)
+++ james/server/trunk/spring-deployment/src/main/config/james/spring-beans.xml Sun Mar 28 14:06:01 2010
@@ -1,7 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
-
- <!--
- ! Licensed to the Apache Software Foundation (ASF) under one ! ! or
+ <!--
+ ! 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
@@ -16,7 +15,7 @@
-->
-<beans xmlns="http://www.springframework.org/schema/beans"
+<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:camel="http://camel.apache.org/schema/spring"
xsi:schemaLocation="
@@ -24,60 +23,60 @@
http://camel.apache.org/schema/spring http://camel.apache.org/schema/spring/camel-spring.xsd">
- <!--
- ** JMX part ** to enable exposure of JMX, activate the following beans
+ <!--
+ ** JMX part ** to enable exposure of JMX, activate the following beans
- NOTE: if you are running JDK < 1.5, you'd have to make a MBeanServer
- implementation available on the classpath, for example mx4j
- -->
+ NOTE: if you are running JDK < 1.5, you'd have to make a MBeanServer
+ implementation available on the classpath, for example mx4j
+ -->
- <!--
- <bean id="exporter" class="org.springframework.jmx.export.MBeanExporter" lazy-init="false">
- <property name="autodetect" value="true" />
- <property name="namingStrategy" ref="namingStrategy" />
- </bean>
- <bean id="namingStrategy" class="org.springframework.jmx.export.naming.KeyNamingStrategy" >
- <property name="mappings" >
- <props>
- <prop key="fetchmail"> bean:name=fetchmail</prop>
- <prop key="smtpserver">bean:name=smtpserver</prop>
- <prop key="James" >bean:name=James</prop>
- <prop key="dnsserver" >bean:name=dnsserver</prop>
- <prop key="remotemanager" >bean:name=remotemanager</prop>
- <prop key="pop3server" >bean:name=pop3server</prop>
- <prop key="virtualusertablemanagement">bean:name=virtualusertablemanagement</prop>
- <prop key="spoolmanagement" >bean:name=spoolmanagement</prop>
- <prop key="domainlistmanagement" >bean:name=domainlistmanagement</prop>
- <prop key="processormanagement" >bean:name=processormanagement</prop>
- <prop key="bayesiananalyzermanagement">bean:name=bayesiananalyzermanagement</prop>
- <prop key="usermanagement" >bean:name=usermanagement</prop>
- <prop key="serverConnector" >bean:name=serverConnector</prop>
- </props>
- </property>
- </bean>
+ <!--
+ <bean id="exporter" class="org.springframework.jmx.export.MBeanExporter" lazy-init="false">
+ <property name="autodetect" value="true" />
+ <property name="namingStrategy" ref="namingStrategy" />
+ </bean>
+ <bean id="namingStrategy" class="org.springframework.jmx.export.naming.KeyNamingStrategy" >
+ <property name="mappings" >
+ <props>
+ <prop key="fetchmail"> bean:name=fetchmail</prop>
+ <prop key="smtpserver">bean:name=smtpserver</prop>
+ <prop key="James" >bean:name=James</prop>
+ <prop key="dnsserver" >bean:name=dnsserver</prop>
+ <prop key="remotemanager" >bean:name=remotemanager</prop>
+ <prop key="pop3server" >bean:name=pop3server</prop>
+ <prop key="virtualusertablemanagement">bean:name=virtualusertablemanagement</prop>
+ <prop key="spoolmanagement" >bean:name=spoolmanagement</prop>
+ <prop key="domainlistmanagement" >bean:name=domainlistmanagement</prop>
+ <prop key="processormanagement" >bean:name=processormanagement</prop>
+ <prop key="bayesiananalyzermanagement">bean:name=bayesiananalyzermanagement</prop>
+ <prop key="usermanagement" >bean:name=usermanagement</prop>
+ <prop key="serverConnector" >bean:name=serverConnector</prop>
+ </props>
+ </property>
+ </bean>
- <bean id="mbeanServer" class="org.springframework.jmx.support.MBeanServerFactoryBean" />
+ <bean id="mbeanServer" class="org.springframework.jmx.support.MBeanServerFactoryBean" />
- <bean id="registry" class="org.springframework.remoting.rmi.RmiRegistryFactoryBean">
- <property name="port" value="1099" />
- </bean>
+ <bean id="registry" class="org.springframework.remoting.rmi.RmiRegistryFactoryBean">
+ <property name="port" value="1099" />
+ </bean>
- <bean id="serverConnector" class="org.springframework.jmx.support.ConnectorServerFactoryBean" depends-on="registry">
- <property name="objectName" value="connector:name=rmi" />
- <property name="serviceUrl" value="service:jmx:rmi://localhost/jndi/rmi://localhost:1099/jamesmailserver" />
- </bean>
- -->
-
- <bean class="org.apache.james.container.spring.lifecycle.CommonsConfigurableBeanPostProcessor">
- <property name="configurationRegistry" ref="configurationRegistry" />
- <property name="order" value="1" />
- </bean>
+ <bean id="serverConnector" class="org.springframework.jmx.support.ConnectorServerFactoryBean" depends-on="registry">
+ <property name="objectName" value="connector:name=rmi" />
+ <property name="serviceUrl" value="service:jmx:rmi://localhost/jndi/rmi://localhost:1099/jamesmailserver" />
+ </bean>
+ -->
+
+ <bean class="org.apache.james.container.spring.lifecycle.CommonsConfigurableBeanPostProcessor">
+ <property name="configurationRegistry" ref="configurationRegistry" />
+ <property name="order" value="1" />
+ </bean>
- <bean id="configurationRegistry" class="org.apache.james.container.spring.lifecycle.SpringConfigurationRegistry">
- <property name="configurationMappings">
+ <bean id="configurationRegistry" class="org.apache.james.container.spring.lifecycle.SpringConfigurationRegistry">
+ <property name="configurationMappings">
<map>
<entry key="mailboxmanager" value="imapserver" />
- <entry key="mailetcontext" value="James"/>
+ <entry key="mailetcontext" value="James"/>
<entry key="smtpProtocolHandlerChain" value="smtpserver"/>
<entry key="pop3ProtocolHandlerChain" value="pop3server"/>
<entry key="remoteProtocolHandlerChain" value="remotemanager"/>
@@ -160,7 +159,8 @@
<property name="start" value="true" />
</bean>
- <!-- mailserver implementation which use activemq for spooling the mail -->
+ <!-- mailserver implementation which use activemq for spooling the mail
+-->
<bean id="mailserver" name="James" class="org.apache.james.ActiveMQMailServer"/>
<bean id="mailetcontext" class="org.apache.james.JamesMailetContext"/>
@@ -172,8 +172,10 @@
<bean id="dnsserver" class="org.apache.james.dnsserver.DNSServer" />
<!-- The Spool Management block -->
+ <!--
<bean id="spoolmanagement" class="org.apache.james.management.impl.SpoolManagement" />
-
+ -->
+
<bean id="processormanagement" class="org.apache.james.management.impl.ProcessorManagement" />
<bean id="bayesiananalyzermanagement"
@@ -224,9 +226,6 @@
<!-- The High Level Storage block -->
<bean id="mailstore" class="org.apache.james.container.spring.SpringMailStore" />
- <!-- The main SpoolRepository -->
- <bean id="spoolrepository"
- class="org.apache.james.mailrepository.MailStoreSpoolRepository" />
<!-- The User Storage block -->
<bean id="users-store" class="org.apache.james.container.spring.SpringUsersStore" >
@@ -415,5 +414,6 @@
<constructor-arg index="1" value="../var/jackrabbit" />
</bean>
- <!-- #################################################################### -->
+ <!-- ####################################################################
+-->
</beans>
\ No newline at end of file
Modified: james/server/trunk/spring-deployment/src/main/config/james/sqlResources.xml
URL: http://svn.apache.org/viewvc/james/server/trunk/spring-deployment/src/main/config/james/sqlResources.xml?rev=928399&r1=928398&r2=928399&view=diff
==============================================================================
--- james/server/trunk/spring-deployment/src/main/config/james/sqlResources.xml (original)
+++ james/server/trunk/spring-deployment/src/main/config/james/sqlResources.xml Sun Mar 28 14:06:01 2010
@@ -442,217 +442,6 @@
</sql>
</sqlDefs>
-<!-- SQL statements to support the JDBCSpoolRepository class -->
-<!-- -->
-<!-- The JDBCSpoolRepository allows James to use a JDBC compliant database -->
-<!-- to hold messages that are on the spool. -->
-<sqlDefs name="org.apache.james.mailrepository.JDBCSpoolRepository">
-
- <!-- 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>
-
- <!-- 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, error_message 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="hypersonic">
- 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 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="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="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) NULL ,
- recipients varchar2(1000) NOT NULL ,
- remote_host varchar2(255) 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 (255) NOT NULL,
- message_state varchar (30) NOT NULL ,
- error_message varchar (200) NULL ,
- sender varchar (255) NULL ,
- recipients long NOT NULL ,
- remote_host varchar (255) 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>
<!-- SQL statements to support the BayesianAnalysis and the BayesianAnalysisFeeder mailets -->
<!-- -->
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org