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