james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From se...@apache.org
Subject cvs commit: jakarta-james/src/conf sqlResources.xml
Date Wed, 27 Feb 2002 03:09:23 GMT
serge       02/02/26 19:09:23

  Modified:    src/conf sqlResources.xml
  Log:
  Added support for Oracle database care of Samuel.Sadek@kpmg.co.uk.
  
  Revision  Changes    Path
  1.11      +33 -2     jakarta-james/src/conf/sqlResources.xml
  
  Index: sqlResources.xml
  ===================================================================
  RCS file: /home/cvs/jakarta-james/src/conf/sqlResources.xml,v
  retrieving revision 1.10
  retrieving revision 1.11
  diff -u -r1.10 -r1.11
  --- sqlResources.xml	5 Dec 2001 22:15:32 -0000	1.10
  +++ sqlResources.xml	27 Feb 2002 03:09:23 -0000	1.11
  @@ -152,7 +152,23 @@
   			)
   
       </sql>
  -	<sql name="createTable" db="sapdb">
  +	<sql name="createTable" db="oracle">
  +        CREATE TABLE ${table} (
  +        message_name varchar2(200) NOT NULL ,
  +        repository_name varchar2(200) NOT NULL ,
  +        message_state varchar2(30) NOT NULL ,
  +        error_message varchar2(200) NULL ,
  +        sender varchar2(200) ,
  +        recipients varchar2(1000) NOT NULL ,
  +        remote_host varchar2(100) NOT NULL ,
  +        remote_addr varchar2(20) NOT NULL ,
  +        message_body long raw NOT NULL ,
  +        last_updated date NOT NULL ,
  +        PRIMARY KEY (message_name, repository_name)
  +        )
  +        TABLESPACE system
  +    </sql>
  +    <sql name="createTable" db="sapdb">
   		CREATE TABLE ${table} (
   			message_name varchar (200) NOT NULL,
   			repository_name varchar (200) NOT NULL,
  @@ -216,7 +232,22 @@
   			)
   
       </sql>
  -	<sql name="createTable" db="sapdb">
  +	<sql name="createTable" db="oracle">
  +        CREATE TABLE ${table} (
  +        message_name varchar2(200) NOT NULL ,
  +        repository_name varchar2(200) NOT NULL ,
  +        message_state varchar2(30) NOT NULL ,
  +        error_message varchar2(200) NULL ,
  +        sender varchar2(200) NULL ,
  +        recipients varchar2(1000) NOT NULL ,
  +        remote_host varchar2(100) NOT NULL ,
  +        remote_addr varchar2(20) NOT NULL ,
  +        message_body long raw NOT NULL ,
  +        last_updated date NOT NULL ,
  +        PRIMARY KEY (message_name, repository_name)
  +        )
  +    </sql>
  +    <sql name="createTable" db="sapdb">
   		CREATE TABLE ${table} (
   			message_name varchar (200) NOT NULL,
   			repository_name varchar (200) NOT NULL,
  
  
  

--
To unsubscribe, e-mail:   <mailto:james-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:james-dev-help@jakarta.apache.org>


Mime
View raw message