Problem using db store for the first time

[J Malcolm]

I've been using file storage until now.  I'm attempting to move to db
storage.  So this is an initial bringup problem.  I'm getting the
following error:

 ERROR   2004-04-01 23:16:02.258 [Phoenix.] (): Component named
"mailstore" failed to pass through the Initialization stage. (Reason:
org.apache.avalon.framework.component.ComponentException: Cannot find or
init repository).

Here are the relevant blocks in the config file:

   <mailstore>
      <repository
class="org.apache.james.mailrepository.JDBCMailRepository">
         <protocols>
            <protocol>db</protocol>
         </protocols>
         <types>
            <type>MAIL</type>
         </types>
         <config>
 
<sqlFile>file:///c:/james-2.1.3/apps/james/conf/sqlResources.xml</sqlFil
e>
         </config>
      </repository>

      <repository
class="org.apache.james.mailrepository.JDBCSpoolRepository">
         <protocols>
            <protocol>db</protocol>
         </protocols>
         <types>
            <type>SPOOL</type>
         </types>
         <config>
 
<sqlFile>file:///c:/james-2.1.3/apps/james/conf/sqlResources.xml</sqlFil
e>
         </config>
      </repository>

      <spoolRepository>
         <repository destinationURL="db://maildb/spool/spool"
type="SPOOL"/>
      </spoolRepository>
   </mailstore>

   <database-connections>
      <data-sources>
         <data-source name="maildb"
class="org.apache.james.util.mordred.JdbcDataSource">
            <driver>org.gjt.mm.mysql.Driver</driver>
 
<dburl>jdbc:mysql://localhost/mail?autoReconnect=true</dburl>
            <user>xxxxx</user>
            <password>xxxxxxxx</password>
            <max>40</max>
         </data-source>
      </data-sources>
   </database-connections>

========================================================================
==================

I created a db named "mail" in mysql.  It didn't appear from docs that I
have to create tables or anything.  

I tried renaming the data source and get the same error, which implies
to me it's not even getting that far.  But the error message implies
that it is.

Any ideas where I've gone wrong?  Any way to turn on high debug level in
phoenix (debug loglevel in mailstore doesn't yield any additional info).

One other question... if the url syntax is "db:<datasource>/<table>",
what does "db:/maildb/spool/spool" resolve to?  Is there a table created
named "spool/spool"

Thanks as always.

Jerry


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]