求解Attribute "namespace" must be declared for element type "sqlMapConfig"
蜀中猿 2011-04-07 03:46:14 <?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/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="com.mysql.jdbc.Driver"/>
<property name="JDBC.ConnectionURL" value="jdbc:mysql://127.0.0.1/mydatabase"/>
<property name="JDBC.Username" value="root"/>
<property name="JDBC.Password" value="123456"/>
<property name="JDBC.DefaultAutoCommit" value="true"/>
<property name="Pool.MaximumActiveConnections" value="10"/>
<property name="Pool.MaximumIdleConnections" value="5"/>
<property name="Pool.MaximumCheckoutTime" value="180000"/>
<property name="Pool.TimeToWait" value="10000"/>
<property name="Pool.PingQuery" value="select 1 from dual"/>
<property name="Pool.PingEnabled" value="true"/>
<property name="Pool.PingConnectionsOlderThan" value="0"/>
<property name="Pool.PingConnectionsNotUsedFor" value="3600000"/>
<property name="Pool.QuietMode" value="true"/>
</dataSource>
</transactionManager>
<sqlMap resource="com/maesinfo/lxl/entity/User.xml"></sqlMap>
</sqlMapConfig>
-------------------------------------------------------------------------
<?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 namespace="User">
<typeAlias alias="user" type="com.maesinfo.lxl.entity.User"/>
<select id="getUser" parameterClass="java.lang.String" resultClass="user">
<![CDATA[
select name,sex from t_user where name=#name#
]]>
</select>
<update id="updateUser" parameterClass="user">
<![CDATA[
update t_user set name=#name#,sex=#sex# where id=#id#
]]>
</update>
<insert id="insertUser" parameterClass="user">
<![CDATA[
insert into t_user(name,sex) values(#name#,#sex#)
]]>
</insert>
<delete id="deleteUser" parameterClass="java.lang.String">
<![CDATA[
delete from t_user where id="#id"
]]>
</delete>
</sqlMapConfig>
------------------------------------------------------------------------------------
public static void main(String[] args) throws IOException, SQLException{
String resource="SqlMapConfig.xml";
Reader reader;
reader = Resources.getResourceAsReader(resource);
XmlSqlMapClientBuilder xmlBuilder = new XmlSqlMapClientBuilder();
SqlMapClient sqlMap = xmlBuilder.buildSqlMap(reader);
try {
sqlMap.startTransaction();
User user = new User();
user.setId(new Integer(1));
user.setName("zhangSan");
user.setSex(new Integer(0));
sqlMap.insert("User.insertUser", user);
sqlMap.commitTransaction();
} catch (Exception e) {
e.printStackTrace();
} finally{
sqlMap.endTransaction();
}
}
--------------------------------------------------------------------
运行报错:
Exception in thread "main" com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance.
--- The error occurred in com/maesinfo/lxl/entity/User.xml.
--- The error occurred while loading the SQL Map resource.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. Cause: org.xml.sax.SAXException: Error: URI=null Line=5: Attribute "namespace" must be declared for element type "sqlMapConfig".
Caused by: org.xml.sax.SAXException: Error: URI=null Line=5: Attribute "namespace" must be declared for element type "sqlMapConfig".
Caused by: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. Cause: org.xml.sax.SAXException: Error: URI=null Line=5: Attribute "namespace" must be declared for element type "sqlMapConfig".
Caused by: org.xml.sax.SAXException: Error: URI=null Line=5: Attribute "namespace" must be declared for element type "sqlMapConfig".
at com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap(XmlSqlMapClientBuilder.java:243)
我是新手,麻烦各位大哥看看,我该怎么配置才运行得出效果。