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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
