ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prem75 <premkum...@virtusa.com>
Subject Re: Using iBatis just for generating 'Dynamic SQL'
Date Wed, 09 Dec 2009 10:17:27 GMT

This is our client's internal reference architecture [Hibernate or iBatis can
be used for data access and Jasper for reporting.]


Mario Briggs wrote:
> 
> Ok i see the point. BTW which reference architecture are you referring to
> -
> the JasperReports reference architecture.
> 
> 
> 
>                                                                            
>              Prem75                                                        
>              <premkumarc@virtu                                             
>              sa.com>                                                    To 
>                                        user-java@ibatis.apache.org         
>              09/12/2009 15:12                                           cc 
>                                                                            
>                                                                    Subject 
>              Please respond to         Re: Using iBatis just for           
>              user-java@ibatis.         generating 'Dynamic SQL'            
>                 apache.org                                                 
>                                                                            
>                                                                            
>                                                                            
>                                                                            
>                                                                            
> 
> 
> 
> 
> 
> 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
> 
> 
> 
> 
> ---------------------------------------------------------------------
> 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-tp26705861p26707964.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


Mime
View raw message