ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Butler <jeffgbut...@gmail.com>
Subject Re: iBATOR+iBATIS generation is successful, but test does not work.
Date Thu, 20 Aug 2009 15:00:13 GMT
You need to enable statement namespaces. See here for an example:

http://ibatis.apache.org/docs/tools/ibator/afterRunning.html

Jeff Butler


On Thu, Aug 20, 2009 at 3:04 AM, bhaa<bhaa@yandex.ru> wrote:
>
> Hi,
>
> This is file ibatorConfig.xml:
>
> <?xml version="1.0" encoding="UTF-8" ?>
> <!DOCTYPE ibatorConfiguration PUBLIC "-//Apache Software Foundation//DTD
> Apache iBATIS Ibator Configuration 1.0//EN"
>  "http://ibatis.apache.org/dtd/ibator-config_1_0.dtd" >
> <ibatorConfiguration >
>  <classPathEntry
> location="F:\C\Work\RuNetSoft\GUVD\AccGuvd\lib\ojdbc14.jar" />
>  <ibatorContext id="OracleTables" targetRuntime="Ibatis2Java5">
>    <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
>      connectionURL="jdbc:oracle:thin:@ws-krylov:1521:GUVD"
>      userId="guvd_user" password="sys" />
>    <javaModelGenerator targetPackage="com.rns.guvd.model"
>      targetProject="AccGuvd/src" />
>    <sqlMapGenerator targetPackage="com.rns.guvd.xml"
>      targetProject="AccGuvd/src" />
>    <daoGenerator type="GENERIC-CI" targetPackage="com.rns.guvd.dao"
>      targetProject="AccGuvd\src" />
>    <table tableName="account_guvd">
>      <property name="useActualColumnNames" value="true"/>
>    </table>
>  </ibatorContext>
> </ibatorConfiguration>
>
> Generate iBATIS Artifacts is successful, but the test does not work:
>
> public static void main(String[] args) throws SQLException {
>                Reader reader = null;
>                try {
>                        reader =
> Resources.getResourceAsReader("com/rns/guvd/xml/ACCOUNT_GUVD_SqlMap.xml");
>                } catch (IOException e) {
>                        // TODO Auto-generated catch block
>                        e.printStackTrace();
>                }
>                SqlMapClient client = SqlMapClientBuilder.buildSqlMapClient (reader);
>                AccountGuvdDAO dao = new AccountGuvdDAOImpl(client);
>                AccountGuvd accountGuvd = dao.selectByPrimaryKey(new BigDecimal(1));
>                System.out.println("//--> " + accountGuvd.toString());
>        }
>
> Exception in thread "main" com.ibatis.sqlmap.client.SqlMapException: There
> is no statement named ACCOUNT_GUVD.ibatorgenerated_selectByPrimaryKey in
> this SqlMap.
>        at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:231)
>        at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:509)
>        at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
>        at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
>        at
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82)
>        at
> com.rns.guvd.dao.AccountGuvdDAOImpl.selectByPrimaryKey(AccountGuvdDAOImpl.java:106)
>        at com.rns.guvd.Test_AG.main(Test_AG.java:31)
>
> This is file generated ACCOUNT_GUVD_SqlMap.xml:
>
> <?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="ACCOUNT_GUVD" >
>  <resultMap id="ibatorgenerated_BaseResultMap"
> class="com.rns.guvd.model.AccountGuvd" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    <result column="ID_GUVD" property="ID_GUVD" jdbcType="DECIMAL" />
>    <result column="FIRST_NAME" property="FIRST_NAME" jdbcType="VARCHAR" />
>    <result column="LAST_NAME" property="LAST_NAME" jdbcType="VARCHAR" />
>    <result column="EMAIL" property="EMAIL" jdbcType="VARCHAR" />
>  </resultMap>
>  <sql id="ibatorgenerated_Example_Where_Clause" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    <iterate property="oredCriteria" conjunction="or" prepend="where"
> removeFirstPrepend="iterate" >
>      <isEqual property="oredCriteria[].valid" compareValue="true" >
>        (
>        <iterate prepend="and"
> property="oredCriteria[].criteriaWithoutValue" conjunction="and" >
>          $oredCriteria[].criteriaWithoutValue[]$
>        </iterate>
>        <iterate prepend="and"
> property="oredCriteria[].criteriaWithSingleValue" conjunction="and" >
>          $oredCriteria[].criteriaWithSingleValue[].condition$
>            #oredCriteria[].criteriaWithSingleValue[].value#
>        </iterate>
>        <iterate prepend="and"
> property="oredCriteria[].criteriaWithListValue" conjunction="and" >
>          $oredCriteria[].criteriaWithListValue[].condition$
>          <iterate property="oredCriteria[].criteriaWithListValue[].values"
> open="(" close=")" conjunction="," >
>            #oredCriteria[].criteriaWithListValue[].values[]#
>          </iterate>
>        </iterate>
>        <iterate prepend="and"
> property="oredCriteria[].criteriaWithBetweenValue" conjunction="and" >
>          $oredCriteria[].criteriaWithBetweenValue[].condition$
>          #oredCriteria[].criteriaWithBetweenValue[].values[0]# and
>          #oredCriteria[].criteriaWithBetweenValue[].values[1]#
>        </iterate>
>        )
>      </isEqual>
>    </iterate>
>  </sql>
>  <select id="ibatorgenerated_selectByExample"
> resultMap="ibatorgenerated_BaseResultMap"
> parameterClass="com.rns.guvd.model.AccountGuvdExample" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    select ID_GUVD, FIRST_NAME, LAST_NAME, EMAIL
>    from ACCOUNT_GUVD
>    <isParameterPresent >
>      <include refid="ACCOUNT_GUVD.ibatorgenerated_Example_Where_Clause" />
>      <isNotNull property="orderByClause" >
>        order by $orderByClause$
>      </isNotNull>
>    </isParameterPresent>
>  </select>
>  <select id="ibatorgenerated_selectByPrimaryKey"
> resultMap="ibatorgenerated_BaseResultMap"
> parameterClass="com.rns.guvd.model.AccountGuvd" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    select ID_GUVD, FIRST_NAME, LAST_NAME, EMAIL
>    from ACCOUNT_GUVD
>    where ID_GUVD = #ID_GUVD:DECIMAL#
>  </select>
>  <delete id="ibatorgenerated_deleteByPrimaryKey"
> parameterClass="com.rns.guvd.model.AccountGuvd" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    delete from ACCOUNT_GUVD
>    where ID_GUVD = #ID_GUVD:DECIMAL#
>  </delete>
>  <delete id="ibatorgenerated_deleteByExample"
> parameterClass="com.rns.guvd.model.AccountGuvdExample" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    delete from ACCOUNT_GUVD
>    <include refid="ACCOUNT_GUVD.ibatorgenerated_Example_Where_Clause" />
>  </delete>
>  <insert id="ibatorgenerated_insert"
> parameterClass="com.rns.guvd.model.AccountGuvd" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    insert into ACCOUNT_GUVD (ID_GUVD, FIRST_NAME, LAST_NAME, EMAIL)
>    values (#ID_GUVD:DECIMAL#, #FIRST_NAME:VARCHAR#, #LAST_NAME:VARCHAR#,
> #EMAIL:VARCHAR#)
>  </insert>
>  <insert id="ibatorgenerated_insertSelective"
> parameterClass="com.rns.guvd.model.AccountGuvd" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    insert into ACCOUNT_GUVD
>    <dynamic prepend="(" >
>      <isNotNull prepend="," property="ID_GUVD" >
>        ID_GUVD
>      </isNotNull>
>      <isNotNull prepend="," property="FIRST_NAME" >
>        FIRST_NAME
>      </isNotNull>
>      <isNotNull prepend="," property="LAST_NAME" >
>        LAST_NAME
>      </isNotNull>
>      <isNotNull prepend="," property="EMAIL" >
>        EMAIL
>      </isNotNull>
>      )
>    </dynamic>
>    values
>    <dynamic prepend="(" >
>      <isNotNull prepend="," property="ID_GUVD" >
>        #ID_GUVD:DECIMAL#
>      </isNotNull>
>      <isNotNull prepend="," property="FIRST_NAME" >
>        #FIRST_NAME:VARCHAR#
>      </isNotNull>
>      <isNotNull prepend="," property="LAST_NAME" >
>        #LAST_NAME:VARCHAR#
>      </isNotNull>
>      <isNotNull prepend="," property="EMAIL" >
>        #EMAIL:VARCHAR#
>      </isNotNull>
>      )
>    </dynamic>
>  </insert>
>  <select id="ibatorgenerated_countByExample"
> parameterClass="com.rns.guvd.model.AccountGuvdExample"
> resultClass="java.lang.Integer" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    select count(*) from ACCOUNT_GUVD
>    <include refid="ACCOUNT_GUVD.ibatorgenerated_Example_Where_Clause" />
>  </select>
>  <update id="ibatorgenerated_updateByExampleSelective" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    update ACCOUNT_GUVD
>    <dynamic prepend="set" >
>      <isNotNull prepend="," property="record.ID_GUVD" >
>        ID_GUVD = #record.ID_GUVD:DECIMAL#
>      </isNotNull>
>      <isNotNull prepend="," property="record.FIRST_NAME" >
>        FIRST_NAME = #record.FIRST_NAME:VARCHAR#
>      </isNotNull>
>      <isNotNull prepend="," property="record.LAST_NAME" >
>        LAST_NAME = #record.LAST_NAME:VARCHAR#
>      </isNotNull>
>      <isNotNull prepend="," property="record.EMAIL" >
>        EMAIL = #record.EMAIL:VARCHAR#
>      </isNotNull>
>    </dynamic>
>    <isParameterPresent >
>      <include refid="ACCOUNT_GUVD.ibatorgenerated_Example_Where_Clause" />
>    </isParameterPresent>
>  </update>
>  <update id="ibatorgenerated_updateByExample" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    update ACCOUNT_GUVD
>    set ID_GUVD = #record.ID_GUVD:DECIMAL#,
>      FIRST_NAME = #record.FIRST_NAME:VARCHAR#,
>      LAST_NAME = #record.LAST_NAME:VARCHAR#,
>      EMAIL = #record.EMAIL:VARCHAR#
>    <isParameterPresent >
>      <include refid="ACCOUNT_GUVD.ibatorgenerated_Example_Where_Clause" />
>    </isParameterPresent>
>  </update>
>  <update id="ibatorgenerated_updateByPrimaryKeySelective"
> parameterClass="com.rns.guvd.model.AccountGuvd" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    update ACCOUNT_GUVD
>    <dynamic prepend="set" >
>      <isNotNull prepend="," property="FIRST_NAME" >
>        FIRST_NAME = #FIRST_NAME:VARCHAR#
>      </isNotNull>
>      <isNotNull prepend="," property="LAST_NAME" >
>        LAST_NAME = #LAST_NAME:VARCHAR#
>      </isNotNull>
>      <isNotNull prepend="," property="EMAIL" >
>        EMAIL = #EMAIL:VARCHAR#
>      </isNotNull>
>    </dynamic>
>    where ID_GUVD = #ID_GUVD:DECIMAL#
>  </update>
>  <update id="ibatorgenerated_updateByPrimaryKey"
> parameterClass="com.rns.guvd.model.AccountGuvd" >
>    <!--
>      WARNING - This element is automatically generated by Apache iBATIS
> ibator, do not modify.
>      This element was generated on Thu Aug 20 11:30:09 MSD 2009.
>    -->
>    update ACCOUNT_GUVD
>    set FIRST_NAME = #FIRST_NAME:VARCHAR#,
>      LAST_NAME = #LAST_NAME:VARCHAR#,
>      EMAIL = #EMAIL:VARCHAR#
>    where ID_GUVD = #ID_GUVD:DECIMAL#
>  </update>
> </sqlMap>
>
> Explain please why it does not work.
>
> Alexander
>
> --
> View this message in context: http://www.nabble.com/iBATOR%2BiBATIS-generation-is-successful%2C-but-test-does-not-work.-tp25057730p25057730.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message