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 > <premkum...@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-j...@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 > >> <premkum...@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-j...@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-unsubscr...@ibatis.apache.org >> For additional commands, e-mail: user-java-h...@ibatis.apache.org >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org >> For additional commands, e-mail: user-java-h...@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-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
