6 Replies Latest reply: May 19, 2013 9:45 AM by hitgon RSS

    Application is not able to connect using Oracle SCAN String

    hitgon
      Dear Oracle Gurus

      We have 11g r2 11.2.0.3.0 2 node cluster

      We have configured the scan using single scan-vip using /etc/hosts file resolution

      Our Application working fine using the Local Vip dual string(10g Method)

      Scan is working fine in database server when we check using sqlplus

      Oracle SCAN is working fine in Database Server

      DB-1 sqlplus testbed/testbed@my-db-scan:1521/orcl

      When we use below JDBC URL in Tomcat Version-6 then it’ not allow to connect although it’s allow to connect sometime but connectivity is not stable when we restart the tomcat

      hibernate.connection.url=jdbc:oracle:thin:@my-db-scan:1521/orcl

      Application is not able to connect using Oracle SCAN String

      [ 13-May-2013 12:48:24 ] [ INFO ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: init() Called.
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: Adding data manager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: **************************************************************
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 1 : com.cmp.mysm.hibernate.core.system.staff.HStaffDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 2 : com.cmp.mysm.hibernate.core.system.systemparameter.HSystemParameterDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 3 : com.cmp.mysm.hibernate.core.system.profilemanagement.HProfileDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 4 : com.cmp.mysm.hibernate.core.system.accessgroup.HAccessGroupDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 5 : com.cmp.mysm.hibernate.systemaudit.HSystemAuditDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 6 : com.cmp.mysm.hibernate.datasource.database.HDatabaseDSDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 7 : com.cmp.mysm.hibernate.datasource.ldap.HLDAPDatasourceDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 8 : com.cmp.mysm.hibernate.sessionmanager.HSessionManagerDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 9 : com.cmp.mysm.hibernate.sessionmanager.HASMDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 10 : com.cmp.mysm.hibernate.digestconf.HDigestConfDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 11 : com.cmp.mysm.hibernate.radius.clientprofile.HClientProfileDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 12 : com.cmp.mysm.hibernate.externalsystem.HExternalSystemInterfaceDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 13 : com.cmp.mysm.hibernate.servermgr.drivers.HDriverDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 14 : com.cmp.mysm.hibernate.servermgr.drivers.subscriberprofile.database.HDatabaseSubscriberProfileDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 15 : com.cmp.mysm.hibernate.servermgr.service.HServiceDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 16 : com.cmp.mysm.hibernate.servicepolicy.auth.HAuthServicePoilcyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 17 : com.cmp.mysm.hibernate.servicepolicy.acct.HAcctServicePoilcyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 18 : com.cmp.mysm.hibernate.servicepolicy.dynauth.HDynAuthServicePoilcyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 19 : com.cmp.mysm.hibernate.servermgr.server.HServerDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 20 : com.cmp.mysm.hibernate.servermgr.service.HServiceDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 21 : com.cmp.mysm.hibernate.servermgr.plugin.HPluginDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 22 : com.cmp.mysm.hibernate.rm.ippool.HIPPoolDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 23 : com.cmp.mysm.hibernate.servermgr.eap.HEAPConfigDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 24 : com.cmp.mysm.hibernate.servermgr.alert.HAlertListenerDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 25 : com.cmp.mysm.hibernate.servermgr.gracepolicy.HGracePolicyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 26 : com.cmp.mysm.hibernate.radius.clientprofile.HClientProfileDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 27 : com.cmp.mysm.hibernate.radius.dictionary.HDictionaryDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 28 : com.cmp.mysm.hibernate.radius.policies.accesspolicy.HAccessPolicyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 29 : com.cmp.mysm.hibernate.radius.policies.radiuspolicy.HRadiusPolicyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 30 : com.cmp.mysm.hibernate.radius.radtest.HRadiusTestDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 31 : com.cmp.mysm.hibernate.radius.bwlist.HBWListBLManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 32 : com.cmp.mysm.hibernate.rm.concurrentloginpolicy.HConcurrentLoginPolicyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 33 : com.cmp.mysm.hibernate.wsconfig.HWebServiceConfigDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 34 : com.cmp.mysm.hibernate.diameter.dictionary.HDictionaryDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 35 : com.cmp.mysm.hibernate.servicepolicy.diameter.naspolicy.HDiameterNASPolicyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 36 : com.cmp.mysm.hibernate.servicepolicy.diameter.creditcontrolpolicy.HCreditControlPolicyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 37 : com.cmp.mysm.hibernate.servicepolicy.diameter.eappolicy.HEAPPolicyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 38 : com.cmp.mysm.hibernate.servermgr.drivers.HDiameterDriverDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 39 : com.cmp.mysm.hibernate.servermgr.transmapconf.HTranslationMappingConfDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 40 : com.cmp.mysm.hibernate.diameter.diameterpolicy.HDiameterPolicyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 41 : com.cmp.mysm.hibernate.servicepolicy.rm.cgpolicy.HCGPolicyDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 42 : com.cmp.mysm.hibernate.reports.userstat.HUserStatisticsDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 43 : com.cmp.mysm.hibernate.diameter.routingconf.HDiameterRoutingConfDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 44 : com.cmp.mysm.hibernate.diameter.diameterpeerprofile.HDiameterPeerProfileDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 45 : com.cmp.mysm.hibernate.diameter.diameterpeer.HDiameterPeerDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 46 : com.cmp.mysm.hibernate.core.base.HGenericDataManager
      [ 13-May-2013 12:48:24 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: **************************************************************
      [ 13-May-2013 12:48:24 ] [ INFO ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: Data manager Successfully initialized.
      [ 13-May-2013 12:48:29 ] [ ERROR ] [0.0.0.0] - unknown [CONFIG MANAGER]: Error during Config Manager operation , reason : Cannot open connection
      [ 13-May-2013 12:48:29 ] [ TRACE ] [0.0.0.0] - unknown [CONFIG MANAGER] com.cmp.mysm.datamanager.DataManagerException: Cannot open connection
      at com.cmp.mysm.hibernate.core.system.systemparameter.HSystemParameterDataManager.getList(HSystemParameterDataManager.java:45)
      at com.cmp.mysm.blmanager.core.system.systemparameter.SystemParameterBLManager.getList(SystemParameterBLManager.java:71)
      at com.cmp.mysm.web.core.system.cache.ConfigManager.init(ConfigManager.java:47)
      at com.cmp.mysm.web.core.system.servlet.myServlet.init(myServlet.java:27)
      at javax.servlet.GenericServlet.init(GenericServlet.java:212)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
      at org.apache.catalina.core.StandardService.start(StandardService.java:525)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
      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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
      Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
      at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
      at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
      at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1596)
      at org.hibernate.loader.Loader.doQuery(Loader.java:717)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
      at org.hibernate.loader.Loader.doList(Loader.java:2294)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172)
      at org.hibernate.loader.Loader.list(Loader.java:2167)
      at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1706)
      at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
      at com.cmp.mysm.hibernate.core.system.systemparameter.HSystemParameterDataManager.getList(HSystemParameterDataManager.java:43)
      ... 21 more
      Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
      at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
      at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527)
      at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
      at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:78)
      at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
      ... 33 more
      Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@47503458 -- timeout at awaitAvailable()
      at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317)
      at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
      at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
      ... 36 more

      May 13, 2013 12:48:29 AM org.apache.catalina.startup.HostConfig deployDescriptor
      INFO: Deploying configuration descriptor host-manager.xml
      May 13, 2013 12:48:29 AM org.apache.catalina.startup.HostConfig deployDescriptor
      INFO: Deploying configuration descriptor manager.xml
      May 13, 2013 12:48:29 AM org.apache.catalina.startup.HostConfig deployDirectory
      INFO: Deploying web application directory docs
      May 13, 2013 12:48:29 AM org.apache.catalina.startup.HostConfig deployDirectory
      INFO: Deploying web application directory examples
      May 13, 2013 12:48:29 AM org.apache.catalina.startup.HostConfig deployDirectory
      INFO: Deploying web application directory ROOT
      May 13, 2013 12:48:29 AM org.apache.coyote.http11.Http11Protocol start
      INFO: Starting Coyote HTTP/1.1 on http-8080
      May 13, 2013 12:48:30 AM org.apache.jk.common.ChannelSocket init
      INFO: JK: ajp13 listening on /0.0.0.0:8009
      May 13, 2013 12:48:30 AM org.apache.jk.server.JkMain start
      INFO: Jk running ID=0 time=0/15 config=null
      May 13, 2013 12:48:30 AM org.apache.catalina.startup.Catalina start
      INFO: Server startup in 16222 ms

      Sometime Tomcat Successfully connect with database*
      [ 13-May-2013 10:02:29 ] [ INFO ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: init() Called.
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: Adding data manager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: **************************************************************
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 1 : com.cmp.mysm.hibernate.core.system.staff.HStaffDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 2 : com.cmp.mysm.hibernate.core.system.systemparameter.HSystemParameterDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 3 : com.cmp.mysm.hibernate.core.system.profilemanagement.HProfileDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 4 : com.cmp.mysm.hibernate.core.system.accessgroup.HAccessGroupDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 5 : com.cmp.mysm.hibernate.systemaudit.HSystemAuditDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 6 : com.cmp.mysm.hibernate.datasource.database.HDatabaseDSDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 7 : com.cmp.mysm.hibernate.datasource.ldap.HLDAPDatasourceDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 8 : com.cmp.mysm.hibernate.sessionmanager.HSessionManagerDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 9 : com.cmp.mysm.hibernate.sessionmanager.HASMDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 10 : com.cmp.mysm.hibernate.digestconf.HDigestConfDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 11 : com.cmp.mysm.hibernate.radius.clientprofile.HClientProfileDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 12 : com.cmp.mysm.hibernate.externalsystem.HExternalSystemInterfaceDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 13 : com.cmp.mysm.hibernate.servermgr.drivers.HDriverDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 14 : com.cmp.mysm.hibernate.servermgr.drivers.subscriberprofile.database.HDatabaseSubscriberProfileDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 15 : com.cmp.mysm.hibernate.servermgr.service.HServiceDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 16 : com.cmp.mysm.hibernate.servicepolicy.auth.HAuthServicePoilcyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 17 : com.cmp.mysm.hibernate.servicepolicy.acct.HAcctServicePoilcyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 18 : com.cmp.mysm.hibernate.servicepolicy.dynauth.HDynAuthServicePoilcyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 19 : com.cmp.mysm.hibernate.servermgr.server.HServerDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 20 : com.cmp.mysm.hibernate.servermgr.service.HServiceDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 21 : com.cmp.mysm.hibernate.servermgr.plugin.HPluginDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 22 : com.cmp.mysm.hibernate.rm.ippool.HIPPoolDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 23 : com.cmp.mysm.hibernate.servermgr.eap.HEAPConfigDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 24 : com.cmp.mysm.hibernate.servermgr.alert.HAlertListenerDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 25 : com.cmp.mysm.hibernate.servermgr.gracepolicy.HGracePolicyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 26 : com.cmp.mysm.hibernate.radius.clientprofile.HClientProfileDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 27 : com.cmp.mysm.hibernate.radius.dictionary.HDictionaryDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 28 : com.cmp.mysm.hibernate.radius.policies.accesspolicy.HAccessPolicyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 29 : com.cmp.mysm.hibernate.radius.policies.radiuspolicy.HRadiusPolicyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 30 : com.cmp.mysm.hibernate.radius.radtest.HRadiusTestDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 31 : com.cmp.mysm.hibernate.radius.bwlist.HBWListBLManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 32 : com.cmp.mysm.hibernate.rm.concurrentloginpolicy.HConcurrentLoginPolicyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 33 : com.cmp.mysm.hibernate.wsconfig.HWebServiceConfigDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 34 : com.cmp.mysm.hibernate.diameter.dictionary.HDictionaryDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 35 : com.cmp.mysm.hibernate.servicepolicy.diameter.naspolicy.HDiameterNASPolicyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 36 : com.cmp.mysm.hibernate.servicepolicy.diameter.creditcontrolpolicy.HCreditControlPolicyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 37 : com.cmp.mysm.hibernate.servicepolicy.diameter.eappolicy.HEAPPolicyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 38 : com.cmp.mysm.hibernate.servermgr.drivers.HDiameterDriverDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 39 : com.cmp.mysm.hibernate.servermgr.transmapconf.HTranslationMappingConfDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 40 : com.cmp.mysm.hibernate.diameter.diameterpolicy.HDiameterPolicyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 41 : com.cmp.mysm.hibernate.servicepolicy.rm.cgpolicy.HCGPolicyDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 42 : com.cmp.mysm.hibernate.reports.userstat.HUserStatisticsDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 43 : com.cmp.mysm.hibernate.diameter.routingconf.HDiameterRoutingConfDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 44 : com.cmp.mysm.hibernate.diameter.diameterpeerprofile.HDiameterPeerProfileDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 45 : com.cmp.mysm.hibernate.diameter.diameterpeer.HDiameterPeerDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: 46 : com.cmp.mysm.hibernate.core.base.HGenericDataManager
      [ 13-May-2013 10:02:29 ] [ DEBUG ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: **************************************************************
      [ 13-May-2013 10:02:29 ] [ INFO ] [0.0.0.0] - unknown [DATA MANAGER FACTORY]: Data manager Successfully initialized.
      In data Manager :1
      In data Manager :2
      In data Manager :19
      In data Manager :20
      In data Manager :21
      In data Manager :22
      In data Manager :23
      In data Manager :24
      In data Manager :3
      In data Manager :4
      May 13, 2013 10:02:30 AM org.apache.catalina.startup.HostConfig deployDescriptor
      INFO: Deploying configuration descriptor manager.xml
      May 13, 2013 10:02:30 AM org.apache.catalina.startup.HostConfig deployDescriptor
      INFO: Deploying configuration descriptor host-manager.xml
      May 13, 2013 10:02:30 AM org.apache.catalina.startup.HostConfig deployDirectory
      INFO: Deploying web application directory docs
      May 13, 2013 10:02:30 AM org.apache.catalina.startup.HostConfig deployDirectory
      INFO: Deploying web application directory ROOT
      May 13, 2013 10:02:30 AM org.apache.catalina.startup.HostConfig deployDirectory
      INFO: Deploying web application directory examples
      May 13, 2013 10:02:30 AM org.apache.coyote.http11.Http11Protocol start
      INFO: Starting Coyote HTTP/1.1 on http-8080
      May 13, 2013 10:02:30 AM org.apache.jk.common.ChannelSocket init
      INFO: JK: ajp13 listening on /0.0.0.0:8009
      May 13, 2013 10:02:30 AM org.apache.jk.server.JkMain start
      INFO: Jk running ID=0 time=0/14 config=null
      May 13, 2013 10:02:30 AM org.apache.catalina.startup.Catalina start
      INFO: Server startup in 6176 ms


      But again when we try to shutdown and startup then same problem occured we are not able to connect to database

      Thanks in advanace