I'm getting database connection error whenever I try to connect james to sql server 2005, I already loaded driver sqljdbc in the lib directory in james, then why I'm getting an error? Here's the config.xml file of james which is trying to connect to sql server:
<data-source name="maildb" class="org.apache.james.util.dbcp.JdbcDataSource">
<driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
<dburl>jdbc:microsoft:sqlserver://127.0.0.1:1433?database=mail</dburl>
<user>sa</user>
<password>[removed]</password>
<max>20</max>
</data-source>
The errors which I'm getting are:
INFO 2009-10-04 01:09:31.562 [Phoenix ] (): Logger started
WARN 2009-10-04 01:09:31.578 [Phoenix ] (): Phoenix was not started by the daemon thus it will not be possible to restart the JVM via the Management interface.
INFO 2009-10-04 01:09:31.703 [Phoenix.] (): Installing Sar located at file:/C:/james-2.3.2/apps/james.sar.
WARN 2009-10-04 01:09:31.843 [Phoenix.] (): The file conf/sqlResources.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\sqlResources.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.843 [Phoenix.] (): The file conf/james-fetchmail.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\james-fetchmail.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.843 [Phoenix.] (): The file conf/james-smtphandlerchain.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\james-smtphandlerchain.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.843 [Phoenix.] (): The file conf/miResources.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\miResources.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.843 [Phoenix.] (): The file conf/james-listmanager.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\james-listmanager.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.843 [Phoenix.] (): The file conf/james-liststores.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\james-liststores.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.859 [Phoenix.] (): The file conf/samples/fetchmail/maxMessageSize.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\samples\fetchmail\maxMessageSize.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.859 [Phoenix.] (): The file conf/samples/fetchmail/oneAccountManyUsers.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\samples\fetchmail\oneAccountManyUsers.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.859 [Phoenix.] (): The file conf/samples/fetchmail/oneAccountManyUsersDynamic.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\samples\fetchmail\oneAccountManyUsersDynamic.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.859 [Phoenix.] (): The file conf/samples/fetchmail/oneAccountPerUser.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\samples\fetchmail\oneAccountPerUser.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.859 [Phoenix.] (): The file conf/samples/fetchmail/oneAccountPerUserDynamic.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\samples\fetchmail\oneAccountPerUserDynamic.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.859 [Phoenix.] (): The file conf/samples/fetchmail/remoteReceivedHeader.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\conf\samples\fetchmail\remoteReceivedHeader.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.859 [Phoenix.] (): The file SAR-INF/config.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\SAR-INF\config.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.859 [Phoenix.] (): The file SAR-INF/assembly.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\SAR-INF\assembly.xml because there is a file in the way.
WARN 2009-10-04 01:09:31.859 [Phoenix.] (): The file SAR-INF/environment.xml can not be extracted from the Sar "file:/C:/james-2.3.2/apps/james.sar" into directory C:\james-2.3.2\apps\james\SAR-INF\environment.xml because there is a file in the way.
INFO 2009-10-04 01:09:32.109 [Phoenix.] (): Verifying that all key-stores have valid names.
INFO 2009-10-04 01:09:32.109 [Phoenix.] (): Verify that any keystore names used by grant or permission reference actual keystores
INFO 2009-10-04 01:09:32.109 [Phoenix.] (): Verify that if target is null then actions is null.
INFO 2009-10-04 01:09:32.296 [Phoenix.] (): Verifying that the name specified for Blocks and BlockListeners are valid.
INFO 2009-10-04 01:09:32.296 [Phoenix.] (): Verifying that the names specified for Component are valid.
INFO 2009-10-04 01:09:32.296 [Phoenix.] (): Verifying that the names specified for the Components are unique.
INFO 2009-10-04 01:09:32.296 [Phoenix.] (): Verifying that the dependency mapping is valid according to ComponentInfos.
INFO 2009-10-04 01:09:32.296 [Phoenix.] (): Verifying that the dependency mapping for every Component is valid with respect to other components.
INFO 2009-10-04 01:09:32.296 [Phoenix.] (): Verifying that there are no circular dependencies between Components.
INFO 2009-10-04 01:09:32.296 [Phoenix.] (): Verifying that the name specified for Blocks and BlockListeners are unique.
INFO 2009-10-04 01:09:32.312 [Phoenix.] (): Verifying that the specified Blocks have valid types.
INFO 2009-10-04 01:09:32.343 [Phoenix.] (): Verifying that the specified BlockListeners have valid types.
INFO 2009-10-04 01:09:32.421 [Phoenix.] (): 20 Blocks to process for phase "startup". Order of processing = [dnsserver, database-connections, mailstore, users-store, localusersrepository, spoolrepository, sockets, thread-manager, scheduler, James, mailetpackages, matcherpackages, spoolmanager, connections, remotemanager, pop3server, smtpserver, nntp-repository, nntpserver, fetchmail].
ERROR 2009-10-04 01:09:32.921 [Phoenix.] (): Component named "database-connections" failed to pass through the Starting stage. (Reason: org.apache.avalon.framework.configuration.ConfigurationException: Error configurable datasource).
ERROR 2009-10-04 01:09:32.921 [Phoenix.] (): There was an error running phase "startup" for Block named "database-connections". (Reason: Component named "database-connections" failed to pass through the Starting stage. (Reason: org.apache.avalon.framework.configuration.ConfigurationException: Error configurable datasource).).
org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleException: Component named "database-connections" failed to pass through the Starting stage. (Reason: org.apache.avalon.framework.configuration.ConfigurationException: Error configurable datasource).
at org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleHelper.fail(LifecycleHelper.java:354)
at org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:226)
at org.apache.avalon.phoenix.components.application.DefaultApplication.startup(DefaultApplication.java:530)
at org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPhase(DefaultApplication.java:478)
at org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase(DefaultApplication.java:409)
at org.apache.avalon.phoenix.components.application.DefaultApplication.start(DefaultApplication.java:180)
at org.apache.avalon.framework.container.ContainerUtil.start(ContainerUtil.java:260)
rethrown from
org.apache.avalon.framework.configuration.ConfigurationException: Error configurable datasource
at org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:200)
at org.apache.avalon.cornerstone.blocks.datasources.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:147)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
at org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:200)
at org.apache.avalon.phoenix.components.application.DefaultApplication.startup(DefaultApplication.java:530)
at org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPhase(DefaultApplication.java:478)
at org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase(DefaultApplication.java:409)
rethrown from
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:microsoft:sqlserver://127.0.0.1:1433?database=mail'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.james.util.dbcp.JdbcDataSource$1.createDataSource(JdbcDataSource.java:113)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598)
at org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:157)
at org.apache.avalon.cornerstone.blocks.datasources.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:147)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
at org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:200)
rethrown from
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
at org.apache.james.util.dbcp.JdbcDataSource$1.createDataSource(JdbcDataSource.java:113)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598)
at org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:157)
at org.apache.avalon.cornerstone.blocks.datasources.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:147)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
INFO 2009-10-04 01:09:32.921 [Phoenix.] (): exception while starting:Component named "database-connections" failed to pass through the Starting stage. (Reason: org.apache.avalon.framework.configuration.ConfigurationException: Error configurable datasource).
WARN 2009-10-04 01:09:32.968 [Phoenix.] (): Failed to start application james.
org.apache.avalon.framework.CascadingException: Failed to start application james.
at org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(DefaultKernel.java:313)
at org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplication(DefaultKernel.java:376)
at org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(DefaultDeployer.java:357)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:542)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:535)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFiles(DefaultEmbeddor.java:520)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDefaultApplications(DefaultEmbeddor.java:509)
rethrown from
org.apache.avalon.phoenix.interfaces.ApplicationException: Component named "database-connections" failed to pass through the Starting stage. (Reason: org.apache.avalon.framework.configuration.ConfigurationException: Error configurable datasource).
at org.apache.avalon.phoenix.components.application.DefaultApplication.start(DefaultApplication.java:186)
at org.apache.avalon.framework.container.ContainerUtil.start(ContainerUtil.java:260)
at org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(DefaultKernel.java:295)
at org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplication(DefaultKernel.java:376)
at org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(DefaultDeployer.java:357)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:542)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:535)
rethrown from
org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleException: Component named "database-connections" failed to pass through the Starting stage. (Reason: org.apache.avalon.framework.configuration.ConfigurationException: Error configurable datasource).
at org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleHelper.fail(LifecycleHelper.java:354)
at org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:226)
at org.apache.avalon.phoenix.components.application.DefaultApplication.startup(DefaultApplication.java:530)
at org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPhase(DefaultApplication.java:478)
at org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase(DefaultApplication.java:409)
at org.apache.avalon.phoenix.components.application.DefaultApplication.start(DefaultApplication.java:180)
at org.apache.avalon.framework.container.ContainerUtil.start(ContainerUtil.java:260)
rethrown from
org.apache.avalon.framework.configuration.ConfigurationException: Error configurable datasource
at org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:200)
at org.apache.avalon.cornerstone.blocks.datasources.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:147)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
at org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:200)
at org.apache.avalon.phoenix.components.application.DefaultApplication.startup(DefaultApplication.java:530)
at org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPhase(DefaultApplication.java:478)
at org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase(DefaultApplication.java:409)
rethrown from
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:microsoft:sqlserver://127.0.0.1:1433?database=mail'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.james.util.dbcp.JdbcDataSource$1.createDataSource(JdbcDataSource.java:113)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598)
at org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:157)
at org.apache.avalon.cornerstone.blocks.datasources.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:147)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
at org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:200)
rethrown from
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
at org.apache.james.util.dbcp.JdbcDataSource$1.createDataSource(JdbcDataSource.java:113)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598)
at org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:157)
at org.apache.avalon.cornerstone.blocks.datasources.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:147)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
WARN 2009-10-04 01:09:33.000 [Phoenix.] (): Error deleting Work Directory "C:\james-2.3.2\work\james-1254598771703". (Reason: File C:\james-2.3.2\work\james-1254598771703\SAR-INF\lib\mailet-api-2.3.jar unable to be deleted.)
java.io.IOException: File C:\james-2.3.2\work\james-1254598771703\SAR-INF\lib\mailet-api-2.3.jar unable to be deleted.
at org.apache.avalon.excalibur.io.FileUtil.forceDelete(FileUtil.java:743)
at org.apache.avalon.excalibur.io.FileUtil.cleanDirectory(FileUtil.java:910)
at org.apache.avalon.excalibur.io.FileUtil.deleteDirectory(FileUtil.java:866)
at org.apache.avalon.excalibur.io.FileUtil.forceDelete(FileUtil.java:735)
at org.apache.avalon.excalibur.io.FileUtil.cleanDirectory(FileUtil.java:910)
at org.apache.avalon.excalibur.io.FileUtil.deleteDirectory(FileUtil.java:866)
at org.apache.avalon.excalibur.io.FileUtil.forceDelete(FileUtil.java:735)
WARN 2009-10-04 01:09:33.312 [Phoenix.] (): Failed to stop application james as it is not initialized/started.