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-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org

Reply via email to