初学ibatis 学习笔记一

这两天开始看ibatis,从最简单的开始

关于错误一

java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: org.xml.sax.SAXParseException: Document root element "sqlMapConfig", must match DOCTYPE root "sqlMap".
 at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:49)
 at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:63)
 at com.fl.ibatis.dao.dbhepler.<clinit>(dbhepler.java:11)
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: org.xml.sax.SAXParseException: Document root element "sqlMapConfig", must match DOCTYPE root "sqlMap".
 at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:53)
 at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:46)
 ... 2 more
Caused by: org.xml.sax.SAXParseException: Document root element "sqlMapConfig", must match DOCTYPE root "sqlMap".
 at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
 at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:172)
 at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:382)
 at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
 at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.rootElementSpecified(XMLDTDValidator.java:1652)
 at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(XMLDTDValidator.java:1931)
 at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:795)
 at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:878)
 at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDispatcher.scanRootElementHook(XMLDocumentScannerImpl.java:1157)
 at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1794)
 at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
 at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
 at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
 at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
 at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:250)
 at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:292)
 at com.ibatis.common.xml.NodeletParser.createDocument(NodeletParser.java:157)
 at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:50)
 ... 3 more

导致该错误的原因：sqlmappingconfig.xml中

<!DOCTYPE sqlMap
  PUBLIC "-//ibatis.apache.org//DTD SQL Map  2.0//EN"  
  "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

改为

<!DOCTYPE sqlMapConfig
  PUBLIC "-//ibatis.apache.org//DTD SQL Map  Config 2.0//EN"  
  "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

1、注意这些配置文件有模板的，为了避免错误直接copy一个就ok了。 

2、如果配置文件放在根目录下

             则<properties resource="sqlmapping.properties"/>直接写文件名，否则要加包名

                <sqlMap resource="pet.xml"/>

错误二纯粹是手误

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: java.lang.RuntimeException: Error parsing XPath '/sqlMap/select'.  Cause: com.ibatis.sqlmap.client.SqlMapException: Error.  Could not initialize class.  Cause: java.lang.ClassNotFoundException: com.fl.ibatis.pet
 at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:49)
 at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:63)
 at com.fl.ibatis.dao.dbhepler.<clinit>(dbhepler.java:11)
Caused by: 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: java.lang.RuntimeException: Error parsing XPath '/sqlMap/select'.  Cause: com.ibatis.sqlmap.client.SqlMapException: Error.  Could not initialize class.  Cause: java.lang.ClassNotFoundException: com.fl.ibatis.pet
 at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:53)
 at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:46)
 ... 2 more
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/select'.  Cause: com.ibatis.sqlmap.client.SqlMapException: Error.  Could not initialize class.  Cause: java.lang.ClassNotFoundException: com.fl.ibatis.pet
 at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)
 at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)
 at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
 at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
 at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:51)
 ... 3 more
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/select'.  Cause: com.ibatis.sqlmap.client.SqlMapException: Error.  Could not initialize class.  Cause: java.lang.ClassNotFoundException: com.fl.ibatis.pet

......

在pet.xml中

<typeAlias alias="pet" type="com.fl.ibatis.entity.pet"/>

type=""一定不要写错。。。。。。