Re: Using iBatis just for generating 'Dynamic SQL'

2009-12-09 Thread Larry Meadors
On Tue, Dec 8, 2009 at 11:44 PM, Prem75 wrote: > 2. Does iBatis have a professional support that we can sign up for? Several of us (Brandon, Nathan, and myself) are full-time contract developers. I'd love to work with you, and I suspect the others would as well. That would be a conversation to h

Re: Using iBatis just for generating 'Dynamic SQL'

2009-12-09 Thread Prem75
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. > > > >

Re: Using iBatis just for generating 'Dynamic SQL'

2009-12-09 Thread Mario Ds Briggs
Ok i see the point. BTW which reference architecture are you referring to - the JasperReports reference architecture. Prem75

Re: Using iBatis just for generating 'Dynamic SQL'

2009-12-09 Thread Prem75
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 s

Re: Using iBatis just for generating 'Dynamic SQL'

2009-12-09 Thread Mario Ds Briggs
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

Using iBatis just for generating 'Dynamic SQL'

2009-12-08 Thread Prem75
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 a