Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <26707501.post@talk.nabble.com>
Date: Wed, 9 Dec 2009 01:42:26 -0800 (PST)
From: Prem75 <premkumarc@virtusa.com>
To: user-java@ibatis.apache.org
Subject: Re: Using iBatis just for generating 'Dynamic SQL'
In-Reply-To: 
 <OFB2B41769.63C16ACB-ON65257687.0031013B-65257687.003138B6@in.ibm.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <26705861.post@talk.nabble.com>
 <OFB2B41769.63C16ACB-ON65257687.0031013B-65257687.003138B6@in.ibm.com>


Thanks Mario for the response. We have used spring jdbc template earlier, but
as far as I know it doesn't support generating SQL dynamically based on
parameters. E.g. think of a complex report where the entire 'where clause'
for it is build based on the user inputs. Another reason why we want to
stick with iBatis is architecturally we don't want to deviate from what
existing Reference Architecture.


Mario Briggs wrote:
> 
> Maybe there is a way and the ibatis devs can tell you how. But i will ask
> a
> different question, why not use something like Spring JDBC templates or
> similar technology ?
> 
> regards
> Mario
> 
> 
> 
> 
>                                                                            
>              Prem75                                                        
>              <premkumarc@virtu                                             
>              sa.com>                                                    To 
>                                        user-java@ibatis.apache.org         
>              09/12/2009 12:14                                           cc 
>                                                                            
>                                                                    Subject 
>              Please respond to         Using iBatis just for generating    
>              user-java@ibatis.         'Dynamic SQL'                       
>                 apache.org                                                 
>                                                                            
>                                                                            
>                                                                            
>                                                                            
>                                                                            
> 
> 
> 
> 
> 
> iBatis Community,
> 
> We are trying to integrate iBatis with JasperReports. Since most of our
> reports are huge, we don't want to load the entire result into a
> collection
> and then hand it over to Jasper. Instead we are trying to utilize the
> feature where Jasper can take in a java.sql.Resulset object and pull the
> data incrementally to build the reports (also we are using the
> virtualizers
> to keep the memory foot print low on the report filling part). Is there a
> way to get the Resultset object from iBatis?
> 
> This request has been registered earlier
> (http://issues.apache.org/jira/browse/IBATIS-290), any idea why this has
> request has kept in an unassigned state even though the priority says
> major?
> 
> Some responses say that, iBatis is not the way to go if we want to
> directly
> work with result sets. Our situation is we are using iBatis to generate
> complex dynamic queries, but we want to work with the Resulset directly
> for
> performance reasons.
> 
> Few questions (please share your thoughts even if you don't have a
> solution)
> 
> 1. Has anyone solved this or a similar problem, if so please share your
> solution or thoughts?
> 2. Does iBatis have a professional support that we can sign up for?
> 3. Is there a process through which we can request for a paid new feature
> in
> iBatis?
> 4. Is there a way to get the dynamically generated SQL before execution?
> 
> Thanks for reading this far, will be glad to hear your thoughts.
> --
> View this message in context:
> http://old.nabble.com/Using-iBatis-just-for-generating-%27Dynamic-SQL%27-tp26705861p26705861.html
> 
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Using-iBatis-just-for-generating-%27Dynamic-SQL%27-tp26705861p26707501.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org