Paasing a map as parameterType

[YamilBracho]

Hi
I have this SELECT in my map file

<mapper namespace="MySpace">
<select id="findById"
parameterType="java.util.Map"
resultType="com.mycompany.Person">
SELECT "
FROM PersonTable
WHERE nat= = #{citizenship}#
AND id = #{id}#
</select>
</mapper>

In my java code I have

Map<String, String> parameters = new HashMap<String, String>(2);
parameters.put("citizenship", "French");
parameters.put("iod", "123456");
Person = (person) session.selectOne("MySpace.findById", parameters);

I am using PostgreSQL and i am getting this exception:

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause:
org.postgresql.util.PSQLException: ERROR: operator does not exist:
character varying #
Hint: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
Position: 1072
### The error may involve MySpace.findById-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: ERROR: operator does not
exist: character varying #
Hint: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
Position: 1072
at
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:
8)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:
61)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:
53)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:
38)
at
com.mls.ean.servicios.ServiciosServlet.getDiputadoByCedula(ServiciosServlet.java:
78)

Any Hint ?

TIA

[Larry Meadors]

Is this a typo in your email or your sql map?

WHERE nat= = #{citizenship}#

The "= ="?

Larry

[Larry Meadors]

Also, it's just #{}, not #{}#.

[YamilBracho]

My Mistake!!!!!!

I wrote "#{citizenship}#" instead of "#{citizenship}"

Maybe my glasses are not working properly or I really need a
vacation...!

Thanks

[Larry Meadors]

I vote for the vacation. :)

[YamilBracho]

Thanks Larry
I will change my glasses and of course take a vacation...!