ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "levan Dvalishvili" <ad...@amostudio.com>
Subject Ibatis goes to New york?
Date Mon, 25 Sep 2006 00:31:41 GMT
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 function called
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 <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