serge 02/02/26 19:09:23
Modified: src/conf sqlResources.xml
Log:
Added support for Oracle database care of [EMAIL PROTECTED]
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:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
