新手上路.烦了小弟1天了..实在受不了啦..下面说说问题所在... com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/easyjweb/model/mysql/user.xml.
--- The error occurred while executing mapped statement.
--- Check the User.insertUserInfo.
--- Check the statement or the result map.
--- Cause: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/cop?useUnicode=true&characterEncoding=utf-8
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:59)
at com.easyjweb.dao.UserDAO.saveLead(UserDAO.java:11)
at com.easyjweb.service.testSpring.saveUser(testSpring.java:10)
at com.easyjweb.action.HelloAction.execute(HelloAction.java:22)
at com.easyjf.web.core.DefaultRequestProcessor.getResult(DefaultRequestProcessor.java:408)
at com.easyjf.web.core.DefaultRequestProcessor.process(DefaultRequestProcessor.java:176)
at com.easyjf.web.core.DefaultRequestProcessor.process(DefaultRequestProcessor.java:118)
at com.easyjf.web.ActionServlet.doRequest(ActionServlet.java:192)
at com.easyjf.web.ActionServlet.doGet(ActionServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) 按照网上的说法: classpath为 .;%JAVA_HOME%\lib;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;;%JAVA_HOME%\lib\mysql-connector-java-3.0.14-production-bin;
JAVA_HOME为 C:\Program Files\Java\jdk1.6.0_02 path是%JAVA_HOME%\bin;
mysql-connector-java-3.0.14-production-bin.jar驱动包已经放到各种lib包下..
以下是sql-map-config.xml配置文件:
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd"><sqlMapConfig> <settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" maxRequests="32" maxSessions="10" maxTransactions="5" useStatementNamespaces="true" />
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="org.springframework.jdbc.datasource.DriverManagerDataSource" />
<property name="driverClassName" value="org.gjt.mm.mysql.Driver" />
<property name="JDBC.ConnectionURL"
value="jdbc:mysql://localhost:3306/cop?useUnicode=true&characterEncoding=utf-8" />
<property name="JDBC.Username" value="root" />
<property name="JDBC.Password" value="123" />
<property name="Pool.MaximumActiveConnections" value="10" />
<property name="Pool.MaximumIdleConnections" value="5" />
<property name="Pool.MaximumCheckoutTime" value="120000" />
<property name="Pool.TimeToWait" value="500" />
<property name="Pool.PingQuery" value="select 1 from userinfo" />
<property name="Pool.PingEnabled" value="false" />
<property name="Pool.PingConnectionsOlderThan" value="1" />
<property name="Pool.PingConnectionsNotUsedFor" value="1" />
</dataSource>
</transactionManager>
<sqlMap resource="com/easyjweb/model/mysql/user.xml" />
</sqlMapConfig> user.xml配置信息:
<sqlMap namespace="User">
<typeAlias alias="user" type="com.easyjweb.model.User" /> <resultMap id="userResult" class="user">
<result property="id" column="Id" />
<result property="userName" column="USERNAME" />
<result property="userPwd" column="PWD" />
</resultMap>
<insert id="insertUserInfo" parameterClass="user">
INSERT INTO person
(USERNAME,PWD)
VALUES
(#userName#,#userPwd#)
</insert>
</sqlMap> Dao调用:public class UserDAO extends sqlMapManage{
public void saveLead(User baseUser) {
try {
getSqlMapClient().insert("User.insertUserInfo", baseUser);
} catch (Exception e) {
e.printStackTrace();
}
}} 小弟真不知道是哪问题...求前辈指点一二啊...
--- The error occurred in com/easyjweb/model/mysql/user.xml.
--- The error occurred while executing mapped statement.
--- Check the User.insertUserInfo.
--- Check the statement or the result map.
--- Cause: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/cop?useUnicode=true&characterEncoding=utf-8
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:59)
at com.easyjweb.dao.UserDAO.saveLead(UserDAO.java:11)
at com.easyjweb.service.testSpring.saveUser(testSpring.java:10)
at com.easyjweb.action.HelloAction.execute(HelloAction.java:22)
at com.easyjf.web.core.DefaultRequestProcessor.getResult(DefaultRequestProcessor.java:408)
at com.easyjf.web.core.DefaultRequestProcessor.process(DefaultRequestProcessor.java:176)
at com.easyjf.web.core.DefaultRequestProcessor.process(DefaultRequestProcessor.java:118)
at com.easyjf.web.ActionServlet.doRequest(ActionServlet.java:192)
at com.easyjf.web.ActionServlet.doGet(ActionServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) 按照网上的说法: classpath为 .;%JAVA_HOME%\lib;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;;%JAVA_HOME%\lib\mysql-connector-java-3.0.14-production-bin;
JAVA_HOME为 C:\Program Files\Java\jdk1.6.0_02 path是%JAVA_HOME%\bin;
mysql-connector-java-3.0.14-production-bin.jar驱动包已经放到各种lib包下..
以下是sql-map-config.xml配置文件:
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd"><sqlMapConfig> <settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" maxRequests="32" maxSessions="10" maxTransactions="5" useStatementNamespaces="true" />
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="org.springframework.jdbc.datasource.DriverManagerDataSource" />
<property name="driverClassName" value="org.gjt.mm.mysql.Driver" />
<property name="JDBC.ConnectionURL"
value="jdbc:mysql://localhost:3306/cop?useUnicode=true&characterEncoding=utf-8" />
<property name="JDBC.Username" value="root" />
<property name="JDBC.Password" value="123" />
<property name="Pool.MaximumActiveConnections" value="10" />
<property name="Pool.MaximumIdleConnections" value="5" />
<property name="Pool.MaximumCheckoutTime" value="120000" />
<property name="Pool.TimeToWait" value="500" />
<property name="Pool.PingQuery" value="select 1 from userinfo" />
<property name="Pool.PingEnabled" value="false" />
<property name="Pool.PingConnectionsOlderThan" value="1" />
<property name="Pool.PingConnectionsNotUsedFor" value="1" />
</dataSource>
</transactionManager>
<sqlMap resource="com/easyjweb/model/mysql/user.xml" />
</sqlMapConfig> user.xml配置信息:
<sqlMap namespace="User">
<typeAlias alias="user" type="com.easyjweb.model.User" /> <resultMap id="userResult" class="user">
<result property="id" column="Id" />
<result property="userName" column="USERNAME" />
<result property="userPwd" column="PWD" />
</resultMap>
<insert id="insertUserInfo" parameterClass="user">
INSERT INTO person
(USERNAME,PWD)
VALUES
(#userName#,#userPwd#)
</insert>
</sqlMap> Dao调用:public class UserDAO extends sqlMapManage{
public void saveLead(User baseUser) {
try {
getSqlMapClient().insert("User.insertUserInfo", baseUser);
} catch (Exception e) {
e.printStackTrace();
}
}} 小弟真不知道是哪问题...求前辈指点一二啊...
解决方案 »
- 用过spring mail的进,求指教!
- ibatis数据关联一对多,帮个忙吧
- Object对象的背后机制
- struts的html标签和html中的标签有什么区别
- EXEC master..xp_cmdshell 数据分隔问题
- 请问怎么用hibernate进行跨表查询啊?
- 如果没有类似.NET的拖拽式RAD环境和大量组件那么可笑的JSF和弱智structs有什么区别?新瓶装旧酒!
- jsf 脚本提交
- 在 <script> </script> 之间能不能出现struts的标签和jsp的<%... %>语句
- RMI服务器是怎么管理rmi请求的?
- spring 前途如何?
- 2013年哪款UML工具是主流的,用的人是最多的???
照着这个例子做,先体验一下怎么用iBatis吧