Hi Supun, On Tue, Nov 30, 2010 at 5:42 PM, Supun Kamburugamuva <[email protected]> wrote:
> It seems database is not created. Can you start with -Dsetup and see? As I am trying to deploy ESB in tomcat, this option is not valid (because I am starting the tomcat server). But thanks for your lead. I created a mysql database and ran the dbscripts and was able to deploy ESB successfully. During the process, I had to copy mysql-connector jar to repository/components/lib folder. I also had to change the database urls in registry.xml and user-mgt.xml accordingly. Thanks, AmilaM. > > Thanks, > Supun.. > > On Tue, Nov 30, 2010 at 5:19 PM, Amila Maha Arachchi <[email protected]>wrote: > >> Hi all, >> >> I tried to deploy ESB 3.0.0 in Tomcat 6.0.24 by following the article [1] >> written by Charitha. After following the instructions, when I try to start >> the tomcat server, I get the following error in the console. Can somebody >> point me where I have done wrong? >> >> I have provided the database url in registry.xml as follows. >> >> <dbConfig name="wso2registry"> >> >> *<url>jdbc:h2:/media/dev/esb/esp-repo/repository/database/WSO2CARBON_DB</url> >> * >> <userName>wso2carbon</userName> >> <password>wso2carbon</password> >> <driverName>org.h2.Driver</driverName> >> <maxActive>50</maxActive> >> <maxWait>60000</maxWait> >> <minIdle>5</minIdle> >> </dbConfig> >> >> >> Thanks, >> AmilaM. >> >> [1] >> http://wso2.org/library/knowledge-base/2010/10/deploy-wso2-esb3x-apache-tomcat >> >> INFO: Deploying web application directory esb >> [2010-11-30 16:52:08,633] INFO - CarbonCoreActivator Starting WSO2 >> Carbon... >> [2010-11-30 16:52:08,635] INFO - CarbonCoreActivator Operating System : >> Linux 2.6.32-24-generic, amd64 >> [2010-11-30 16:52:08,635] INFO - CarbonCoreActivator Java Home : >> /media/dev/software/jdk1.6.0_21/jre >> [2010-11-30 16:52:08,635] INFO - CarbonCoreActivator Java Version : >> 1.6.0_21 >> [2010-11-30 16:52:08,635] INFO - CarbonCoreActivator Java VM : >> Java HotSpot(TM) 64-Bit Server VM 17.0-b16,Sun Microsystems Inc. >> [2010-11-30 16:52:08,635] INFO - CarbonCoreActivator Carbon Home : >> /media/dev/esb/esb-repo/ >> [2010-11-30 16:52:08,636] INFO - CarbonCoreActivator Java Temp Dir : >> /media/dev/software/apache-tomcat-6.0.24/temp >> [2010-11-30 16:52:08,636] INFO - CarbonCoreActivator User : >> amila, en-US, Asia/Colombo >> [2010-11-30 16:52:09,000] INFO - RuleServerManagerComponent There is no >> rule-server.xml... Using the default configuration >> [2010-11-30 16:52:09,072] INFO - RuleServerConfigurationFactory A Rule >> provider has not been specified. Using default one : >> org.wso2.carbon.rule.engine.jsr94.JSR94BackendRuntimeFactory >> *[2010-11-30 16:52:09,901] ERROR - ResourceDAO Failed to retrieving >> resource from /. Table REG_PATH not found; SQL statement: >> SELECT REG_PATH_ID FROM REG_PATH WHERE REG_PATH_VALUE=? AND >> REG_TENANT_ID=? [42102-112] >> org.h2.jdbc.JdbcSQLException: Table REG_PATH not found; SQL statement: >> SELECT REG_PATH_ID FROM REG_PATH WHERE REG_PATH_VALUE=? AND >> REG_TENANT_ID=? [42102-112] >> at org.h2.message.Message.getSQLException(Message.java:107)* >> at org.h2.message.Message.getSQLException(Message.java:118) >> at org.h2.message.Message.getSQLException(Message.java:77) >> at org.h2.command.Parser.readTableOrView(Parser.java:4259) >> at org.h2.command.Parser.readTableFilter(Parser.java:972) >> at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1503) >> at org.h2.command.Parser.parseSelectSimple(Parser.java:1600) >> at org.h2.command.Parser.parseSelectSub(Parser.java:1497) >> at org.h2.command.Parser.parseSelectUnion(Parser.java:1342) >> at org.h2.command.Parser.parseSelect(Parser.java:1330) >> at org.h2.command.Parser.parsePrepared(Parser.java:392) >> at org.h2.command.Parser.parse(Parser.java:288) >> at org.h2.command.Parser.parse(Parser.java:260) >> at org.h2.command.Parser.prepareCommand(Parser.java:232) >> at org.h2.engine.Session.prepareLocal(Session.java:410) >> at org.h2.engine.Session.prepareCommand(Session.java:371) >> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1045) >> at >> org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74) >> at >> org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:227) >> at >> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248) >> at >> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302) >> at >> org.wso2.carbon.registry.core.jdbc.utils.Transaction$ManagedRegistryConnection.prepareStatement(Transaction.java:656) >> at >> org.wso2.carbon.registry.core.jdbc.dao.PathCache.getPathID(PathCache.java:233) >> at >> org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.getResourceID(ResourceDAO.java:63) >> at >> org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.resourceExists(ResourceDAO.java:178) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:301) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:240) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:187) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:396) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getSystemRegistry(EmbeddedRegistryService.java:261) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getSystemRegistry(EmbeddedRegistryService.java:245) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getSystemRegistry(EmbeddedRegistryService.java:231) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.configure(EmbeddedRegistryService.java:190) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.<init>(EmbeddedRegistryService.java:96) >> at >> org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.getEmbeddedRegistryService(RegistryCoreServiceComponent.java:423) >> at >> org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.buildRegistryService(RegistryCoreServiceComponent.java:366) >> at >> org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.activate(RegistryCoreServiceComponent.java:92) >> 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:597) >> at >> org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:230) >> at >> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:140) >> at >> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:330) >> at >> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:560) >> at >> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:182) >> at >> org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:292) >> at >> org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:226) >> at >> org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:124) >> at >> org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:930) >> at >> org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:220) >> at >> org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:149) >> at >> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:757) >> at >> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:712) >> at >> org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:129) >> at >> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:206) >> at >> org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:506) >> at >> org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:524) >> at >> org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:29) >> at >> org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:50) >> at >> org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:782) >> at java.security.AccessController.doPrivileged(Native Method) >> at >> org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:773) >> at >> org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:754) >> at >> org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:352) >> at >> org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:370) >> at >> org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1068) >> at >> org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:557) >> at >> org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:464) >> at >> org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:248) >> at >> org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:445) >> at >> org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:220) >> at >> org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:330) >> >> >> _______________________________________________ >> Carbon-dev mailing list >> [email protected] >> https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> >> > > > -- > Supun Kamburugamuva > Technical Lead > WSO2 Inc.; http://wso2.org > E-mail: [email protected]; Mobile: +94 77 431 3585 > Blog: http://supunk.blogspot.com > > _______________________________________________ > Carbon-dev mailing list > [email protected] > https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev > >
_______________________________________________ Carbon-dev mailing list [email protected] https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev
