67,513
社区成员
发帖
与我相关
我的任务
分享
<context:property-placeholder location="/WEB-INF/conf/jdbc.properties"/>
<bean id="dataSource" class="org.apache.commons.dbcp2.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 name="maxTotal" value="${jdbc.maxTotal}"/>
<property name="maxIdle" value="${jdbc.maxIdle}"/>
<property name="minIdle" value="${jdbc.minIdle}"/>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mapperLocations" value="classpath:com/lining/vmservice/mapper/*Mapper.xml"/>
<property name="typeAliasesPackage" value="com.lining.vmservice.model" />
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.lining.vmservice.mapper" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
@Service("vmGuestService")
public class VMGuestServiceImp implements VMGuestService {
@Autowired
private VMGuestMapper vmMapper;
/*
* <p>Title: createVMGuest</p>
* <p>Description: </p>
* @return
* @see com.lining.vmservice.service.VMGuestService#createVMGuest()
*/
@Override
public boolean createVMGuest(VMGuest vmGuest) {
// 下面这行报的错
vmMapper.insert(vmGuest);
return true;
}
}
SEVERE: Servlet.service() for servlet [liningcloud] in context with path [/liningVMservice] threw exception [Handler processing failed; nested exception is java.lang.AbstractMethodError: com.mysql.jdbc.Connection.isValid(I)Z] with root cause
java.lang.AbstractMethodError: com.mysql.jdbc.Connection.isValid(I)Z
at org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914)
at org.apache.commons.dbcp2.PoolableConnection.validate(PoolableConnection.java:227)
at org.apache.commons.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:303)
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2165)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:81)
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:44)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:67)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
at com.sun.proxy.$Proxy10.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:240)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:79)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
at com.sun.proxy.$Proxy11.insert(Unknown Source)
at com.lining.vmservice.service.imp.VMGuestServiceImp.createVMGuest(VMGuestServiceImp.java:44)
<mapper namespace="com.lining.vmservice.mapper.VMGuestMapper" >
<resultMap id="BaseResultMap" type="com.lining.vmservice.model.VMGuest" >
<!--
WARNING - @mbggenerated
This element is automatically generated by MyBatis Generator, do not modify.
-->
<id column="id" property="id" jdbcType="VARCHAR" />
<result column="name" property="name" jdbcType="VARCHAR" />
<result column="vm_type" property="vmType" jdbcType="VARCHAR" />
.........................
</resultMap>
以上是我的resultMap /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table vmguest
*
* @mbggenerated
*/
int insert(VMGuest record);
<insert id="insert" parameterType="com.lining.vmservice.model.VMGuest" >
<!--
WARNING - @mbggenerated
This element is automatically generated by MyBatis Generator, do not modify.
-->
insert into vmguest (id, name, vm_type,
cpu_clock, cpu_count, memory_size,
architecture, os_type, power_state,
vm_state, create_date, update_date,
image_id, template_id, lserver_key
)
values (#{id,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{vmType,jdbcType=VARCHAR},
#{cpuClock,jdbcType=DOUBLE}, #{cpuCount,jdbcType=INTEGER}, #{memorySize,jdbcType=DOUBLE},
#{architecture,jdbcType=INTEGER}, #{osType,jdbcType=VARCHAR}, #{powerState,jdbcType=VARCHAR},
#{vmState,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{updateDate,jdbcType=TIMESTAMP},
#{imageId,jdbcType=VARCHAR}, #{templateId,jdbcType=VARCHAR}, #{lserverKey,jdbcType=VARCHAR}
)
</insert>
以上是我的代码 和sql