I'll second that, and ask that you please, Please, PLEASE not reply to an existing thread to ask a new question. :-)
Larry On 8/27/07, Clinton Begin <[EMAIL PROTECTED]> wrote: > > > > > I'd recommend XStream. You'll have better control and avoid duplicate > mappings. Get iBATIS to return either Maps or JavaBeans, and run that > through XStream to get XML results. > > > > Clinton > > > > > From: Fábio Pisaruk [mailto:[EMAIL PROTECTED] > Sent: August-27-07 2:15 PM > To: [email protected] > > Subject: Re: Get return value and return result set > > > > > Hi guys! > > I´m trying to use ibatis to generate xml from my tables but i can´t find any > useful examples to do so. > I have the following problem: Suppose there are two tables named Person, > Phones. I´d like to generate a xml document like this: > > <Person> > <PersonID>9999<PersonID> > <Name>Name of person</Name> > <Phones> > <Phone>5555-5555</Phone> > <Phone>1111-5555</Phone> > <Phone>2222-5555</Phone> > <Phones> > </Person> > > Here are my maps: > > <resultMap id="person-ResultMap" class="xml" groupBy="personID"> > <result property="name" column="name"/> > <result property="personID" column="personID"/> > <result property="phones" resultMap="phone-ResultMap"/> > <resultMap/> > > <resultMap id="phone-ResultMap" class="xml"> > <result property="name" column="name"/> > <result property="personID" column="personID"/> > <resultMap/> > > <select id="getPerson" parameterClass="int" resultMap="person-ResultMap"> > select name,number,personID > from Person,Phone > where personID= ? > </select> > > But i can´t make it to work. > I think that ibatis doesn´t support nested lists :-( > > Thanks in advance. > > > > > > > > > > On 8/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Hi Brandon, > > Thank you for your reply. I did try it with the straight JDBC, and it works. > In straight JDBC the return value of the stored procedure is the first output > parameter of the callable statement. > ------------------------------------------------------ > Hill Xie > > > > > > "Brandon Goodin" <[EMAIL PROTECTED]> > > 27/08/2007 03:45 PM > > > Please respond to > [email protected] > > > To > > [email protected] > > > cc > > > > Subject > > Re: Get return value and return result set > > > > > > > > > > > iBATIS uses standard JDBC support for multiple result sets. Have you tried > implementing this in straight JDBC using your driver to see if it is > supported by the driver? > > Thanks, > Brandon > > On 8/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi, > > I have a DB2 stored procedure returns a single value and a result set at the > same time, like this: > > DECLARE DB2_SP_SQL1 CURSOR WITH RETURN FOR > Select * FROM USERS WHERE UserID = pUserID; > > OPEN DB2_SP_SQL1; > RETURN 100; > > I tried many times, I can only get the return value (100) back, while the > return result set is always empty. Here is the iBatis configuration and java > code: > > 1. iBatis Configuration: > > <parameterMap id="parameter" class="java.util.HashMap" > > <parameter property="pReturnCode" jdbcType="INTEGER" > javaType="java.lang.Integer" mode="OUT" /> > <parameter property="pUSERID" jdbcType="INTEGER" > javaType="java.lang.Integer" mode="IN" /> > </parameterMap > > > <procedure id="getUserProfile" parameterMap="parameter" > resultMap="userProfileResult" > > {? = call TEST_GETUSERSBYID (?)} > </procedure > > > 2. Java Code: > > HashMap parameters = new HashMap(); > Integer returnCode = new Integer(-1); > parameters.put("ReturnCode", returnCode); > parameters.put("UserID", new Integer(userID)); > > UserProfile userProfile = > (UserProfile)getSqlMapClientTemplate().queryForObject("getUserProfile", > parameters); > > 3. Result: userProfile is null, the ReturnCode in the HashMap is 100. > > After I debugged into the iBatis code, I found the code does populate some > data (I am sure what data) into the resultset object. But rs.next()returns > false, so the code ignores the resultset and doesn't do any mapping for the > result set. > > Is it unsupported by iBatis? > > Thanks, > ------------------------------------------------------ > Hill Xie > > > > *************************************************************** > This email may contain confidential information, and is intended only for > the named recipient and may be privileged. Distribution or copying of this > email by anyone other than the named recipient is prohibited. If you are not > the named recipient, please notify us immediately and permanently destroy > this email and all copies of it. Internet email is not private, secure, or > reliable. No member of the HSBC Group is liable for any errors or omissions > in the content or transmission of this email. Any opinions contained in this > email are solely those of the author and, unless clearly indicated otherwise > in writing, are not endorsed by any member of the HSBC Group. > *************************************************************** > > Ce courriel peut renfermer des renseignements confidentiels et > privilÃ(c)giÃ(c)s et s'adresse au destinataire dÃ(c)signÃ(c) seulement. La > distribution ou la copie de ce courriel par toute personne autre que le > destinataire dÃ(c)signÃ(c) est interdite. Si vous n'êtes pas le destinataire > dÃ(c)signÃ(c), veuillez nous en aviser immÃ(c)diatement et dÃ(c)truire de > façon permanente ce courriel ainsi que toute copie de celui-ci. La > transmission de courriel par Internet ne constitue pas un mode de > transmission confidentiel, sÃ(c)curitaire ou fiable. Aucun membre du Groupe > HSBC ne sera responsable des erreurs ou des omissions relatives au contenu ou > à la transmission de ce courriel. L'auteur de ce courriel est seul > responsable des opinions Ã(c)mises dans ce courriel, lesquelles, à moins > d'un avis contraire fourni par Ã(c)crit, ne sont pas endossÃ(c)es par aucun > membre du Groupe HSBC. > *************************************************************** > > "SAVE PAPER - THINK BEFORE YOU PRINT!" > > "ÉCONOMISEZ LE PAPIER â€" PENSEZ-Y À DEUX FOIS AVANT D'IMPRIMER!" > > > > > > *************************************************************** > This email may contain confidential information, and is intended only for > the named recipient and may be privileged. Distribution or copying of this > email by anyone other than the named recipient is prohibited. If you are not > the named recipient, please notify us immediately and permanently destroy > this email and all copies of it. Internet email is not private, secure, or > reliable. No member of the HSBC Group is liable for any errors or omissions > in the content or transmission of this email. Any opinions contained in this > email are solely those of the author and, unless clearly indicated otherwise > in writing, are not endorsed by any member of the HSBC Group. > *************************************************************** > Ce courriel peut renfermer des renseignements confidentiels et privilégiés > et s'adresse au destinataire désigné seulement. La distribution ou la copie > de ce courriel par toute personne autre que le destinataire désigné est > interdite. Si vous n'êtes pas le destinataire désigné, veuillez nous en > aviser immédiatement et détruire de façon permanente ce courriel ainsi que > toute copie de celui-ci. La transmission de courriel par Internet ne > constitue pas un mode de transmission confidentiel, sécuritaire ou fiable. > Aucun membre du Groupe HSBC ne sera responsable des erreurs ou des omissions > relatives au contenu ou à la transmission de ce courriel. L'auteur de ce > courriel est seul responsable des opinions émises dans ce courriel, > lesquelles, à moins d'un avis contraire fourni par écrit, ne sont pas > endossées par aucun membre du Groupe HSBC. > *************************************************************** > > "SAVE PAPER - THINK BEFORE YOU PRINT!" > > "ÉCONOMISEZ LE PAPIER – PENSEZ-Y À DEUX FOIS AVANT D'IMPRIMER!" > > > > > -- > Visto como se não executa logo a sentença sobre a má obra, o coração dos > filhos dos homens está inteiramente disposto a praticar o mal. > > > --Nerd´s sign > > If you have four classes, Everybody, Somebody, Anybody, and Nobody, if > Somebody has a bug, it could be Anybody 's fault but Nobody really knows, > while Everybody shares responsibility.
