Thanks Santosh, It worked.
Thanks again Rag Setty On Fri, 2006-08-25 at 18:51 +0530, Santosh Puranshettiwar wrote: > Replace *org.gjt.mm.mysql.Driver* with com.mysql.jdbc.Driver or Connector/J. > > > Raghavendra Setty wrote: > > Hi all, > > > > I am working on JAMES version 2.2.0. Till now i was using file as > > Storage type (which is default). Now i am trying to use MySQL as the > > storage repository. > > Below is the environment on which i am working: > > > > OS: Linux Ubuntu 6.0 > > JAMES: 2.2.0 > > MySQL: 4.1 > > Java 5 > > > > Have created a DB with name "ofbiz" with user "ragha" and password > > "ragha" > > > > Below is the snippet of the config.xml file: > > > > <database-connections> > > <data-sources> > > <data-source name="maildb" > > class="org.apache.james.util.dbcp.JdbcDataSource"> > > <driver>org.gjt.mm.mysql.Driver</driver> > > <dburl>jdbc:mysql://localhost/ofbiz</dburl> > > <user>ragha</user> > > <password>ragha</password> > > <max>40</max> > > </data-source> > > </data-sources> > > </database-connections> > > > > For dburl, i have tried with localhost, 127.0.01 and my machine IP. > > Error is same for all the three. > > > > Note: MySQL server is up! > > > > I am getting an exception, and the stack is as below: > > > > org.apache.excalibur.containerkit.lifecycle.LifecycleException: > > Component named "database-connections" failed to pass through the > > Initialization stage. (Reason: > > org.apache.avalon.framework.configuration.ConfigurationException: Error > > configurable datasource). > > at > > org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.fail(LifecycleHelper.java:289) > > at > > org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:159) > > at > > org.apache.avalon.phoenix.components.application.DefaultApplication.startup(DefaultApplication.java:480) > > at > > org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPhase(DefaultApplication.java:428) > > at > > org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase(DefaultApplication.java:364) > > at > > org.apache.avalon.phoenix.components.application.DefaultApplication.start(DefaultApplication.java:138) > > at > > org.apache.avalon.framework.container.ContainerUtil.start(ContainerUtil.java:251) > > at > > org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(DefaultKernel.java:178) > > at > > org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplication(DefaultKernel.java:254) > > at > > org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(DefaultDeployer.java:353) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:498) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:491) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFiles(DefaultEmbeddor.java:476) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDefaultApplications(DefaultEmbeddor.java:466) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.execute(DefaultEmbeddor.java:224) > > at > > org.apache.avalon.phoenix.frontends.CLIMain.run(CLIMain.java:158) > > at > > org.apache.avalon.phoenix.frontends.CLIMain.execute(CLIMain.java:144) > > at > > org.apache.avalon.phoenix.frontends.CLIMain.main(CLIMain.java:102) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:585) > > at org.apache.avalon.phoenix.launcher.Main.startup(Main.java:94) > > at org.apache.avalon.phoenix.launcher.Main.main(Main.java:46) > > Caused by: > > org.apache.avalon.framework.configuration.ConfigurationException: Error > > configurable datasource > > at > > org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:198) > > at > > org.apache.avalon.cornerstone.blocks.datasource.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:104) > > at > > org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:235) > > at > > org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:144) > > ... 22 more > > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > > PoolableConnectionFactory (Cannot connect to MySQL server on > > localhost:3306. Is there a MySQL server running on the machine/port you > > are trying to connect to? (java.lang.NumberFormatException)) > > at > > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) > > at org.apache.james.util.dbcp.JdbcDataSource > > $1.createDataSource(JdbcDataSource.java:120) > > at > > org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598) > > at > > org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:155) > > ... 25 more > > Caused by: java.sql.SQLException: Cannot connect to MySQL server on > > localhost:3306. Is there a MySQL server running on the machine/port you > > are trying to connect to? (java.lang.NumberFormatException) > > 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(DriverConnectionFactory.java:37) > > at > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) > > at > > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) > > at > > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) > > ... 28 more > > There was an uncaught exception: > > --------------------------------------------------------- > > --- Message --- > > Failed to start application james. > > --- Stack Trace --- > > org.apache.avalon.phoenix.interfaces.DeploymentException: Failed to > > start application james. > > at > > org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(DefaultDeployer.java:379) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:498) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:491) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFiles(DefaultEmbeddor.java:476) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDefaultApplications(DefaultEmbeddor.java:466) > > at > > org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.execute(DefaultEmbeddor.java:224) > > at > > org.apache.avalon.phoenix.frontends.CLIMain.run(CLIMain.java:158) > > at > > org.apache.avalon.phoenix.frontends.CLIMain.execute(CLIMain.java:144) > > at > > org.apache.avalon.phoenix.frontends.CLIMain.main(CLIMain.java:102) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:585) > > at org.apache.avalon.phoenix.launcher.Main.startup(Main.java:94) > > at org.apache.avalon.phoenix.launcher.Main.main(Main.java:46) > > Caused by: org.apache.avalon.framework.CascadingException: Failed to > > start application james. > > at > > org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(DefaultKernel.java:195) > > at > > org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplication(DefaultKernel.java:254) > > at > > org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(DefaultDeployer.java:353) > > ... 14 more > > Caused by: org.apache.avalon.phoenix.interfaces.ApplicationException: > > Component named "database-connections" failed to pass through the > > Initialization stage. (Reason: > > org.apache.avalon.framework.configuration.ConfigurationException: Error > > configurable datasource). > > at > > org.apache.avalon.phoenix.components.application.DefaultApplication.start(DefaultApplication.java:144) > > at > > org.apache.avalon.framework.container.ContainerUtil.start(ContainerUtil.java:251) > > at > > org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(DefaultKernel.java:178) > > ... 16 more > > Caused by: > > org.apache.excalibur.containerkit.lifecycle.LifecycleException: > > Component named "database-connections" failed to pass through the > > Initialization stage. (Reason: > > org.apache.avalon.framework.configuration.ConfigurationException: Error > > configurable datasource). > > at > > org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.fail(LifecycleHelper.java:289) > > at > > org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:159) > > at > > org.apache.avalon.phoenix.components.application.DefaultApplication.startup(DefaultApplication.java:480) > > at > > org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPhase(DefaultApplication.java:428) > > at > > org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase(DefaultApplication.java:364) > > at > > org.apache.avalon.phoenix.components.application.DefaultApplication.start(DefaultApplication.java:138) > > ... 18 more > > Caused by: > > org.apache.avalon.framework.configuration.ConfigurationException: Error > > configurable datasource > > at > > org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:198) > > at > > org.apache.avalon.cornerstone.blocks.datasource.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:104) > > at > > org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:235) > > at > > org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:144) > > ... 22 more > > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > > PoolableConnectionFactory (Cannot connect to MySQL server on > > localhost:3306. Is there a MySQL server running on the machine/port you > > are trying to connect to? (java.lang.NumberFormatException)) > > at > > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) > > at org.apache.james.util.dbcp.JdbcDataSource > > $1.createDataSource(JdbcDataSource.java:120) > > at > > org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598) > > at > > org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:155) > > ... 25 more > > Caused by: java.sql.SQLException: Cannot connect to MySQL server on > > localhost:3306. Is there a MySQL server running on the machine/port you > > are trying to connect to? (java.lang.NumberFormatException) > > 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(DriverConnectionFactory.java:37) > > at > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) > > at > > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) > > at > > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) > > ... 28 more > > > > Please do the needful. > > Thanks in advance, > > Rag Setty > > > > This e-mail and any files transmitted with it are for the sole use of the > > intended recipient(s) and may contain confidential and privileged > > information. If you are not the intended recipient or received it in error, > > please contact the sender by reply e-mail and destroy all copies of the > > original message. Please do not copy it for any purpose or disclose its > > contents. > > > > Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Rag Setty This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient or received it in error, please contact the sender by reply e-mail and destroy all copies of the original message. Please do not copy it for any purpose or disclose its contents. Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved
