Re: name space

Edwin Lukaweski Tue, 24 Jan 2006 11:29:08 -0800

Thank you for the response.

However, I get the same error when I fixed the DTD, so here it is again

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.apache.org/DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">

........

<select id="abatorgenerated_selectByPrimaryKey" resultMap="abatorgenerated_GroupResult" parameterClass="com.rigci.addamsub.persistence.ibatis.model.GroupKey">
    

    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 Begin

To: [email protected]

Sent: Tuesday, January 24, 2006 1:33 PM

Subject: Re: name space

This 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">
    

    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

Re: name space

Reply via email to