Hi Users,
My webMethod Server not getting start …
[POP.004.0202] Cannot create database connection to default MWS datasource. Please verify database connection parameters in the MWS/server/default/config/mws.db.xml configuration file
I have check the logs:
java.sql.SQLException: [wm-cjdbc36-0039][Oracle JDBC Driver]Error establishing socket to host and port: localhost:1521. Reason: Connection refused: connect
at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplConnection.makeConnectionHelper(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplConnection.makeConnection(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplConnection.open(Unknown Source)
at com.wm.dd.jdbc.base.BaseConnection.connect(Unknown Source)
at com.wm.dd.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at com.wm.dd.jdbc.base.BaseConnection.open(Unknown Source)
at com.wm.dd.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.webMethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:102)
at com.webMethods.portal.system.pool.impl.LightweightObjectPool.checkOut(LightweightObjectPool.java:235)
at com.webMethods.portal.service.sql.core.provider.pool.PooledConnectionProvider.getConnection(PooledConnectionProvider.java:168)
at com.webMethods.portal.service.sql.core.BaseSqlWorker.init(BaseSqlWorker.java:106)
at com.webMethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:647)
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:272)
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:195)
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initializeDatabaseConfigLocator(ClusterPhaseProvider.java:36)
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initializePhases(ClusterPhaseProvider.java:25)
at com.webMethods.portal.system.PortalSystem.init(PortalSystem.java:868)
at com.webMethods.portal.system.PortalSystem.main(PortalSystem.java:827)
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 com.webMethods.portal.system.start.Main.start(Main.java:131)
at com.webMethods.portal.system.start.Main.main(Main.java:48)
com.webMethods.portal.system.init.InitializationException: [POP.004.0202] Cannot create database connection to default MWS datasource. Please verify database connection parameters in the MWS/server/default/config/mws.db.xml configuration file
at com.webMethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:670)
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:272)
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:195)
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initializeDatabaseConfigLocator(ClusterPhaseProvider.java:36)
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initializePhases(ClusterPhaseProvider.java:25)
at com.webMethods.portal.system.PortalSystem.init(PortalSystem.java:868)
at com.webMethods.portal.system.PortalSystem.main(PortalSystem.java:827)
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 com.webMethods.portal.system.start.Main.start(Main.java:131)
at com.webMethods.portal.system.start.Main.main(Main.java:48)
com.webMethods.portal.system.init.InitializationException: [POP.004.0202] Cannot create database connection to default MWS datasource. Please verify database connection parameters in the MWS/server/default/config/mws.db.xml configuration file
at com.webMethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:670)
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:272)
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:195)
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initializeDatabaseConfigLocator(ClusterPhaseProvider.java:36)
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initializePhases(ClusterPhaseProvider.java:25)
at com.webMethods.portal.system.PortalSystem.init(PortalSystem.java:868)
at com.webMethods.portal.system.PortalSystem.main(PortalSystem.java:827)
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 com.webMethods.portal.system.start.Main.start(Main.java:131)
at com.webMethods.portal.system.start.Main.main(Main.java:48)
My MWS.db file:
<?xml version="1.0" encoding="UTF-8"?> com.webmethods.portal.service.sql.core.BaseSqlWorker com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider com.wm.dd.jdbc.oracle.OracleDriver jdbc:wm:oracle://localhost:1521;serviceName=XE SYSTEM {DES}uU63Va4PgEA= 100 false SELECT COUNT(*) FROM TBLTHING WHERE IDTHING = 1 2 300any help…
