ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: Ibatis goes to New york?
Date Mon, 25 Sep 2006 01:58:16 GMT
Hi there,

I don't have any plans.  But I just did my iBATIS/Ajax demo in a talk at
NFJS yesterday.  It is pretty cool.  I may put together a more complete
example to publish somewhere.  I'd be interested in knowing if people would
considering building apps this way...

Think just JavaScript + iBATIS.

Clinton

On 9/24/06, levan Dvalishvili <admin@amostudio.com> wrote:
>
>  Hi Clinton,  I saw list of events on the website, is there any plans
> visiting New York, in near  future,monthly meetings of  www.*nyjavasig*
> .com/would be good place to give speech, "Ibatis Does AjAX presentation "
> would be a bliss. (please J )
>
>
>
>
>
> *From:* nando.dev [mailto:nando.dev@gmail.com]
> *Sent:* Saturday, September 23, 2006 3:41 PM
> *To:* user-java@ibatis.apache.org
> *Subject:* Re: question with boolean types..
>
>
>
> Hi Esperanza, the problem do you have is the type boolean of pl/sql isn´t
> standard of JDBC, so do you have to write a wrapper to this function.
>
> 2006/6/26, Esperanza.Echeverria@steria.es <Esperanza.Echeverria@steria.es
> >:
>
>
> please, can anyone help me?
> my problem is calling a stored procedure in ibatis and this functioncalled in pl/sql
returns a boolean and i don´t know what are the correct
> types in this case to be put in for no obtain an error ...
>
> <parameterMap id="misParametros" class="java.util.HashMap" >
>     <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> java.lang.Boolean" mode="OUT"/>
>     <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> java.lang.String" mode="IN"/>
>     <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> java.lang.String" mode="IN"/>
>     <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> java.lang.String" mode="IN"/>
>     <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> java.lang.String" mode="IN"/>
>   </parameterMap>
>  <procedure id="ejecutaTieneDuplicados" parameterMap="misParametros" >
>     {? = call report.tiene_duplicados(?,?,?,?)}
>   </procedure>
>
> the out parameter tells me an error :
> DEBUG - {conn-100021} Connection
> DEBUG - {pstm-100022} PreparedStatement: {? = call report.tiene_duplicados
> (?,?,?,?)}
> DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep, VCENTRO=90101,
> 19-06-2006]
> DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> java.lang.String, java.lang.String]
> DEBUG - Initializing, config='org.apache.struts.action.LocalStrings',
> returnNull=true
> 06/06/26 08:47:37 DaoException
> ERROR - Ha ocurrido un error con la base de datos
> com.ibatis.dao.client.DaoException: Failed to execute queryForObject - id
> [ejecutaTieneDuplicados], parameterObject [{parametro4=VCENTRO=90101,
> parametro2=JOSELUIS, parametro3=sip97.rep , parametro1=true,
> parametro5=19-06-2006}].  Cause:
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in
> com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> --- The error occurred while applying a parameter map.
> --- Check the Lis.misParametros.
> --- Check the statement (update procedure failed).
> --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> PLS-00382: el tipo de la expresión no es correcto
> ORA-06550: línea 1, columna 7:
> PL/SQL: Statement ignored
>
>
>
>  *Esperanza Echeverría de Miguel*
> Steria España http://www.steria.es
> C/Menéndez y Pelayo,3 bis 46010 Valencia
> Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> esperanza.echeverria@steria.es
>
>
>
>
>
>
>
>
>

Mime
View raw message