org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

最新推荐文章于 2024-09-20 17:11:37 发布
最新推荐文章于 2024-09-20 17:11:37 发布
阅读量4.5w 收藏 1
点赞数 1
分类专栏： java异常
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/myself_sky/article/details/70164101
版权 
引进新项目的时候启动报错，使用的是tomcat7，jdk6，Myeclipse10，oracle。具体原因分析：

2017-04-13 21:03:21,694 WARN [org.hibernate.cfg.SettingsFactory] - Could not obtain connection to query metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied
)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
    at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
    at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)
    at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:860)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:779)
    at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:188)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:567)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5528)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1263)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1948)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)
    at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564)
    at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
    ... 37 more

hibenate.cfg.xml的配置：

<hibernate-configuration>
	<session-factory>
		<property name="show_sql">true</property>
		<property name="myeclipse.connection.profile">
			DBOracle
		</property>
		<property name="connection.url">
			jdbc:oracle:thin:@127.0.0.1:1521:orcl
		</property>
		<property name="connection.username">scott</property>
		<property name="connection.password">123456</property>
		<property name="connection.driver_class">
			oracle.jdbc.OracleDriver
		</property>
		<property name="dialect">
			org.hibernate.dialect.Oracle9Dialect
		</property>
		<property name="format_sql">true</property>
		<mapping
			resource="cn/jbit/auction/entity/Auctionrecord.hbm.xml" />
		<mapping resource="cn/jbit/auction/entity/Auction.hbm.xml" />
		<mapping resource="cn/jbit/auction/entity/Auctionuser.hbm.xml" />
	</session-factory>
</hibernate-configuration>






原因：由于是在不同的设备进行的项目的运行，因为数据库连接名不对应，所以报错了。以后报类似的错误的话，首先检查连接(红色框的地方)是否存在不对应或者拼写错误。








                

        

        

    

  


    

      

        

            

              
                
                  myself_sky
                
              
            

            

                关注
              
            

        

        

          
      

      

            

                专栏目录
          









                



	

		

			

				
					
JDBC连接ORACLE无法登陆java.sql.SQLException: ORA-01017: invalid username/password; logon denied...

				
			

			

				

					aoningxun2220的博客
				

				

					06-03
					
					2531
					
				

			

		

		

			
				
当用jdbc连接Oracle数据库的时候   private Connection getConnection() throws SQLException
   {
		OracleDataSource ods = new OracleDataSource();
		ods.setUser("biaoJM");
		ods.setPassword("12...

			
		

	



                

            
              



	

		

			

				
					
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied f...

				
			

			

				

					weixin_30679823的博客
				

				

					05-28
					
					447
					
				

			

		

		

			
				
tationProcessor' to allow for resolving potential circular referencesDEBUG 2018-05-28 11:32:35,016 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory: Finished creating insta...

			
		

	



              


  
              

                


	

		

			

				
					
Failed to obtain JDBC Connection: Cannot determine target DataSource for lookup key [null]

					
最新发布

				
			

			

				

					由入门到精通
				

				

					09-20
					
					581
					
				

			

		

		

			
				
在后管运行中一直是好的，突然发现部分菜单点击异常，出不来数据，查看后台日志报错内容如下，可以检查应用是否使用了shrio，可以尝试清除浏览器缓存数据，后管功能中的注销进行退出，再进行重新登录，解决了该问题。3、所有和后管相关的应用和中间件全部进行重启（server、console、client三个应用），并清理缓存（redis重启并通过flushall清理所有缓存数据）。2、查看数据库版本为5.x，和要求的8.x不一致，重新部署新的数据库并重新初始化数据。

			
		

	





	

		

			

				
					
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnection

					
热门推荐

				
			

			

				

					liaoqing1999的博客
				

				

					02-28
					
					1万+
					
				

			

		

		

			
				
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnection
"Host ‘xx.xx.xx.xx’ is blocked because of many connection errors;
问题描述
数据库连接的时候出现了这个问题，
原因是：同一个ip在短时间内产生太多（超过mysql数据库max_co...

			
		

	



		

			
		



	

		

			

				
					
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications

				
			

			

				

					G_whang的博客
				

				

					11-16
					
					640
					
				

			

		

		

			
				
报表系统启动tomcat的时候报了如下异常
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
 at org.apache.commons.dbcp.BasicDataSource.crea...

			
		

	





	

		

			

				
					
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-01017: inva...

				
			

			

				

					weixin_30674525的博客
				

				

					10-09
					
					344
					
				

			

		

		

			
				
最近写spring整合mybatis 时发现出现这个错误
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied) at org.apache.commons.dbcp.Bas...

			
		

	





	

		

			

				
					
Failed to obtain JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

				
			

			

				

					07-27
				

			

		

		

			
				
引用\[1\]中提到，当访问自己的localhost时，出现了白页，并且控制台打印了"Failed to obtain JDBC Connection;...根据\[2\]中的引用，这个错误可能是由于数据库配置中的时区问题引起的。具体来说，错误信息中提到了...

			
		

	





	

		

			

				
					
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'lx'@'localhost' (using password: YES))

				
			

			

				

					07-11
				

			

		

		

			
				
例如，在使用 Apache Tomcat 运行的应用程序中，你可以检查 `context.xml` 文件中的数据库连接配置。 4. 检查数据库服务器配置：确保数据库服务器允许来自该主机和端口的连接，并且没有设置任何额外的访问限制。  ...

			
		

	





	

		

			

				
					
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack)

				
			

			

				

					06-13
				

			

		

		

			
				
这个错误表示数据库连接池无法创建可池化的连接工厂，原因是连接监听程序拒绝了连接，报错信息是ORA-12516，即监听程序无法找到与匹配协议栈的可用处理程序。这通常是由于数据库连接池中的连接数超过了数据库实例的...

			
		

	





	

		

			

				
					
org.apache.commons.dbcp.SQLNestedException

				
			

			

				

					qq_56637516的博客
				

				

					10-18
					
					4377
					
				

			

		

		

			
				
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user '16348'@'localhost' (using password: YES))


原配置文件

driver=com.mysql.jdbc.Driver

url=jdbc:mysql://localhost:3306/epet?useUnicode=true&a.

			
		

	





	

		

			

				
					
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-

				
			

			

				

					zgq_nature的博客
				

				

					08-02
					
					4724
					
				

			

		

		

			
				
今天将数据库从mysql换成oracle时，做单元测试是出现：

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.springframe...

			
		

	





	

		

			

				
					
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

				
			

			

				

					weixin_41781654的博客
				

				

					11-11
					
					1830
					
				

			

		

		

			
				
applicationContext.xml 文件



db.properties 文件



运行文件AppTest



运行报错：


D:\Java\bin\java.exe -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:55364,suspend=y,server=n -ea -Didea.test.cyclic.buffer.size=1048576 -javaagent:C:\Users\Administrator\AppData\

			
		

	





	

		

			

				
					
nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact

				
			

			

				

					Knight_Ren的博客
				

				

					01-06
					
					2090
					
				

			

		

		

			
				
数据库之前可以连上下午就连不上了，报错： get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

尝试的解决办法：username->use...

			
		

	





	

		

			

				
					
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown databas...

				
			

			

				

					weixin_30786657的博客
				

				

					09-20
					
					378
					
				

			

		

		

			
				
org.apache.commons.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (Unknown database 'jdsc')
无法创建连接池,未知的数据库jdsc
转载于:https://www.cnblogs.com/tongs/p/7560422.html...

			
		

	



              




          




        



    





    



      

      

        
      

      





	

		评论	
	

	
	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

                
 1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
 2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

              

            

          

      

      余额充值