Mapped Statements collection does not contain value : while giving multiple database support
===

our mapper was running cool with mysql db.
We now trying to give support to oracle support for this.


we configure databaseIdProvider in our mybatis config file.

as

    <databaseIdProvider type="VENDOR">
    		 <property name="MYSQL" value="MYSQL"/>        
      		<property name="ORACLE" value="ORACLE" />
    	</databaseIdProvider>

Now we done following changes in our mapper xml file as follows:

    <select id="zipDetailsByCodeAndCounty" resultType="java.util.HashMap" parameterType="map" databaseId="Oracle">
    		SELECT state_code, code, county, city, lat, lon
    		from zip_codes where code = #{code} 
    		<if test = "county != null and county != ''">
    			and county=	#{county}
    		</if>
    		and rownum = 1
    	</select>
    	
    	<select id="zipDetailsByCodeAndCounty" resultType="java.util.HashMap" parameterType="map" databaseId="Mysql">
    		SELECT state_code, code, county, city, lat, lon
    		from zip_codes where code = #{code} 
    		<if test = "county != null and county != ''">
    			and county=	#{county}
    		</if>
    		limit 1
    							
    	</select>

It is giving exception as 



    Caused by: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.test.dataaccess.MetaMapper.zipDetailsByCodeAndCounty
    	at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:672)
    	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:507)
    	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:500)
    	at org.apache.ibatis.binding.MapperMethod.setupCommandType(MapperMethod.java:240)
    	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:71)
    	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:39)
    	at $Proxy72.zipDetailsByCodeAndCounty(Unknown Source)



i done google alot but unable to find useful resource. Please help me out on same.

we are using mbatis version : 3.1.1