You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by jeremy jardin <je...@newtec.caisse-epargne.fr> on 2006/06/21 11:30:31 UTC
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:rashmid@gmail.com]
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:jeremy.jardin@newtec.caisse-epargne.fr]
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
Re: RE : sql-map-config pb
Posted by Torsten Michelmann <to...@gmx.de>.
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 <je...@newtec.caisse-epargne.fr>
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:rashmid@gmail.com]
> 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:jeremy.jardin@newtec.caisse-epargne.fr]
> 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
RE: sql-map-config pb
Posted by Rashmi Dixit <ra...@gmail.com>.
I guess this is because your in your settings usenamespaces is not
enabled causing ABATOR generated sql maps to fail.
Add this to your sqlmapconfig.xml
<settings useStatementNamespaces="true" />
Hope this helps!
~Rashmi
-----Original Message-----
From: jeremy jardin [mailto:jeremy.jardin@newtec.caisse-epargne.fr]
Sent: Wednesday, June 21, 2006 3:01 PM
To: user-java@ibatis.apache.org
Subject: 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:rashmid@gmail.com]
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:jeremy.jardin@newtec.caisse-epargne.fr]
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