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 Edwin Lukaweski <se...@rogers.com> on 2006/01/24 19:29:44 UTC

name space

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





Re: name space

Posted by Edwin Lukaweski <se...@rogers.com>.
Tremendous....I thought it might be something simple.

Thanks,
Edwin

  ----- Original Message ----- 
  From: Jeff Butler 
  To: user-java@ibatis.apache.org 
  Sent: Tuesday, January 24, 2006 2:49 PM
  Subject: Re: name space


  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 <se...@rogers.com> wrote: 
    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 "> 
    <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 Begin 
      To: user-java@ibatis.apache.org 
      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 <serjann@rogers.com > 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









Re: name space

Posted by Jeff Butler <je...@gmail.com>.
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 <se...@rogers.com> wrote:
>
> 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">
>
> <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 Begin <cl...@gmail.com>
> *To:* user-java@ibatis.apache.org
> *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 <se...@rogers.com> 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
> >
> >
> >
> >
> >
>
>

Re: name space

Posted by Edwin Lukaweski <se...@rogers.com>.
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">

<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 Begin 
  To: user-java@ibatis.apache.org 
  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 <se...@rogers.com> 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







Re: name space

Posted by Clinton Begin <cl...@gmail.com>.
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 <se...@rogers.com> 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
>
>
>
>
>