Configure WSO2BPS to use SQL Server

vamshi179's picture
Hi, I am trying to configure wso2BPS to use external db sql server. In line with this I created following two files File 1: [wsobpsroot]/conf/ datasources.properties synapse.datasources=bpsds synapse.datasources.icFactory=com.sun.jndi.rmi.registry.RegistryContextFactory synapse.datasources.providerPort=2120 synapse.datasources.bpsds.registry=JNDI synapse.datasources.bpsds.type=BasicDataSource synapse.datasources.bpsds.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver synapse.datasources.bpsds.url=jdbc:sqlserver://192.168.101.21:1433;databaseName=bps synapse.datasources.bpsds.username=sa synapse.datasources.bpsds.password=P@ssword01 synapse.datasources.bpsds.dsName=bpsds synapse.datasources.bpsds.maxActive=100 synapse.datasources.bpsds.maxIdle=20 synapse.datasources.bpsds.maxWait=10000 File 2: [wsobpsroot]/repository/conf/ ode-axis2.properties # Hibernate Configuration hibernate.dialect=org.hibernate.dialect.SQLServerDialect hibernate.hbm2ddl.auto = update hibernate.current_session_context_class=jta hibernate.transaction.manager_lookup_class=org.apache.ode.daohib.HibernateTransactionManagerLookup # ODE Configuration # Database mode11 property specify whther to use embedded db or external. ode-axis2.db.mode=external ode-axis2.db.ext.dataSource=bpsds ode-axis2.jndi.context.factory=com.sun.jndi.rmi.registry.RegistryContextFactory ode-axis2.jndi.provider.url=rmi://localhost:2120 Later I am receiving "NoInitialContextException: cannot instantiate class"..... how do I resolve this error message? [2009-12-09 15:27:40,961] INFO - Deploying module: addressing-1.41 - file:/C:/PROGRA~1/CA/Catalyst /bps_1.0/wso2bps/bin/../repository/modules/addressing-1.41.mar {org.apache.axis2.deployment.ModuleDe ployer} [2009-12-09 15:27:41,117] INFO - Using embedded Geronimo transaction manager {org.apache.ode.il.Em beddedGeronimoFactory} [2009-12-09 15:27:41,133] ERROR - Failed to resolved external DataSource at "bpsds0". {org.apache.o de.il.dbutil.Database} javax.naming.NoInitialContextException: Cannot instantiate class: com.sun.jndi.rmi.registry.Registry ContextFactory [Root exception is java.lang.ClassNotFoundException: com.sun.jndi.rmi.registry.Regis tryContextFactory ] at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:657) at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:247) at javax.naming.InitialContext.init(InitialContext.java:223) at javax.naming.InitialContext.(InitialContext.java:197) at org.apache.ode.il.dbutil.Database.lookupInJndi(Database.java:253) at org.apache.ode.il.dbutil.Database.initExternalDb(Database.java:160) at org.apache.ode.il.dbutil.Database.initDataSource(Database.java:145) at org.apache.ode.il.dbutil.Database.start(Database.java:100) at org.wso2.carbon.bpel.CarbonODEServer.initDataSource(CarbonODEServer.java:264) at org.wso2.carbon.bpel.CarbonODEServer.init(CarbonODEServer.java:179) at org.wso2.carbon.bpel.BPELDeployer.init(BPELDeployer.java:72) at org.apache.axis2.deployment.DeploymentEngine.initializeDeployers(DeploymentEngine.java:92 7) at org.apache.axis2.deployment.DeploymentEngine.setConfigContext(DeploymentEngine.java:919) at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(Configura tionContextFactory.java:90) at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(Carb onConfigurationContextFactory.java:79) at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130) at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254) at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.ja va:64) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java: 142) at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl .java:50) at org.wso2.carbon.core.internal.Activator.start(Activator.java:58) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:9 99) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextIm pl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:9 74) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManage r.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java :508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelMana ger.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManage r.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) Caused by: java.lang.ClassNotFoundException: com.sun.jndi.rmi.registry.RegistryContextFactory at java.lang.ClassLoader.findClass(ClassLoader.java:358) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java :429) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:369) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:357) at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.jav a:83) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:242) at com.sun.naming.internal.VersionHelper12.loadClass(VersionHelper12.java:42) at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:654) ... 34 more [2009-12-09 15:27:41,149] ERROR - Error starting database connections, check the database configura tion! {org.wso2.carbon.bpel.CarbonODEServer} org.apache.ode.il.dbutil.DatabaseConfigException: Failed to resolved external DataSource at "bpsds0" . at org.apache.ode.il.dbutil.Database.initExternalDb(Database.java:165) at org.apache.ode.il.dbutil.Database.initDataSource(Database.java:145) at org.apache.ode.il.dbutil.Database.start(Database.java:100) at org.wso2.carbon.bpel.CarbonODEServer.initDataSource(CarbonODEServer.java:264) at org.wso2.carbon.bpel.CarbonODEServer.init(CarbonODEServer.java:179) at org.wso2.carbon.bpel.BPELDeployer.init(BPELDeployer.java:72) at org.apache.axis2.deployment.DeploymentEngine.initializeDeployers(DeploymentEngine.java:92 7) at org.apache.axis2.deployment.DeploymentEngine.setConfigContext(DeploymentEngine.java:919) at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(Configura tionContextFactory.java:90) at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(Carb onConfigurationContextFactory.java:79) at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130) at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254) at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.ja va:64) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java: 142) at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl .java:50) at org.wso2.carbon.core.internal.Activator.start(Activator.java:58) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:9 99) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextIm pl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:9 74) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManage r.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java :508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelMana ger.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManage r.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) Caused by: javax.naming.NoInitialContextException: Cannot instantiate class: com.sun.jndi.rmi.regist ry.RegistryContextFactory [Root exception is java.lang.ClassNotFoundException: com.sun.jndi.rmi.reg istry.RegistryContextFactory ] at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:657) at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:247) at javax.naming.InitialContext.init(InitialContext.java:223) at javax.naming.InitialContext.(InitialContext.java:197) at org.apache.ode.il.dbutil.Database.lookupInJndi(Database.java:253) at org.apache.ode.il.dbutil.Database.initExternalDb(Database.java:160) ... 29 more Caused by: java.lang.ClassNotFoundException: com.sun.jndi.rmi.registry.RegistryContextFactory at java.lang.ClassLoader.findClass(ClassLoader.java:358) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java :429) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:369) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:357) at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.jav a:83) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:242) at com.sun.naming.internal.VersionHelper12.loadClass(VersionHelper12.java:42) at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:654) ... 34 more [2009-12-09 15:27:41,164] ERROR - Error starting database connections, check the database configura tion! {org.wso2.carbon.bpel.BPELDeployer} [2009-12-09 15:27:44,475] INFO - Repository : C:\PROGRA~1\CA\Catalyst\bps_1.0\wso2bps\ bin\../repository/ {org.wso2.carbon.core.DefaultServerInitializer} [2009-12-09 15:27:44,522] INFO - No services directory was found under C:\Program Files\CA\Catalys t\bps_1.0\wso2bps\resources\clientRepository. {org.apache.axis2.deployment.DeploymentEngine} [2009-12-09 15:27:44,538] INFO - Deploying module: rampart-1.41 - file:/C:/PROGRA~1/CA/Catalyst/bp s_1.0/wso2bps/bin/../resources/clientRepository/modules/rampart-1.41.mar {org.apache.axis2.deploymen t.ModuleDeployer} Dec 9, 2009 3:27:45 PM org.apache.catalina.connector.Connector start INFO: The connector has already been started Dec 9, 2009 3:27:45 PM org.apache.catalina.connector.Connector start INFO: The connector has already been started [2009-12-09 15:27:45,256] INFO - HTTPS port : 6443 {org.wso2.carbon.core.StartupServle t} [2009-12-09 15:27:45,256] INFO - HTTP port : 6060 {org.wso2.carbon.core.StartupServle t} [2009-12-09 15:27:45,272] INFO - WSO2 Carbon started in 20 sec {org.wso2.carbon.core.StartupServle t} Regards, -Vamshi
waruna's picture

Hi, Make sure that there are

Hi, Make sure that there are no space characters after ode-axis2.jndi.context.factory class. It does not trim the property value when reading them. Therefore, spaces after the class value will generate above error message. Thanks, Waruna
library project main code
Learn Cloud
Learn
Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar
Different groups within an organization need to monitor different Key Performance Indicators (KPIs) - An operations team will be interested in the response times of business services and loads of each service,..
Thursday, February 9th 2012, 09.00 AM (PST)

Thursday, February 9th 2012, 10.00 AM (GMT)