Problem configuring the DataSource

[Santosh]

Hi Everyone,

I am trying configure a DataSource for connecting to a database other
than "mail". Following is the configuration I am using in the
<database-connections> section:

<data-source name="jdbc/db"
class="org.apache.james.util.dbcp.JdbcDataSource">
        <driver>com.mysql.jdbc.Driver</driver>
<dburl>jdbc:mysql://localhost/mirage?useUnicode=true&amp;characterEncodi
ng=UTF-8&amp;characterSetResults=UTF-8&amp;autoReconnect=true</dburl>
      <user>root</user>
      <password>trunk</password>
      <max>100</max>
</data-source>

1) The server is unable to start. It throws a huge stacktrace in which
the following section seems most relevant:
Caused by: java.sql.SQLException: Communication failure during
handshake. Is there a server running
on localhost:3306?
        at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
        at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
        at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown
Source)
        at org.gjt.mm.mysql.Driver.connect(Unknown Source)
        at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverC
onnectionFactory.
java:37)
        at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableCon
nectionFactory.ja
va:290)
        at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicD
ataSource.java:87
7)
        at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource
.java:851)
        ... 28 more

I am quite sure the database server is working fine since other my
Tomcat is able to connect with the same URL.

2) No matter what driver you specify, it used the default MySQL driver
that ships with JAMES. Is using the default MySQL driver necessary?

Waiting for answers.

Thanks a lot.
Santosh.


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