Thanks, applied.
Serge Knystautas
Loki Technologies - Unstoppable Websites
http://www.lokitech.com/
----- Original Message -----
From: "Samuel Sadek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 6:38 PM
Subject: RE: How to make James work with Oracle database?
> GREAT NEWS!!!
>
> Problem with James 2.02a integrated with Oracle 8.1.7 has now been
resolved.
> What's even better is that there has been minimal changes made to the
> version 2.02a of the code!!!
>
> The only change required is in the SqlResources.xml and config.xml scripts
> whereby a separate clause for Oracle 8.1.7 db handling is all that is ever
> required.
>
> Instead of using any LOB data type I have used the LONG RAW binary type
(max
> 2GB) which serves for this purpose.
>
>
> Here's the required snippet to be patched into config.xml:
>
> <database-connections>
> ...
> <data-sources>
> <data-source name="maildb"
> class="org.apache.james.util.mordred.JdbcDataSource">
> <driver>oracle.jdbc.driver.OracleDriver</driver>
> <dburl>jdbc:oracle:thin:@orange.secemail.dnsalias.com:1521:mail01</dburl>
> <user>anyuser</user>
> <password>anypassword</password>
> </data-source>
> ...
> </database-connections>
>
> Here's the required snippet to be patched into sqlResources.xml:
>
> <dbMatchers>
> ...
> <dbMatcher db="oracle" databaseProductName="oracle.*"/>
> ...
> </dbMatchers>
>
>
> <sqlDefs name="org.apache.james.mailrepository.JDBCMailRepository">
> ...
> <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>
> ...
> </sqlDefs>
>
>
> <sqlDefs name="org.apache.james.mailrepository.JDBCSpoolRepository">
> ...
> <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>
> ...
> </sqlDefs>
>
>
> And this is it! Can you please submit my credentials
> [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
> when you publish this snippet script code for next release for James?
>
> Also the problem I had to do with mail attachments has been fixed by using
> LONG RAW as opposed to LOB data types.
>
> Thanks for all your help, and especially to Darrell.
>
> Keep me posted for any future releases for James.
>
> Sam.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
