ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff P <killingd...@hotmail.com>
Subject Re: parameterMap accesible from multiple sql maps not working
Date Sat, 17 Jan 2009 04:49:25 GMT

I seem to have stumbled across the answer thanks to Jeff Butler.

I changed the order the sqlMaps get loaded in the SQLMapConfig and that
solved it! However I have one more question. 

I got this error thrown at me: 
com.ibatis.sqlmap.client.SqlMapException: There is already a statement named
countUnsyncedByDate in this SqlMap.

When I renamed the id of one of the <select></select>-operation to something
else this error was not thrown. I assumed names are always local to the SQL
Map XML file. Is this not the case for database operations (select, update,
delete etc.)?


Jeff P wrote:
> The manuals says this:
> "Note! Parameter Map names are always local to the SQL Map XML file that
> they are defined in. You can
> refer to a Parameter Map in another SQL Map XML file by prefixing the id
> of the Parameter Map with the
> id of the SQL Map (set in the <sqlMap> root tag). For example, to refer to
> the above parameter map from a
> different file, the full name to reference would be
> “Product.insert-product-param”."
> how come this:
> sqlMap file #1:
> <sqlMap namespace="TableType" >
>     <parameterMap id="SyncDatesMap" class="SyncDates" >
>         <parameter property="oldSyncDate" jdbcType="TIMESTAMP"
> javaType="Date" />
>         <parameter property="currentSyncDate" jdbcType="TIMESTAMP"
> javaType="Date" />
>     </parameterMap>
> </sqlMap>
> sqlMap file #2:
> <sqlMap namespace="ColumnGroup" >
>     <select id="countUnsyncedByDate" parameterMap="TableType.SyncDatesMap"
> resultClass="Integer">
> query here
>     </select>
> </sqlMap>
> gives me this exception:
> com.ibatis.sqlmap.client.SqlMapException: There is no parameter map named
> TableType.SyncDatesMap in this SqlMap.
> How can I tell iBatis to look in sqlMap with namespace "TableType" rather
> than staying in "ColumnGroup"?
> Thanks in advance

View this message in context: http://www.nabble.com/parameterMap-accesible-from-multiple-sql-maps-not-working-tp21513021p21513121.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

View raw message