初学ibatis遇到的一些异常

0 0

初学ibatis遇到的一些异常15

java文件：

package com.ibatis.sample;

import java.io.Reader;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import com.ibatis.sqlmap.engine.builder.xml.XMLSqlSource;

public class Test {

	public void insertTest() {
		SqlMapClient smc = null;
		try {
			String str = "./com/ibatis/sample/sqlMapConfig.xml";
			Reader reader = Resources.getResourceAsReader(str);
			smc = SqlMapClientBuilder.buildSqlMapClient(reader);
			//smc.startTransaction();
			Dept d = new Dept();
			d.setDname("aaaa");
			d.setLoc("bbbb");
			smc.insert("insertDept");
			System.out.print(d.getDname());
			//smc.commitTransaction();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try{
			//smc.endTransaction();
			}catch (Exception e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void main(String[] args){
		Test t=new Test();
		t.insertTest();
	}

}

数据库配置：

<?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" errorTracingEnabled="true" maxRequests="32"
		maxSessions="10" maxTransactions="5" useStatementNamespaces="false" />
	<transactionManager type="JDBC">

		<dataSource type="SIMPLE">
			<property name="JDBC.Driver"
				value="oracle.jdbc.driver.OracleDriver" />
			<property name="JDBC.ConnectionURL"
				value="jdbc:oracle:thin:@192.168.0.35:1521:orcl" />
			<property name="JDBC.Username"  value="scott" />
			<property name="JDBC.Password"	value="tiger" />
			<property name="Pool.MaxmumActiveConnections" value="10"/>
			<property name="Pool.MaxmumIdleConnections" value="5"/>
			<property name="Pool.MaxmumCheckoutTime" value="120000"/>
			<property name="Pool.TimeToWait" value="500" />
			<property name="Pool.PingQuery"" value="select 1 from ACCOUNT" />
			<property name="Pool.PingEnabled" value="false" />
			<property name="Pool.PingConnectionsOlderThan" value= "1" />
			<property name="Pool.PingConnectionsNotUsedFor" value= "1" />
		</dataSource>
	</transactionManager>
	<sqlMap resource="com/ibatis/sample/sqlMapConfig.xml" />
</sqlMapConfig>

sqlMap 文件：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Dept">
	<typeAlias alias="dept" type="com.ibatis.sample.Dept" />
	<select id="getDept" parameterClass="java.lang.Long" resultClass="com.ibatis.sample.Dept">
		<![CDATA[select dname, loc from Dept where deptno = #deptno# ]]>
	</select>
	<update id="updateDept" parameterClass="com.ibatis.sample.Dept">
		<![CDATA[update Dept set dname=#dname#, loc=#loc# where deptno = #deptno# ]]>
	</update>
	<insert id="insertDept" parameterClass="com.ibatis.sample.Dept">
		insert into Dept ( dname, loc) values ( #dname#, #loc# )
	</insert>
	<delete id="deleteDept" parameterClass="java.lang.Long">
		delete from Dept where deptno = #deptno#
	</delete>
</sqlMap>

最后老提示：
com.ibatis.sqlmap.client.SqlMapException: There is no statement named insertDept in this SqlMap.
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:231)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:367)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:86)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:62)
at com.ibatis.sample.Test.insertTest(Test.java:22)
at com.ibatis.sample.Test.main(Test.java:38)
问题补充：
写上“d”，还是一样的异常

There is no statement named insertDept in this SqlMap.

iBATIS

2008年11月07日 11:27

tockychen
6
0 0 0

3个答案按时间排序按投票排序

0 0

采纳的答案

代码中:

String str = "./com/ibatis/sample/sqlMapConfig.xml";

数据库配置文件中:

<sqlMap resource="com/ibatis/sample/sqlMapConfig.xml" />

这两个文件怎么是一样的, 你的代码中的应该是你的数据库配置文件的路径吧!

2008年11月07日 12:02

小疯子
1111
0 0 0

添加评论

0 0

请确认你的

String str = "./com/ibatis/sample/sqlMapConfig.xml";

路径是正确的！试着改为

String str = "com/ibatis/sample/sqlMapConfig.xml";

2008年11月07日 11:57

tangjunchf
40
0 0 0

添加评论

0 0

//smc.startTransaction();  
             Dept d = new Dept();  
             d.setDname("aaaa");  
             d.setLoc("bbbb");  
             smc.insert("insertDept", d); //掉了参数  
             System.out.print(d.getDname());  
             //smc.commitTransaction();

掉了参数d

2008年11月07日 11:33

小疯子
1111
0 0 0

添加评论

已解决问题

未解决问题

排行榜

查看全部排名>>