Hello,
The following is the scenario
1. I have a SQLMapConfig.xml which contains 2 sqlmap declarations. E.g.
<....
<sqlMap resource="Dimension.xml" />
<sqlMap resource="Hierarchy.xml" />
>
2. In each of the SQLMap xml's I have some select declarations
<sqlMap namespace="DimensionQuery">
<select id="getId" resultClass="mypackage.Dimension">
select dim_id as dimId from dim_table where dim_nm = #value#
</select>
</sqlMap>
<sqlMap namespace="HierarchyQuery">
<select id="getId" resultClass="mypackage.Hierarchy">
select hier_id as hierId from hier_table where hier_ds = #value#
</select>
</sqlMap>
Here please note that I have the same Id (getId) in both the sql map
declarations.
Here is my question.
Is it possible to reuse the same id's across sqlmap xml's.
I will appreciate if someone can help me here on this
Rgds,
Rajeev Dave