Thank you for the response.However, I get the same error when I fixed the DTD, so here it is againHi:I seem to be having a problem with the name space facility.I get the following exception:"There is no statement named ADDAM_GROUP.abatorgenerated_selectByPrimaryKey in this SqlMap."The XML map snippet is:<?xml version="1.0" encoding="UTF-8"?>
<!
DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org/DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd "><sqlMap namespace="ADDAM_GROUP">
........
<select id="abatorgenerated_selectByPrimaryKey" resultMap="abatorgenerated_GroupResult" parameterClass="com.rigci.addamsub.persistence.ibatis.model.GroupKey">
<!--
WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
This element was generated on Thu Jan 19 17:27:04 EST 2006.
-->
select GROUPOID,
GROUPCODE,
GROUPDESCRIPTION,
MODIFICATIONDATE
from ADDAM.GROUP
where GROUPOID = #ID#
</select>
and the call, within the DAO java class is:
public Group selectByPrimaryKey(GroupKey key) {
Group record = (Group) queryForObject("ADDAM_GROUP.abatorgenerated_selectByPrimaryKey", key);
return record;
}
Any help would be appreciated,
Edwin
----- Original Message -----From: Clinton BeginSent: Tuesday, January 24, 2006 1:33 PMSubject: Re: name spaceThis is the second account of the same problem....
Your DTD is messed up. Please refer to the ibatis.apache.org homepage for the proper doctypes.
Cheers,
Clinton
On 1/24/06, Edwin Lukaweski <[EMAIL PROTECTED] > wrote:Hi:I seem to be having a problem with the name space facility.I get the following exception:"There is no statement named ADDAM_GROUP.abatorgenerated_selectByPrimaryKey in this SqlMap."The XML map snippet is:<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" " http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap namespace="ADDAM_GROUP">
........
<select id="abatorgenerated_selectByPrimaryKey" resultMap="abatorgenerated_GroupResult" parameterClass="com.rigci.addamsub.persistence.ibatis.model.GroupKey">
<!--
WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
This element was generated on Thu Jan 19 17:27:04 EST 2006.
-->
select GROUPOID,
GROUPCODE,
GROUPDESCRIPTION,
MODIFICATIONDATE
from ADDAM.GROUP
where GROUPOID = #ID#
</select>
and the call, within the DAO java class is:
public Group selectByPrimaryKey(GroupKey key) {
Group record = (Group) queryForObject("ADDAM_GROUP.abatorgenerated_selectByPrimaryKey", key);
return record;
}
Any help would be appreciated,
Edwin
You need to make sure that you enable statement namespaces in your sqlmapconfig file.
<sqlMapConfig>
<settings useStatementNamespaces="true"/>
...
</sqlMapConfig>
Jeff Butler
On 1/24/06, Edwin Lukaweski <[EMAIL PROTECTED]> wrote:
- name space Edwin Lukaweski
- Re: name space Clinton Begin
- Re: name space Edwin Lukaweski
- Re: name space Jeff Butler
- Re: name space Edwin Lukaweski
