ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <nathan.ma...@gmail.com>
Subject Re: IBatis + Stored Procedures
Date Tue, 08 Sep 2009 18:32:44 GMT
any chance you also have the logging output where the sql generated by
ibatis?

On Tue, Sep 8, 2009 at 8:36 AM, jimmymac <james.mcguigan@sungardps.com>wrote:

>
> It's choking on the lastname value being read off a magnetic strip. Here is
> the relevant portion of the map
> Here is the parameter map:
>  <parameterMap class="com.sps.dao.ibatis.DataWrapper"
> id="SwipedCreditCard_procedureMap">
> ......
>      <parameter property="data.name.firstName" mode="IN"
> javaType="java.lang.String" jdbcType="VARCHAR"/>
>      <parameter property="data.name.lastName" mode="IN"
> javaType="java.lang.String" jdbcType="VARCHAR"/>
>      <parameter property="data.name.middleInitial" mode="IN"
> javaType="java.lang.String" jdbcType="VARCHAR"/>
> .......
> </parameterMap>
>
>
>
>
> And the exception:
>
> [2009-09-03 13:20:28,502] [http-80-Processor25] [ERROR] -
> [IBatisStoredProcDAO.insert] [failed to insert record for class
> com.hteinc.op.services.types.SwipedCreditCard]
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in com/op/services/types/SwipedCreditCard.xml.
> --- The error occurred while applying a parameter map.
> --- Check the SwipedCreditCard.SwipedCreditCard_procedureMap.
> --- Check the statement (update procedure failed).
> --- Cause: java.sql.SQLException: [SQL0104] Token 'O' was not valid. Valid
> tokens: (.
>        at
>
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
>        at
>
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
>        at
>
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
>        at
>
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:59)
>
> Thanks for looking.
>
>
>
> nmaves wrote:
> >
> > Post your parameter map and the actual exception you are getting.
> >
> > On Tue, Sep 8, 2009 at 7:59 AM, jimmymac
> > <james.mcguigan@sungardps.com>wrote:
> >
> >>
> >> I seem to be having an issue with mapping and stored procedures. I'm
> >> passing
> >> in a value " O'Malley ". Shouldn't the use of  a prepared statement
> >> handle
> >> the apostrophe? The API is returning a message of invalid character O'
> >> from
> >> the DB2 database.
> >>
> >> [code]
> >>  <procedure id="SwipedCreditCard_insert"
> >> parameterMap="SwipedCreditCard_procedureMap">
> >>     {call ${sp.lib}.KLSCCAPI(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?,
> >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,  ?, ?, ?, ?, ?)}
> >>   </procedure>
> >>  [/code]
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/IBatis-%2B-Stored-Procedures-tp25346833p25346833.html
> >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> >> For additional commands, e-mail: user-java-help@ibatis.apache.org
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/IBatis-%2B-Stored-Procedures-tp25346833p25347487.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message