SSM链接mysql数据库问题Cannot create JDBC driver of class

八月 23, 2017 4:01:37 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [SpringMVC] in context with path [/liuyg] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mysql:127.0.0.1:3306/tjfx'

The error may exist in file [D:\tomcat - liuyg\tomcat-7.0.81\webapps\liuyg\WEB-INF\classes\com\Mapping\xt_userMapper.xml]

The error may involve com.Dao.xt_userMapper.selectByPrimaryKey

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mysql:127.0.0.1:3306/tjfx'] with root cause

java.sql.SQLException: No suitable driver

配置文件如下

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:127.0.0.1:3306/tjfx
jdbc.username=root
jdbc.password=root
#定义初始连接数
jdbc.initialSize=0
#定义最大连接数
jdbc.maxActive=20
#定义最大空闲
jdbc.maxIdle=20
#定义最小空闲
jdbc.minIdle=1
#定义最长等待时间

jdbc.maxWait=600000

spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

<!-- 自动扫描该包,使SpringMVC认为包下用了@controller注解的类是控制器 -->



<!--避免IE执行AJAX时,返回JSON出现下载文件 -->

class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">





text/html;charset=UTF-8







<!-- 启动SpringMVC的注解功能,完成请求和注解POJO的映射 -->

class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">





<!-- JSON转换器 -->





<!--        静态资源处理-->
<mvc:default-servlet-handler/>
<!--        注解驱动-->
<mvc:annotation-driven></mvc:annotation-driven>

<!-- 配置文件上传,如果没有使用文件上传可以不用配置,当然如果不配,那么配置文件中也不必引入上传组件包 -->  
<bean id="multipartResolver"    
    class="org.springframework.web.multipart.commons.CommonsMultipartResolver">    
    <!-- 默认编码 -->  
    <property name="defaultEncoding" value="utf-8" />    
    <!-- 文件大小最大值 -->  
    <property name="maxUploadSize" value="10485760000" />    
    <!-- 内存中的最大值 -->  
    <property name="maxInMemorySize" value="40960" />    
</bean>   
<!-- 视图模式配置,velocity配置文件-->
<bean id="velocityConfig" class="org.springframework.web.servlet.view.velocity.VelocityConfigurer">  
    <property name="resourceLoaderPath" value="/welcome/" />  
    <property name="configLocation" value="classpath:velocity.properties" />  
    <property name="velocityProperties">
        <props>
            <prop key="input.encoding">utf-8</prop>
            <prop key="output.encoding">utf-8</prop>
        </props>
    </property> 
</bean>  

<!-- 配置后缀 -->
<bean id="velocityViewResolver" class="org.springframework.web.servlet.view.velocity.VelocityViewResolver">  
    <property name="suffix" value=".htm" />  
    <property name="contentType" value="text/html;charset=UTF-8"></property> 
</bean>

<import resource="spring-mybatis.xml"/>

spring-mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

<!-- 自动扫描 -->



<!-- 引入配置文件 -->

<!-- 1.读取数据库配置文件 -->

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  
    destroy-method="close">  
    <property name="driverClassName" value="${jdbc.driver}" />
    <property name="url" value="${jdbc.url}" />  
    <property name="username" value="${jdbc.username}" />  
    <property name="password" value="${jdbc.password}" />  
    <!-- 初始化连接大小 -->  
    <property name="initialSize" value="${jdbc.initialSize}"></property>  
    <!-- 连接池最大数量 -->  
    <property name="maxActive" value="${jdbc.maxActive}"></property>  
    <!-- 连接池最大空闲 -->  
    <property name="maxIdle" value="${jdbc.maxIdle}"></property>  
    <!-- 连接池最小空闲 -->  
    <property name="minIdle" value="${jdbc.minIdle}"></property>  
    <!-- 获取连接最大等待时间 -->  
    <property name="maxWait" value="${jdbc.maxWait}"></property>  
</bean>  

<!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->  
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
    <property name="dataSource" ref="dataSource" />  
    <!-- 自动扫描mapping.xml文件 -->  
    <property name="mapperLocations" value="classpath:com/Mapping/*.xml"></property>  
</bean>  

<!-- DAO接口所在包名,Spring会自动查找其下的类 -->  
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
    <property name="basePackage" value="com/Dao" />  
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>  
</bean>  

<!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->  
<bean id="transactionManager"  
    class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
    <property name="dataSource" ref="dataSource" />  
</bean>  

5个回答

The error may exist in file [D:\tomcat - liuyg\tomcat-7.0.81\webapps\liuyg\WEB-INF\classes\com\Mapping\xt_userMapper.xml]
The error may involve com.Dao.xt_userMapper.selectByPrimaryKey

在oracle里遇到过,可能是数据库锁了o(≧v≦)o~~如果不是就略过

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:127.0.0.1:3306/tjfx
jdbc.username=root
jdbc.password=root
#定义初始连接数
jdbc.initialSize=0
#定义最大连接数
jdbc.maxActive=20
#定义最大空闲
jdbc.maxIdle=20
#定义最小空闲
jdbc.minIdle=1
#定义最长等待时间
jdbc.maxWait=600000

jdbc.properties

<?xml version="1.0" encoding="UTF-8"?>

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

<!-- 自动扫描该包,使SpringMVC认为包下用了@controller注解的类是控制器 -->



<!--避免IE执行AJAX时,返回JSON出现下载文件 -->

class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">





text/html;charset=UTF-8







<!-- 启动SpringMVC的注解功能,完成请求和注解POJO的映射 -->

class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">





<!-- JSON转换器 -->





<!--        静态资源处理-->
<mvc:default-servlet-handler/>
<!--        注解驱动-->
<mvc:annotation-driven></mvc:annotation-driven>

<!-- 配置文件上传,如果没有使用文件上传可以不用配置,当然如果不配,那么配置文件中也不必引入上传组件包 -->  
<bean id="multipartResolver"    
    class="org.springframework.web.multipart.commons.CommonsMultipartResolver">    
    <!-- 默认编码 -->  
    <property name="defaultEncoding" value="utf-8" />    
    <!-- 文件大小最大值 -->  
    <property name="maxUploadSize" value="10485760000" />    
    <!-- 内存中的最大值 -->  
    <property name="maxInMemorySize" value="40960" />    
</bean>   
<!-- 视图模式配置,velocity配置文件-->
<bean id="velocityConfig" class="org.springframework.web.servlet.view.velocity.VelocityConfigurer">  
    <property name="resourceLoaderPath" value="/welcome/" />  
    <property name="configLocation" value="classpath:velocity.properties" />  
    <property name="velocityProperties">
        <props>
            <prop key="input.encoding">utf-8</prop>
            <prop key="output.encoding">utf-8</prop>
        </props>
    </property> 
</bean>  

<!-- 配置后缀 -->
<bean id="velocityViewResolver" class="org.springframework.web.servlet.view.velocity.VelocityViewResolver">  
    <property name="suffix" value=".htm" />  
    <property name="contentType" value="text/html;charset=UTF-8"></property> 
</bean>

<import resource="spring-mybatis.xml"/>

spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

<!-- 自动扫描 -->



<!-- 引入配置文件 -->

<!-- 1.读取数据库配置文件 -->

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  
    destroy-method="close">  
    <property name="driverClassName" value="${jdbc.driver}" />
    <property name="url" value="${jdbc.url}" />  
    <property name="username" value="${jdbc.username}" />  
    <property name="password" value="${jdbc.password}" />  
    <!-- 初始化连接大小 -->  
    <property name="initialSize" value="${jdbc.initialSize}"></property>  
    <!-- 连接池最大数量 -->  
    <property name="maxActive" value="${jdbc.maxActive}"></property>  
    <!-- 连接池最大空闲 -->  
    <property name="maxIdle" value="${jdbc.maxIdle}"></property>  
    <!-- 连接池最小空闲 -->  
    <property name="minIdle" value="${jdbc.minIdle}"></property>  
    <!-- 获取连接最大等待时间 -->  
    <property name="maxWait" value="${jdbc.maxWait}"></property>  
</bean>  

<!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->  
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
    <property name="dataSource" ref="dataSource" />  
    <!-- 自动扫描mapping.xml文件 -->  
    <property name="mapperLocations" value="classpath:com/Mapping/*.xml"></property>  
</bean>  

<!-- DAO接口所在包名,Spring会自动查找其下的类 -->  
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
    <property name="basePackage" value="com/Dao" />  
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>  
</bean>  

<!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->  
<bean id="transactionManager"  
    class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
    <property name="dataSource" ref="dataSource" />  
</bean>  

spring-mybatis.xml

Lsetea
Lsetea 回复qq_39947785: 我也没懂。。。。
大约 2 年之前 回复
qq_39947785
qq_39947785 我还是没有看懂
大约 2 年之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!