URGENT ::: Caused by: java.lang.NoSuchMethodError: oracle.sql.STRUCT.toClass(Ljava/lang/Class;Ljava/util/Map;)Ljava/lang/Object;

2006-07-13 Thread chaithanya ibatis
Hi,I'm getting this error:using userdefined type in procedure.  in that type, the datatypes are  number(12,2), varchar2, number. In the dto ,i declared BigDecimal for number(12,2),when i read  using readBigDecimal . will this creates this problem or any thing else. pls give me solution. i have used

Cause: java.sql.SQLException: invalid name pattern: LXDV.T_FIN_DETAILS_TYPE; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException :

2006-07-13 Thread chaithanya ibatis
HI,    when i use a Type (userdefined) in oracle as OUT parmaters in procedure. i have got this problem. can any one tell me what is the exact cause for these.i have these type defined outside the package. and procedure is also in outside package. what is the reason for this error..and how can

URGENT Cause: java.sql.SQLException: invalid name pattern: LXDV.T_FIN_DETAILS_TYPE

2006-07-13 Thread chaithanya ibatis
HI,    when i use a Type (userdefined) in oracle as OUT parmaters in procedure. i have got this problem. can any one tell me what is the exact cause for these.i have these type defined outside the package. and procedure is also in outside package. what is the reason for this error..and how can

using typeHandler tag in sqlMapConfig.xml file

2006-07-11 Thread chaithanya ibatis
Hi,Can anyone tell me what dtd should i use for using the typeHandler tag in sqlMapConfig.xml filecurrently i'm using this which is not supporting typeHandler tag     PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"    "http://www.ibatis.com/dtd/sql-map-config-2.dtd">where do i get the dtd suppo

Re: HOW TO pass List of objects(a DTO) as single IN parameter to Stored Procedure

2006-07-11 Thread chaithanya ibatis
not possible?with or without ibatisOn 7/11/06, Beemsterboer Software <[EMAIL PROTECTED] > wrote: Hi, Passing a list of objects using a single input parameter? This is not even possible without iBatis. Greetings, Hans. chaithanya ibatis wrote: HI, I've been w

HOW TO pass List of objects(a DTO) as single IN parameter to Stored Procedure

2006-07-11 Thread chaithanya ibatis
HI,I've been working with Oracle DB and iBatisCan anyone tell me how to passList of objects(a DTO) as single IN parameter to Stored Procedure using iBatis for examplejava.util.List  list = new ArrayList(); SampleDTO obj1 = new SampleDTO();SampleDTO obj2 = new SampleDTO();list add(obj1);list add(obj

Re: pass List of objects as IN parameter to Stored Procedure

2006-07-11 Thread chaithanya ibatis
EjecSh(?)}     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 [EMAIL PROTECTED]     "chaithanya ibatis" <[EMAIL PROTECTED] > 11/07/2006 09:14 Please respond to user-jav

pass List of objects as IN parameter to Stored Procedure

2006-07-11 Thread chaithanya ibatis
HI,I've been working with Oracle DB and iBatisCan anyone tell me how to pass List of objects as IN parameter to Stored Procedure using iBatis (mapping required in SQL map files of ibatis)or any resources on this or code snippet Thanks,Chaithanya