java 启动tomcat时报错：TNS:listener does not currently know of SID given in connect descriptor

最新推荐文章于 2025-05-27 15:26:39 发布

原创最新推荐文章于 2025-05-27 15:26:39 发布 · 2k 阅读

0 ·

CC 4.0 BY-SA版权

本文详细记录了一次Spring框架中出现的复杂依赖注入错误，包括通知监听器、用户数据管理器、流程引擎配置等组件的初始化失败情况，以及与数据库连接、缓存管理相关的深层次问题。通过分析错误堆栈，探讨了依赖关系未满足的根本原因。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

30-Apr-2019 14:25:01.080 警告 [RMI TCP Connection(2)-127.0.0.1] org.springframework.web.context.support.XmlWebApplicationContext.refresh Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'notificationListener': Unsatisfied dependency expressed through field 'userDataManager'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'customUserDataManager': Unsatisfied dependency expressed through field 'pec'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineConfiguration' defined in file [D:\work\小蓝\HbiParent\core\target\core\WEB-INF\classes\spring\applicationContext-activiti.xml]: Cannot create inner bean 'com.hand.hap.activiti.custom.CustomUserTaskParseHandler#79405deb' of type [com.hand.hap.activiti.custom.CustomUserTaskParseHandler] while setting bean property 'customDefaultBpmnParseHandlers' with key [0]; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'com.hand.hap.activiti.custom.CustomUserTaskParseHandler#79405deb': Unsatisfied dependency expressed through field 'autoDelegateListener'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'autoDeliverListener': Unsatisfied dependency expressed through field 'preferencesService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sysPreferencesServiceImpl' defined in file [D:\work\小蓝\HbiParent\core\target\core\WEB-INF\classes\com\hand\hap\system\service\impl\SysPreferencesServiceImpl.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'requestAD': Unsatisfied dependency expressed through field 'cacheManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'cacheManager' defined in file [D:\work\小蓝\HbiParent\core\target\core\WEB-INF\classes\spring\applicationContext-redis.xml]: Cannot resolve reference to bean 'codeCache' while setting bean property 'caches' with key [5]; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'codeCache': Unsatisfied dependency expressed through field 'languageProvider'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'languageProvider' defined in file [D:\work\小蓝\HbiParent\core\target\core\WEB-INF\classes\spring\applicationContext.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 )
30-Apr-2019 14:25:01.092 严重 [RMI TCP Connection(2)-127.0.0.1] org.springframework.web.context.ContextLoader.initWebApplicationContext Context initialization failed
 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'notificationListener': Unsatisfied dependency expressed through field 'userDataManager'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'customUserDataManager': Unsatisfied dependency expressed through field 'pec'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineConfiguration' defined in file [D:\work\小蓝\HbiParent\core\target\core\WEB-INF\classes\spring\applicationContext-activiti.xml]: Cannot create inner bean 'com.hand.hap.activiti.custom.CustomUserTaskParseHandler#79405deb' of type [com.hand.hap.activiti.custom.CustomUserTaskParseHandler] while setting bean property 'customDefaultBpmnParseHandlers' with key [0]; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'com.hand.hap.activiti.custom.CustomUserTaskParseHandler#79405deb': Unsatisfied dependency expressed through field 'autoDelegateListener'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'autoDeliverListener': Unsatisfied dependency expressed through field 'preferencesService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sysPreferencesServiceImpl' defined in file [D:\work\小蓝\HbiParent\core\target\core\WEB-INF\classes\com\hand\hap\system\service\impl\SysPreferencesServiceImpl.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'requestAD': Unsatisfied dependency expressed through field 'cacheManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'cacheManager' defined in file [D:\work\小蓝\HbiParent\core\target\core\WEB-INF\classes\spring\applicationContext-redis.xml]: Cannot resolve reference to bean 'codeCache' while setting bean property 'caches' with key [5]; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'codeCache': Unsatisfied dependency expressed through field 'languageProvider'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'languageProvider' defined in file [D:\work\小蓝\HbiParent\core\target\core\WEB-INF\classes\spring\applicationContext.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 )

配置文件

<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver"
          username="***" password="***!1234"
          maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/hap_dev"
          removeAbandoned="true" removeAbandonedTimeout="300" testWhileIdle="true"
          timeBetweenEvictionRunsMillis="86400" type="javax.sql.DataSource"
          url="jdbc:oracle:thin:@117.**.**.***:9581:***"
          validationQuery="select 1 from dual"/>

url="jdbc:oracle:thin:@117.**.**.***:9581:***" 把9581:*** 改成 9581/***