在线急等,谢谢帮忙!!!!
本人今天初次用ibatis做项目时,遇到以下异常:
java.lang.RuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Attribute "namespace" must be declared for element type "sqlMap".
两个文件如下:
(1)ibatis配置文件:
<?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>
<!-- Configure a built-in transaction manager. If you're using an
app server, you probably want to use its transaction manager
and a managed datasource
-->
<settings cacheModelsEnabled = "true" enhancementEnabled="true"
lazyLoadingEnabled = "true" errorTracingEnabled = "true"
maxRequests = "32" maxSessions = "10"
maxTransactions = "5" useStatementNamespaces = "false"
></settings>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<property name="JDBC.ConnectionURL" value="jdbc:sqlserver://localhost:1433;DataBaseName=addressBook"/>
<property name="JDBC.Username" value="sa"/>
<property name="JDBC.Password" value="sa"/>
</dataSource>
</transactionManager>
<!-- List the SQL Map XML files. They can be loaded from the
classpath, as they are here (com.domain.data...) -->
<sqlMap resource="config/User.xml"></sqlMap>
</sqlMapConfig>
(2)映射文件:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMap namespace="Users">
<typeAlias alias = "user" type="entity.Users"></typeAlias>
<select id="getUserByName"
parameterClass="java.lang.String"
resultClass="user">
<![CDATA[select username,password from users where username=#name#]]>
</select>
</sqlMap>
请各位高手帮忙看看!!