Hi Jeremy, you would also need something like <sql id="UTILISATEUR.abatorgenerated_Example_Where_Clause"> ##SQL here## </sql> in the sqlmap.
Torsten -------- Original-Nachricht -------- Datum: Wed, 21 Jun 2006 11:30:31 +0200 Von: jeremy jardin <[EMAIL PROTECTED]> An: user-java@ibatis.apache.org Betreff: RE : sql-map-config pb > Thx all right ! > > But now, I have another pb parsing sqlmap file : > could not find SQL statement to include with refid > 'UTILISATEUR.abatorgenerated_Example_Where_Clause' > > I checked my sql-map.xml config file (generated using Abator), and I found > that : > <include refid="UTILISATEUR.abatorgenerated_Example_Where_Clause"/> > > So, I don't understand what's the matter with that file !! > > > Thx ! > > > -----Message d'origine----- > De : Rashmi Dixit [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 21 juin 2006 11:18 > À : user-java@ibatis.apache.org > Objet : RE: sql-map-config pb > > You need to correct the DOCTYPE entry at the beginning of your file. > > <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config > 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd";> > > ~Rashmi > ________________________________________ > From: jeremy jardin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 21, 2006 2:42 PM > To: user-java@ibatis.apache.org > Subject: sql-map-config pb > > Hello, > > I'm first time using Ibatis, and I have a problem with the > sql-map-config.xml file. > > I write it like that : > > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE sql-map-config PUBLIC "-//iBATIS.com > //DTD SQL Map Config 1.0//EN" > "http://ibatis.apache.org/dtd/sql-map-config-2.dtd";> > > <sqlMapConfig> > <transactionManager type="JDBC" commitRequired="true"> > > <property name="DefaultAutoCommit" value="false"/> > <property name="SetAutoCommitAllowed" value="false"/> > > <dataSource type="simple"> > <property name="JDBC.Driver" > value="oracle.jdbc.driver.OracleDriver"/> > <property name="JDBC.ConnectionURL" > > value="jdbc:oracle:thin:@srvappld4.architect.newtec.dom:1521:xe"/> > <property name="JDBC.Username" value=""/> > <property name="JDBC.Password" value=""/> > </dataSource> > </transactionManager> > > <sqlMap resource="UTILISATEUR_SqlMap.xml"/> > </sqlMapConfig> > > > It seems to be ok, but I have that exception : > org.xml.sax.SAXParseException: Document root element "sqlMapConfig", > must match DOCTYPE root "sql-map-config". > > I don't understand why ?? > > Thx -- Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
