Oracle数据源:org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection;

深藏阁楼爱情的钟 2022-08-13 00:36 300阅读 0赞

SpringMVC框架下，Oracle数据源在spring-servlet.xml中的配置如下：

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  
        destroy-method="close">  
        <property name="driverClassName">  
            <value>oracle.jdbc.driver.OracleDriver</value>  
        </property>  
        <property name="url">  
            <value>oracle:thin:@127.0.0.1:1521:orcl</value>  
        </property>  
        <property name="username">  
            <value>scott</value>  
        </property>  
        <property name="password">  
            <value>XXXXX</value>  
        </property>  
    </bean>

异常如下：

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'oracle:thin:@127.0.0.1:1521:orcl'  
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)  
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:573)  
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)  
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)  
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)  
    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:734)  
    at com.springdemo.module.usermgr.dao.UserMgrDao.getUserByColunm(UserMgrDao.java:24)  
    at com.springdemo.module.usermgr.service.UserMgrService.getUserByUserName(UserMgrService.java:44)  
    ... 30 more

错误原因：url配置不正确，应该为jdbc:oracle:thin:@127.0.0.1:1521:orcl

Oracle数据源:org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection;

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关【mysql】org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

相关 jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection 问题

相关 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection 问题处理

相关 IDEA Could not get JDBC Connection； nested exception is com.mysql.jdbc.exceptions

相关 Oracle数据源:org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection;

相关 Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nes

相关 Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not

相关报Could not get JDBC Connection的错误

相关 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection java.sql.SQ

相关【Java】 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection