How can I reuse a resultMap.

2006-07-12 Thread MCCORMICK, Paul
Title: How can I reuse a resultMap. I have a resultMap I use to populate a Name object. Here is the class and result map. public class Name { public Integer name_id } public class

request using beanExample

2006-07-12 Thread jeremy jardin
Hello, Im trying to launch a request using a beanExample .. Ive logged the sql request, and I can see that this request should answers 1 result. After all. my resultList is empty, and I dont know why. Any idea ?

Re: request using beanExample

2006-07-12 Thread Larry Meadors
Do you have a resultMap or resultClass for the select? Larry On 7/11/06, jeremy jardin [EMAIL PROTECTED] wrote: Hello, I'm trying to launch a request using a beanExample .. I've logged the sql request, and I can see that this request should answers 1 result. After all. my resultList

RE : request using beanExample

2006-07-12 Thread jeremy jardin
All my classes have been generated using Abator so, I have something like that : List list = sqlMapClient.queryForList(UTILISATEUR.abatorgenerated_selectByExample, parms); Parms contains my where clause, instanciated the good way... PreparedStatement: Select UUID,

RE : RE : request using beanExample

2006-07-12 Thread jeremy jardin
A CHAR !! Why ?? -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Larry Meadors Envoyé : mercredi 12 juillet 2006 09:50 À : user-java@ibatis.apache.org Objet : Re: RE : request using beanExample Is MOBILE a CHAR field or VARCHAR? Larry On 7/11/06,

Re: How to use a function on a parameter in an update mapped statement?

2006-07-12 Thread Fred Janon
Hi Ted, Thanks for the suggestion, I looked at the link you mentioned, but I don't think that's the issue. It looks like iBatis doesn't even generatr the correct statement if the log is correct: PreparedStatement: update jobs set clientid=?, summary=?, jobduedate=?where jobid=?

Re: How to use a function on a parameter in an update mapped statement?

2006-07-12 Thread Larry Meadors
Nope, I think there is something else going on here...iBATIS is not changing your SQL...so if it says jobduedate=? then that is what is in the SQL map. How are you building the application? Larry On 7/11/06, Fred Janon [EMAIL PROTECTED] wrote: Hi Ted, Thanks for the suggestion, I looked at

Re: RE : RE : request using beanExample

2006-07-12 Thread Larry Meadors
The length is probably wrong, and in all SQL dialects I have ever used, A does not equal A. Larry On 7/11/06, jeremy jardin [EMAIL PROTECTED] wrote: A CHAR !! Why ?? -Message d'origine- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Larry Meadors Envoyé: mercredi

RE : RE : RE : request using beanExample

2006-07-12 Thread jeremy jardin
You mean that is my fiel dis CHAR(12)... and the string I put in is only 8 char long;. It could be problematic ? -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Larry Meadors Envoyé : mercredi 12 juillet 2006 10:37 À : user-java@ibatis.apache.org

Re: RE : RE : RE : request using beanExample

2006-07-12 Thread Larry Meadors
Yep. On 7/11/06, jeremy jardin [EMAIL PROTECTED] wrote: You mean that is my fiel dis CHAR(12)... and the string I put in is only 8 char long;. It could be problematic ? -Message d'origine- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Larry Meadors Envoyé: mercredi

RE : RE : RE : RE : request using beanExample

2006-07-12 Thread jeremy jardin
Arg it's quite bad... And if it was a varchar it would be better ? -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Larry Meadors Envoyé : mercredi 12 juillet 2006 10:49 À : user-java@ibatis.apache.org Objet : Re: RE : RE : RE : request using

RE : RE : RE : RE : request using beanExample

2006-07-12 Thread jeremy jardin
I'm still having that pb.. even if I only insert 12CHAR long Strings !! I insert my user with un phone Number like that 0600 (12 chars) and in my request, I set my example witth thaht number : 0600 stil no results !! :-( -Message d'origine- De : [EMAIL PROTECTED]

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

2006-07-12 Thread Yusuf
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

batch update using SqlMapClientDaoSupport from Spring

2006-07-12 Thread Dodo
Hi, Just wandering has anyone done batch updating using org.springframework.orm.ibatis.support.SqlMapClientDaoSupportusing the Spring framework??I am interested to use Spring to define transactions for methods invoked via SqlMapClientDaoSupport as below!-- Transaction template for Managers,

Multiple ResultSet

2006-07-12 Thread Cornel Antohi
Hi, Does iBatis support multiple ResultSet returned by a StoredProcedure? Thank you, Cornel

Re: iBATS CGLIB

2006-07-12 Thread Clinton Begin
Wow.On 7/11/06, Pradheep [EMAIL PROTECTED] wrote: Clinton Thanks for your suggestion and now tried using Batch Process. 5000 records and its 2696 msecs. Regards Pradheep - Original Message - From: Clinton Begin To: user-java@ibatis.apache.org Sent:

Re: Isolation level support at the DAO framework level ...

2006-07-12 Thread Eric Tan
Hi JeffThanks for the reply.I had suspected that it would be hard to implement this for all the different frameworks.I like the idea of being able to demarcate transactions above the DAO level. For example, in the JPetStore example, within the OrderService.java, the transaction involves 2 DAOs.

RE: interface property predicaments

2006-07-12 Thread Poitras Christian
Your Article class does not respect java beans specification. public void setPerson(Person person) { this.person = person; } // required for ibatis object construction public void setPerson(PersonImpl person) { this.person = person; } Having to setters with different argument