Hey Samuel
I have the same problem happening in stored procs though.
Specifying a null value in the xml for an "IN Parameter" doesnt help too.
The only way out that I was able to find was to add this to the input map
with a default value. Example if the property is of type String, I had to
initialize it to "".
Your code would be
inputMap.put(property,"");
UGLY CODING IMO. Was the only way out though :)
I am not sure if this is a bug in Ibatis.
-Sundar
On Fri, Jul 25, 2008 at 6:57 AM, samuel gallard <[EMAIL PROTECTED]>
wrote:
> hello, I am facing an issue concerning Ibatis. I need to make a request on
> one table. Four of her columns can be nullable. When i use netBeans and
> Java, my request woks fine. But when I use BpmRule ( a tool from Absyss
> society), i obtained this error message: The error occurred in
> xml/Capacite/maps/Infrastructure.xml. --- The error occurred while applying
> a parameter map. --- Check the DerniereDate3-InlineParameterMap. --- Check
> the parameter mapping for the 'equipement' property. --- Cause:
> java.sql.SQLException: Invalid column type It happens at *#equipement# *in
> the following xml : equipement is one of the column that could be
> nullable. I use a Hashtable to put all my arguments. It is the same for all
> my arguments. It doesn't seem to have a correct type to map with his column
> type. Instead of #equipement#, if i use *#equipement:VARCHAR# *, i don't
> obtain this error. The problem is all my arguments are null and so the
> request failed. I read everything about this problem on the Ibatis Wiki
> concerning the Insert request but i can't do the same with select. In some
> way i don't know, my tool BPMRule doesn't permit the column type as Java
> does by itself. Maybe i need to force the type of all arguments to map with
> the columns type but i don't know how to make it. I use Ibatis version
> 2.3.0.677. Could you help me for this issue? I would appreciate it. Samuel
> Gallard
> ------------------------------
> View this message in context: Invalid column type in select
> request<http://www.nabble.com/Invalid-column-type-in-select-request-tp18652243p18652243.html>
> Sent from the iBATIS - User - Java mailing list
> archive<http://www.nabble.com/iBATIS---User---Java-f370.html>at Nabble.com.
>
