RT, the following exceptions often occur when using normal means for multiple data source configuration: (long interception, lowest resolution)
<2011-12-02 18:20:13,397> WARN (settingsfactory.java:117) [Containerbackgroundprocessor[standardengine
[Catalina]]]
(org.hibernate.cfg.SettingsFactory)-Could not obtain connection metadata Org.apache.tomcat.dbcp.dbcp.SQLNestedException:Cannot Create poolableconnectionfactory (Io exception:connection Refused (description= (tmp=) (vsnnum=169870336) (err=12505) (error_stack= (Error= (code=12505) (EMFI=4))) at Org.apach E.tomcat.dbcp.dbcp.basicdatasource.createdatasource (basicdatasource.java:1225) at Org.apache.tomcat.dbcp.dbcp.Ba Sicdatasource.getconnection (basicdatasource.java:880) at Org.springframework.orm.hibernate3.LocalDataSourceCon Nectionprovider.getconnection (localdatasourceconnectionprovider.java:80) at Org.hibernate.cfg.SettingsFactory.bu
Ildsettings (settingsfactory.java:84) at Org.hibernate.cfg.Configuration.buildSettings (configuration.java:2009) At Org.hibernate.cfg.Configuration.buildSessionFactory (configuration.java:1292) at Org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory (Localsessi onfactorybean.java:800) at Org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet (local sessionfactorybean.java:726) at ORG.SPRINGFRAMEWORK.BEANS.FACTORY.SUPPORT.ABSTRACTAUTOWIRECAPABLEBEANFACTORY.INV Okein Itmethods (abstractautowirecapablebeanfactory.java:1059) at Org.springframework.beans.factory.support.Abst Ractautowirecapablebeanfactory.createbe A (abstractautowirecapablebeanfactory.java:363) at org.springframework.be Ans.factory.support.AbstractBeanFactory.getBean (abstractbeanfactory.java:226) at Org.springframework.beans.facto Ry.support.AbstractBeanFactory.getBean (abstractbeanfactory.java:147) at Org.springframework.beans.factory.supp Ort. Defaultlistablebeanfactory.preinstantiatesi ngletons (defaultlistablebeanfactory.java:269) at Org.springframework. Context.support.AbstRactapplicationcontext.refresh (abstractapplicationcontext.java:320) at Org.springframework.context.support.Class Pathxmlapplicationcontext.<init> (classpathxmlapplicationcontext.java:87) at org.springframework.context.su Pport. Classpathxmlapplicationcontext.<init> (classpathxmlapplicationcontext.java:72) at Sun.reflect.NativeConstru Ctoraccessorimpl.newinstance0 (Native method) at Sun.reflect.NativeConstructorAccessorImpl.newInstance (nativecons tructoraccessorimpl.java:39) at Sun.reflect.DelegatingConstructorAccessorImpl.newInstance (Delegatingconstructora ccessorimpl.java:27) at Java.lang.reflect.Constructor.newInstance (constructor.java:513) at Org.springframe Work.beans.BeanUtils.instantiateClass (beanutils.java:172) at Org.springframework.beans.factory.support.SimpleIns Tantiationstrategy.instantiate (simpleinstantiationstrategy.java:75) at Org.springframework.beans.factory.suppo Rt. AbstractautowirEcapablebeanfactory.autowire Constructor (abstractautowirecapablebeanfactory.java:670) at org.springframework.be
Ans.factory.support.AbstractAutowireCapableBeanFactory.createBe an (abstractautowirecapablebeanfactory.java:329) At Org.springframework.beans.factory.support.AbstractBeanFactory.getBean (abstractbeanfactory.java:226) at ORG.SP Ringframework.beans.factory.support.AbstractBeanFactory.getBean (abstractbeanfactory.java:147) at Org.springfra Mework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSi Ngletons ( defaultlistablebeanfactory.java:275) at Org.springframework.beans.factory.access.SingletonBeanFactoryLocator.ini Tializedefini tion (singletonbeanfactorylocator.java:502) at Org.springframework.beans.factory.access.SingletonB Eanfactorylocator.usebeanfactory (singletonbeanfactorylocator.java:386) at Com.hollycrm.framework.DefaultBeanFact Ory.getfactory (defaultbeanfactory.java:54) at Com.hollYcrm.framework.DefaultBeanFactory.getBean (defaultbeanfactory.java:39) at Com.hollycrm.framework.DefaultBeanFacto Ry.getbean (defaultbeanfactory.java:35) at Com.hollycrm.framework.web.servlet.ContextLoaderServlet.init (context loaderservlet.java:42) at Javax.servlet.GenericServlet.init (genericservlet.java:212) at Org.apache.catalin A.core.standardwrapper.loadservlet (standardwrapper.java:1161) at Org.apache.catalina.core.StandardWrapper.load (S
tandardwrapper.java:981) at Org.apache.catalina.core.StandardContext.loadOnStartup (standardcontext.java:4045) At Org.apache.catalina.core.StandardContext.start (standardcontext.java:4351) at Org.apache.catalina.core.Con Tainerbase.addchildinternal (containerbase.java:791) at Org.apache.catalina.core.ContainerBase.addChild (Container base.java:771) at Org.apache.catalina.core.StandardHost.addChild (standardhost.java:525) at Org.apache.cata Lina.startup.HostConfig.Deploydescriptor (hostconfig.java:626) at Org.apache.catalina.startup.HostConfig.deployDescriptors (HOSTCONFIG.J ava:553) at the Org.apache.catalina.startup.HostConfig.deployApps (hostconfig.java:488) at Org.apache.catalina. Startup. Hostconfig.check (hostconfig.java:1206) at Org.apache.catalina.startup.HostConfig.lifecycleEvent (Hostconfig.java : 293) at Org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (lifecyclesupport.java:117) at Org. Apache.catalina.core.ContainerBase.backgroundProcess (containerbase.java:1337) at Org.apache.catalina.core.Cont Ainerbase$containerbackgroundprocessor.processchildren (containerbase.java:1601) at Org.apache.catalina.core.Co Ntainerbase$containerbackgroundprocessor.processchildren (containerbase.java:1610) at Org.apache.catalina.core.Co Ntainerbase$containerbackgroundprocessor.run (containerbase.java:1590) at Java.lang.Thread.run (thread.java:662) C Aused By:java.sql.Sqlexception:io Exception:connection refused (description= (tmp=) (vsnnum=169870336) (err=12505) (ERROR_STACK= (ERROR= (code=12505)
(emfi=4))) At Oracle.jdbc.dbaccess.DBError.throwSqlException (dberror.java:134) at ORACLE.JDBC.DBACCESS.DBERROR.THROWSQLEXCEP tion (dberror.java:179) at the Oracle.jdbc.dbaccess.DBError.throwSqlException (dberror.java:333) at Oracle.jdbc. Driver. Oracleconnection.<init> (oracleconnection.java:404) at Oracle.jdbc.driver.OracleDriver.getConnectionInstance (oracledriver.java:468) at Oracle.jdbc.driver.OracleDriver. Connect (oracledriver.java:314) at Org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection (Drivercon nectionfactory.java:38) at Org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject (POOLABLECONNECTIONFA ctory.java:294) at Org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory (basicdatasource.java:12 ) at Org.apache.tomcat.dbcp.dbcp.BasIcdatasource.createdatasource (basicdatasource.java:1221) ... Wuyi <2011-12-02 18:20:13,421> WARN (oracle9dialect.java:37) [containerbackgroundprocessor[standardengine[ Catalina]]] (org.hibernate.dialect.Oracle9Dialect)-the Oracle9dialect dialect has been;
Use either Oracle
The project is configured in Tomcat\cof\catalina\locaihost\webproject.xml, but conflicts occur when there are multiple data sources, which can be configured using the descriptor in Tnsname.ora:
<?xml version= "1.0" encoding= "UTF-8"?> <context path=
"*" docbase= "/**/**/tomcat-6.0.14/*" >
<resource name= "Jdbc/unicomapp" auth= "Container" type= "Javax.sql.DataSource" username= "* * * * * * password=" * * * * * * * Driverclassname= "Oracle.jdbc.driver.OracleDriver" Url= "jdbc:oracle:thin:@" (DESCRIPTION = (load_balance = off) ( FAILOVER = on) (Address_list = (address = (PROTOCOL = tcp) (HOST = 100.100.9.12) (PORT = 1521)) (address = (PROTOCOL = tcp) ( HOST = 100.100.9.14) (PORT = 1521))) (Connect_data = (service_name = **unic**) (Failover_mode = (TYPE = Session) (method = BASIC)) "maxidle=" maxactive= "/> <resourcelink name=" usertransaction "global=" UserTransaction "
Type= "Javax.transaction.UserTransaction"/>
<watchedresource>web-inf/web.xml</watchedresource >
</Context>