You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Prem75 <pr...@virtusa.com> on 2009/12/09 07:44:44 UTC
Using iBatis just for generating 'Dynamic SQL'
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
Re: Using iBatis just for generating 'Dynamic SQL'
Posted by Larry Meadors <la...@gmail.com>.
On Tue, Dec 8, 2009 at 11:44 PM, Prem75 <pr...@virtusa.com> 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 have off-list, but don't
expect it to come cheap or you will be disappointed. ;-)
> 3. Is there a process through which we can request for a paid new feature in
> iBatis?
We've never tackled that specifically, but I don't see any obvious
roadblocks unless what you're asking for would be a breaking change -
i.e., something that would make existing ibatis users' systems break.
> 4. Is there a way to get the dynamically generated SQL before execution?
Yes, I have done that before with ibatis 2 (not 3 yet), and it was
really pretty simple.
Larry
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: Using iBatis just for generating 'Dynamic SQL'
Posted by Prem75 <pr...@virtusa.com>.
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
Re: Using iBatis just for generating 'Dynamic SQL'
Posted by Mario Ds Briggs <ma...@in.ibm.com>.
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
Re: Using iBatis just for generating 'Dynamic SQL'
Posted by Prem75 <pr...@virtusa.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
Re: Using iBatis just for generating 'Dynamic SQL'
Posted by Mario Ds Briggs <ma...@in.ibm.com>.
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