How to config James with MySQL

[Conan Edogawa <co...@barrysworld.com>]

Hi all,
I'm trying to config James to work with MySQL but it's failed.
In the phoenix log file:
1023882535403 [ERROR  ] (Phoenix.kernel.james.lifecycle): Block named "database-connections" failed to pass through the Initialization stage. (Reason: java.lang.ClassNotFoundException: com.inet.tds.TdsDriver).
I use James 2.03a with jdk 1.3.
What can I do?
My config.xml: 
<database-connections>
    <!-- Confugure database connections here.
         These connections are referred to by name elsewhere in the config file -->
<!-- CHECKME! To allow James to use a database, configure the database connection here -->
    <data-sources>
        <!-- Example, connecting to a MySQL database called "mail" on localhost
        -->
        
        <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>root</user>
            <password>pass</password>
            <max>2</max>
        </data-source>
        <data-source name="maildb"
                     class="org.apache.james.util.mordred.JdbcDataSource">
            <driver>com.inet.tds.TdsDriver</driver>
            <dburl>jdbc:inetdae7:127.0.0.1?database=James</dburl>
            <user>sa_james</user>
            <password>pass</password>
            <max>2</max>
        </data-source>
        
    </data-sources>
  </database-connections>
Thank you very much.
Regards,
C.E.

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: How to config James with MySQL

[Sérgio Eduardo Rodrigues <se...@modsoft.com.br>]

Em Quarta, 12 de Junho de 2002 09:18, voce escreveu:
> Hi all,
> I'm trying to config James to work with MySQL but it's failed.
> In the phoenix log file:
> 1023882535403 [ERROR  ] (Phoenix.kernel.james.lifecycle): Block named
> "database-connections" failed to pass through the Initialization stage.
> (Reason: java.lang.ClassNotFoundException: com.inet.tds.TdsDriver). I use
> James 2.03a with jdk 1.3.
> What can I do?
> My config.xml:
> <database-connections>
>     <!-- Confugure database connections here.
>          These connections are referred to by name elsewhere in the config
> file --> <!-- CHECKME! To allow James to use a database, configure the
> database connection here --> <data-sources>
>         <!-- Example, connecting to a MySQL database called "mail" on
> localhost -->
>
>         <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>

Replace root by your mysql user and pass by your password

>             <user>root</user>
>             <password>pass</password>
>             <max>2</max>
>         </data-source>

Remove next block, because this is for mssql and this driver doesn't exist in 
your classpath or bootclasspath.

>         <data-source name="maildb"
>                      class="org.apache.james.util.mordred.JdbcDataSource">
>             <driver>com.inet.tds.TdsDriver</driver>
>             <dburl>jdbc:inetdae7:127.0.0.1?database=James</dburl>
>             <user>sa_james</user>
>             <password>pass</password>
>             <max>2</max>
>         </data-source>
>
>     </data-sources>
>   </database-connections>
> Thank you very much.
> Regards,
> C.E.

Sérgio

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>