noel 2002/12/13 15:36:46 Modified: src/xdocs using_database_2_1.xml Log: Added an example section Revision Changes Path 1.5 +39 -0 jakarta-james/src/xdocs/using_database_2_1.xml Index: using_database_2_1.xml =================================================================== RCS file: /home/cvs/jakarta-james/src/xdocs/using_database_2_1.xml,v retrieving revision 1.4 retrieving revision 1.5 diff -u -r1.4 -r1.5 --- using_database_2_1.xml 12 Dec 2002 02:51:12 -0000 1.4 +++ using_database_2_1.xml 13 Dec 2002 23:36:46 -0000 1.5 @@ -62,6 +62,45 @@ special case, please let us know.</p> </subsection> + +<subsection name="An example"> + +<p>The configuration file has commented out examples for MySQL and +MSSQL data sources, and for each of the standard repositories. For +example, to use MySQL, you would uncomment and adjust the following +data-source element. You must create the database, in this case named +<strong>mail</strong>, the user, and assign the user priviledges. +James will automatically create the tables it needs.</p> + +<source> +<data-source name="maildb" class="org.apache.james.util.mordred.JdbcDataSource"> + <driver>org.gjt.mm.mysql.Driver</driver> + <dburl>jdbc:mysql://127.0.0.1/mail</dburl> + <user>username</user> + <password>password</password> + <max>20</max> +</data-source> +</source> + +<p>Once you have created the data-source element, you can use it else where in the configuration file. For example, the following element tells James to use the maildb data-source and dbfile storage mechanism for the message spool:</p> + +<source> +<spoolRepository> + <repository destinationURL="dbfile://maildb/spool/spool" type="SPOOL"/> +</spoolRepository> +</source> + +<p>The following element tells James to store mailboxes in a the maildb data-source:</p> + +<source> +<inboxRepository> + <repository destinationURL="db://maildb/inbox/" type="MAIL"/> +</inboxRepository> +</source> + +<p>The configuration file contains further examples.</p> +</subsection> + <subsection name="Known Issues"> <p>There are some vendor-specific subtleties in using databases with James that have been observed by some users. These issues (and methods to resolve them) are recorded on the
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>