How to not verbosely declare resultmaps?

Dear All, I've been using ibatis for about 1 year now, and i'm very satisfied with it! I wanted to ask if i can do this: select id=elions.uw.selectInfoProductInsured resultClass=map SELECT name, age, address, income FROM person /select but I wanted the default datatype for NAME is String, AGE

RE: [ABATOR] Future Plans

. SQL DROP VIEW v_temp; View dropped. SQL Yusuf. -Original Message- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 20, 2005 8:40 PM To: user-java@ibatis.apache.org Subject: Re: [ABATOR] Future Plans Thanks for your suggestion! Abator does not support this now

Ref Cursor Support in iBatis

Hello, I was wondering about the support for ref cursors in ibatis, and i stumbled upon this in the ibatis wiki page (http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Oracle+R EF+CURSOR+Solutions): sqlMap typeAlias alias=Employee type=test.Employee / resultMap

iBatis usage pattern

how do people used to map their results. Yusuf

RE: iBatis usage pattern

' functionalities, but never mess with the domain model. Is it correct? If I'm not wrong, this is also the concept of all those ORM tools like hibernate, jdo, and others? Thanks, Yusuf. -Original Message- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Saturday, January 21, 2006 6:10 AM

Different Number of Columns in resultClass with xml and with HashMap

you for your help and regards, Yusuf S.

RE: dynamic insert question

Hi, Does the PartVO object have a property named domain and it's a list or an array? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 1:33 PM To: user-java@ibatis.apache.org Subject: dynamic insert question Dear all, I want insert

RE: dynamic insert question

$,partnum,parttype,'N' from cto.partinfo where .. And I will input one parameter like '8848' (or others) to family. What's solution for it? Thanks Steven On 2/7/06, Yusuf [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi, Does the PartVO object have a property named domain and it's

RE: dynamic insert question

oops I'm sorry, didnt see that.. Yusuf S. -Original Message- From: Meindert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 3:22 PM To: user-java@ibatis.apache.org Subject: RE: dynamic insert question He already said that ## didn't work (because it is a select

RE: Different Number of Columns in resultClass with xml and with HashMap

the results to a Map or a class, then the result is correct (10 columns) - if i use resultMap=xml, then the result is only 8 columns (without the 2 which contains another select) have anyone experienced this before? or a bug? Thanks, Yusuf. -Original Message- From: Yusuf Sent: Tuesday

RE: Cache

] [java.sql.ResultSet:65] - {rset-100011} Result: [a, b, c] but i'm pretty sure some time ago (dont know the exact version, but an older one) i successfully used the caching feature.. Thanks, Yusuf. -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 11:07

RE: Cache

Hi, at last i found the problem... I'm missing this config: settings cacheModelsEnabled=true / but i'm pretty sure the docs said that cacheModels are enabled by default. Anyway.. thanks for the feedback, Yusuf -Original Message- From: Yusuf Sent

RE: Cache

Really?? but I have add it under the Common Problems category with the entry How can I enable the caching feature of iBATIS.. this is the direct link: http://opensource2.atlassian.com/confluence/oss/pages/viewpage.action?pa geId=3304 Yusuf. -Original Message- From: Nathan Maves [mailto

Missing hours/minute/seconds in querying field with DATE type

the it would return the correct value (complete with hours/min/secs). Is there a solution to this? Thank you, Yusuf.

RE: pager in ibatis

the queryForPaginatedList (without caching) will always fetch the entire result and then showing only the selected records, and if the record count is high (like thousands..) then the performance will be bad. cmiiw, Yusuf. -Original Message- From: John Chien [mailto:[EMAIL PROTECTED] Sent

Invalid Column Type issue in confluence

582 - oracle 8.1.7 - oracle10g jdbc thin driver (ojdbc14.jar) - c3p0 0.9.0.2 Thanks :) Yusuf.

RE: Invalid Column Type issue in confluence

actually i've been having this problem for quite some time, but i will try to reproduce and post it here again just to make sure its not other column. thanks :) Yusuf. -Original Message- From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 10:24 PM To: user-java

RE: pager in ibatis

Hi, I don't know if this is true, but i think i've tried that solution before, and when i see the log generated from the ResultSet, it actually query all the data, and then selecting only the required record to show.. Yusuf. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Invalid Column Type issue in confluence

HashMap(); map.put(empno, new Integer(1234)); map.put(ename, YUSUF); map.put(job, ANALYST); map.put(mgr, new Integer(7839)); map.put(hiredate, new Date()); map.put(sal, new Integer(2000)); //map.put(comm, null); map.put(deptno, new Integer

RE: Need help with Ibatis Runtime Error

in this statement: select id=loadDropDownMenu resultClass=selectionResult parameterClass=string select * from system_lookup where TheStatus = 'ACTIVE' and type = #type# /select you should replace resultClass=selectionResult to resultMap=selectionResult -Original Message-

RE: iBatis enhancements (Annotations and/or Dynamic beanutils support)

a java.util.Date in a HashMap, then it'll only save the date value, not the time (example: the value 01/01/1981 19:23:12 will be saved as 01/01/1981 00:00:00) yusuf -Original Message- From: Brent Ryan [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 03, 2006 9:39 AM To: user-java@ibatis.apache.org

Exception net.sf.cglib.beans.BulkBeanException on resultMap with selects

by: java.lang.ClassCastException ... 67 more i've double checked the result class, the sql mappings, and also in log, i've seen the inner select already called the result is shown too, is there anyone who knows the solution to this problem? thank you, Yusuf.

RE: Exception net.sf.cglib.beans.BulkBeanException on resultMap with selects

Hi, I found the solution.. sorry about this, guess I'll have to re-check my double checking effort.. its only a class casting issue (i've mapped a String column to an Int) Yusuf. -Original Message- From: Yusuf Sent: Monday, May 15, 2006 9:55 AM To: user-java@ibatis.apache.org Subject

Reloading sqlmaps

.. thank you, yusuf.

RE: sql map via Java API

just my opinion, but what's the point of using iBatis if you wanted to build a statement at runtime? maybe you can just use simple jdbc? yusuf -Original Message- From: Edwin Lukaweski [mailto:[EMAIL PROTECTED] Sent: Friday, June 23, 2006 3:28 AM To: user-java@ibatis.apache.org Subject

RE: RE : RE : RE : RE : request using beanExample

i had this kind of problem and solved using right padding with empty space, eg. Select UUID, MOBILE,ORIGINE_UUID,ETAT,LOGIN, ETAT_MODIFIE,TSTMPINSR, TSTMPUPDT from UTILISATEUR where MOBILE = rpad(#value#,12,' ') Regards, Yusuf -Original Message- From: jeremy jardin [mailto:[EMAIL

query multiple column with Integer resultClass successfully executed

of curiosity, is this just a bug? or is it made like that? I'm using iBATIS 2.1.7 and Oracle 8i.. thanks.. Yusuf

RE: got sql exception:

as suggested by the exception (ORA-00600), its an internal oracle error, and not related to ibatis. you can consult this problem in the metalink or oracle support. cmiiw. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 8:49 AM To:

RE: Date format conversion to/from db

you could use something like this in displaytag, just look in the docs: display:column property=col_name title=Column Header format={0, date, dd/MM/} / yusuf -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 12:39 AM To: user

MyJavaServer

the mcs2 to the public)? thanks and please CMIIW, yusuf

iBatis Typehandler problem

; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in org/yusuf/demo/dao/sql/db.xml. --- The error occurred while applying a result map. --- Check the org.yusuf.db.selectBirthday-AutoResultMap. --- Check the result mapping for the 'date1

RE: iBatis Typehandler problem

javaType=int jdbcType=NUMERIC / result property=string1 column=string1 javaType=string jdbcType=VARCHAR / result property=date1 column=date1 typeHandler=org.yusuf.utils.typehandlers.DateTimeTypeHandler jdbcType=DATE / /resultMap thanks, Yusuf -Original

RE: implicit date issue

Hi, for what it's worth, i looked into my xml and found this select id=com.xxx.selectNextBill parameterClass=java.util.Date resultClass=java.util.Date select case when to_char(#value#,'dd') ![CDATA[]] to_char(add_months(#value#,1),'dd')

Just Another Stored Procedure Question

Hi, Really2 sorry for asking, i know this has been asked before many times, i have browsed through the docs, the faqs page, and the mailing lists, but i can't seem to make this work (oracle): oracle procedure : PROCEDURE generate_counter ( v_result OUT VARCHAR2,

RE: Just Another Stored Procedure Question

#, #length:number) from dual /select but I'm still curious how to make this work... are there any other suggestions? thanks best regards, yusuf -Original Message- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 21, 2007 7:56 PM To: user-java@ibatis.apache.org Subject: Re

RE: Just Another Stored Procedure Question

. Larry, I think the . characters in the name is no problem, because i've been coding ibatis sqlmaps like that for quite some time (i know it's better using namespaces.. but we're a little occupied now to fix it) thank you... and please CMIIW.. yusuf -Original Message- From: Larry Meadors