need infos about ibatis 3rd party tool

[hicham abassi <ha...@gmail.com>]

Hello,

I'm playing with ibatis.
What's the actually best ibatis plugin ? Abator, .... ?

thanks

Re: need infos about ibatis 3rd party tool

[Jeff Butler <je...@gmail.com>]

Cool!  I just want to make sure that everyone understand it.

Jeff Butler


On 7/17/06, hicham abassi <ha...@gmail.com> wrote:
>
> Jeff,
>
> I clearly understand that ibatis can work without abator. My previous
> questions are only focused in ibatis ;)
>
> On 7/17/06, Jeff Butler <je...@gmail.com> wrote:
> >
> > If you have an existing domain model and a lot of stored procedures,
> then
> > Abator is probably not going to help you.
> >
> > However, iBATIS will still be a tremendous help to your project.  iBATIS
> can
> > execute the stored procedures and map the results to your domain objects
> > automatically (and do automatic type handling too) - this is the real
> strong
> > suit of iBATIS.  iBATIS also reduces the amount of boilerplate JDBC code
> you
> > will have to write to zero.  No more annoying
> try/catch/finally/try/catch
> > constructs!  The "POJOs in Action" guys did not write about Abator, they
> > show how to use iBATIS in the more normal case - where you code the
> SQL/XML
> > by hand.
> >
> > Abator is just a simple table-based code generator.  Use it if it helps,
> > otherwise don't.  In your case, it sounds like it won't help you very
> much.
> > Abator is NOT required for iBATIS, and your decision whether to use
> iBATIS
> > should NOT be based on Abator.
> >
> > Clinton: you were right :)  We need to make this VERY clear
> somewhere.  I'll
> > work up a statement for the website.
> >
> >
> > Jeff Butler
> >
> >
> > On 7/17/06, hicham abassi <ha...@gmail.com> wrote:
> > > Thanks Jeff,
> > >
> > > In fact, we have an existing VB/PlSQL/Oracle application. We must
> > > write a new webapp with existing business model.
> > > We have a lot of sql query with stored procedure into the select
> > > clause and where clause.
> > > I better discovered the adv of Ibatis by reading the excellent book
> > > "POJOS in action".
> > > Hibernate even it provides some quality features doesn't well target
> our
> > needs.
> > > I continue my evaluation of Ibatis to try to integrate ibatis into our
> > project.
> > >
> > > As you said, if we must think for resultset , what's the adv of ibatis
> > > on classical rowset implementation ? ;)
> > >
> > >
> > >
> > > On 7/17/06, Jeff Butler < jeffgbutler@gmail.com> wrote:
> > > >
> > > > Abator is completely table based.  This may, or may not, be a good
> fit
> > for
> > > > your particular application.  We usually say that iBATIS maps result
> > sets to
> > > > objects, NOT tables to objects.  But code generators are pretty
> limited
> > in
> > > > what they can figure out on their own - so Abator generates objects
> to
> > match
> > > > each table because it is the easist thing to do.  You have to decide
> for
> > > > yourself whether this provides any value in your situation.
> > > >
> > > > If you have a rich domain model that does not map easily to tables,
> then
> > it
> > > > is probably worth your while to write the iBATIS configuration items
> > > > yourself - you might end up ignoring most of the Abator generated
> code
> > in
> > > > that case.
> > > >
> > > > I think there are some cases where there can be value in the Abator
> > objects
> > > > if your domain model does not match your database - but there is
> some
> > debate
> > > > about that and you'll have to decide for yourself.  In these cases,
> the
> > > > inserts, updates, and deletes may be useful.  Probably not the
> selects.
> > > >
> > > > If your domain model is a relatively close match to your DB, then
> the
> > Abator
> > > > objects will likely provide quite a lot of value out of the box.
> > > >
> > > > If your schema changes, then you can regenerate the Abator objects.
> > Abator
> > > > in the Eclipse environment will merge the old and new together to
> > reflect
> > > > the schema changes.
> > > >
> > > >
> > > > Jeff Butler
> > > >
> > > >
> > > >
> > > >
> > > > On 7/17/06, hicham abassi < habassi@gmail.com> wrote:
> > > > > I just installed Abator plugin.
> > > > > I filled the abator config file with jdbc infos, generator infos.
> > > > > Abator's generated the sqlmap config files and java classes
> correctly.
> > > > > Abator use the classic way to select rows from database and also
> > > > > queries by example.
> > > > > I just want to know more infos about feedbacks on this plugin.
> > > > > Have you just got the generated resultmap and wrote after your
> custom
> > > > > select statement ?
> > > > > How abator manage database schema changes with a previous code
> > generation
> > > > ?
> > > > >
> > > > > Thanks.
> > > > >
> > > > > On 7/17/06, Graeme J Sweeney < ibatis.user@gjsweeney.com > wrote:
> > > > > > On Mon, 17 Jul 2006, hicham abassi wrote:
> > > > > >
> > > > > > > What's the actually best ibatis plugin ? Abator, .... ?
> > > > > >
> > > > > > Plugin for what?
> > > > > >
> > > > > > --
> > > > > > Graeme -
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>

Re: need infos about ibatis 3rd party tool

[hicham abassi <ha...@gmail.com>]

Jeff,

I clearly understand that ibatis can work without abator. My previous
questions are only focused in ibatis ;)

On 7/17/06, Jeff Butler <je...@gmail.com> wrote:
>
> If you have an existing domain model and a lot of stored procedures, then
> Abator is probably not going to help you.
>
> However, iBATIS will still be a tremendous help to your project.  iBATIS can
> execute the stored procedures and map the results to your domain objects
> automatically (and do automatic type handling too) - this is the real strong
> suit of iBATIS.  iBATIS also reduces the amount of boilerplate JDBC code you
> will have to write to zero.  No more annoying try/catch/finally/try/catch
> constructs!  The "POJOs in Action" guys did not write about Abator, they
> show how to use iBATIS in the more normal case - where you code the SQL/XML
> by hand.
>
> Abator is just a simple table-based code generator.  Use it if it helps,
> otherwise don't.  In your case, it sounds like it won't help you very much.
> Abator is NOT required for iBATIS, and your decision whether to use iBATIS
> should NOT be based on Abator.
>
> Clinton: you were right :)  We need to make this VERY clear somewhere.  I'll
> work up a statement for the website.
>
>
> Jeff Butler
>
>
> On 7/17/06, hicham abassi <ha...@gmail.com> wrote:
> > Thanks Jeff,
> >
> > In fact, we have an existing VB/PlSQL/Oracle application. We must
> > write a new webapp with existing business model.
> > We have a lot of sql query with stored procedure into the select
> > clause and where clause.
> > I better discovered the adv of Ibatis by reading the excellent book
> > "POJOS in action".
> > Hibernate even it provides some quality features doesn't well target our
> needs.
> > I continue my evaluation of Ibatis to try to integrate ibatis into our
> project.
> >
> > As you said, if we must think for resultset , what's the adv of ibatis
> > on classical rowset implementation ? ;)
> >
> >
> >
> > On 7/17/06, Jeff Butler < jeffgbutler@gmail.com> wrote:
> > >
> > > Abator is completely table based.  This may, or may not, be a good fit
> for
> > > your particular application.  We usually say that iBATIS maps result
> sets to
> > > objects, NOT tables to objects.  But code generators are pretty limited
> in
> > > what they can figure out on their own - so Abator generates objects to
> match
> > > each table because it is the easist thing to do.  You have to decide for
> > > yourself whether this provides any value in your situation.
> > >
> > > If you have a rich domain model that does not map easily to tables, then
> it
> > > is probably worth your while to write the iBATIS configuration items
> > > yourself - you might end up ignoring most of the Abator generated code
> in
> > > that case.
> > >
> > > I think there are some cases where there can be value in the Abator
> objects
> > > if your domain model does not match your database - but there is some
> debate
> > > about that and you'll have to decide for yourself.  In these cases, the
> > > inserts, updates, and deletes may be useful.  Probably not the selects.
> > >
> > > If your domain model is a relatively close match to your DB, then the
> Abator
> > > objects will likely provide quite a lot of value out of the box.
> > >
> > > If your schema changes, then you can regenerate the Abator objects.
> Abator
> > > in the Eclipse environment will merge the old and new together to
> reflect
> > > the schema changes.
> > >
> > >
> > > Jeff Butler
> > >
> > >
> > >
> > >
> > > On 7/17/06, hicham abassi < habassi@gmail.com> wrote:
> > > > I just installed Abator plugin.
> > > > I filled the abator config file with jdbc infos, generator infos.
> > > > Abator's generated the sqlmap config files and java classes correctly.
> > > > Abator use the classic way to select rows from database and also
> > > > queries by example.
> > > > I just want to know more infos about feedbacks on this plugin.
> > > > Have you just got the generated resultmap and wrote after your custom
> > > > select statement ?
> > > > How abator manage database schema changes with a previous code
> generation
> > > ?
> > > >
> > > > Thanks.
> > > >
> > > > On 7/17/06, Graeme J Sweeney < ibatis.user@gjsweeney.com > wrote:
> > > > > On Mon, 17 Jul 2006, hicham abassi wrote:
> > > > >
> > > > > > What's the actually best ibatis plugin ? Abator, .... ?
> > > > >
> > > > > Plugin for what?
> > > > >
> > > > > --
> > > > > Graeme -
> > > > >
> > > >
> > >
> > >
> >
>
>

Re: need infos about ibatis 3rd party tool

[Clinton Begin <cl...@gmail.com>]

>> We need to make this VERY clear somewhere.  I'll work up a statement for
the website.

Sounds good.  I have some ideas on this too.  In addition to a statement, I
think some new organization for the site is in order as well.  Plus, I need
to get some Ruby content up there.  Hopefully it will help with finding
documentation etc. as well.

Cheers,
Clinton


On 7/17/06, Jeff Butler <je...@gmail.com> wrote:
>
> If you have an existing domain model and a lot of stored procedures, then
> Abator is probably not going to help you.
>
> However, iBATIS will still be a tremendous help to your project.  iBATIS
> can execute the stored procedures and map the results to your domain objects
> automatically (and do automatic type handling too) - this is the real strong
> suit of iBATIS.  iBATIS also reduces the amount of boilerplate JDBC code you
> will have to write to zero.  No more annoying try/catch/finally/try/catch
> constructs!  The "POJOs in Action" guys did not write about Abator, they
> show how to use iBATIS in the more normal case - where you code the SQL/XML
> by hand.
>
> Abator is just a simple table-based code generator.  Use it if it helps,
> otherwise don't.  In your case, it sounds like it won't help you very much.
> Abator is NOT required for iBATIS, and your decision whether to use iBATIS
> should NOT be based on Abator.
>
> *Clinton:* you were right :)  We need to make this VERY clear somewhere.
> I'll work up a statement for the website.
>
> Jeff Butler
>
>
> On 7/17/06, hicham abassi <ha...@gmail.com> wrote:
> >
> > Thanks Jeff,
> >
> > In fact, we have an existing VB/PlSQL/Oracle application. We must
> > write a new webapp with existing business model.
> > We have a lot of sql query with stored procedure into the select
> > clause and where clause.
> > I better discovered the adv of Ibatis by reading the excellent book
> > "POJOS in action".
> > Hibernate even it provides some quality features doesn't well target our
> > needs.
> > I continue my evaluation of Ibatis to try to integrate ibatis into our
> > project.
> >
> > As you said, if we must think for resultset , what's the adv of ibatis
> > on classical rowset implementation ? ;)
> >
> >
> >
> > On 7/17/06, Jeff Butler < jeffgbutler@gmail.com> wrote:
> > >
> > > Abator is completely table based.  This may, or may not, be a good fit
> > for
> > > your particular application.  We usually say that iBATIS maps result
> > sets to
> > > objects, NOT tables to objects.  But code generators are pretty
> > limited in
> > > what they can figure out on their own - so Abator generates objects to
> > match
> > > each table because it is the easist thing to do.  You have to decide
> > for
> > > yourself whether this provides any value in your situation.
> > >
> > > If you have a rich domain model that does not map easily to tables,
> > then it
> > > is probably worth your while to write the iBATIS configuration items
> > > yourself - you might end up ignoring most of the Abator generated code
> > in
> > > that case.
> > >
> > > I think there are some cases where there can be value in the Abator
> > objects
> > > if your domain model does not match your database - but there is some
> > debate
> > > about that and you'll have to decide for yourself.  In these cases,
> > the
> > > inserts, updates, and deletes may be useful.  Probably not the
> > selects.
> > >
> > > If your domain model is a relatively close match to your DB, then the
> > Abator
> > > objects will likely provide quite a lot of value out of the box.
> > >
> > > If your schema changes, then you can regenerate the Abator
> > objects.  Abator
> > > in the Eclipse environment will merge the old and new together to
> > reflect
> > > the schema changes.
> > >
> > >
> > > Jeff Butler
> > >
> > >
> > >
> > >
> > > On 7/17/06, hicham abassi < habassi@gmail.com> wrote:
> > > > I just installed Abator plugin.
> > > > I filled the abator config file with jdbc infos, generator infos.
> > > > Abator's generated the sqlmap config files and java classes
> > correctly.
> > > > Abator use the classic way to select rows from database and also
> > > > queries by example.
> > > > I just want to know more infos about feedbacks on this plugin.
> > > > Have you just got the generated resultmap and wrote after your
> > custom
> > > > select statement ?
> > > > How abator manage database schema changes with a previous code
> > generation
> > > ?
> > > >
> > > > Thanks.
> > > >
> > > > On 7/17/06, Graeme J Sweeney < ibatis.user@gjsweeney.com > wrote:
> > > > > On Mon, 17 Jul 2006, hicham abassi wrote:
> > > > >
> > > > > > What's the actually best ibatis plugin ? Abator, .... ?
> > > > >
> > > > > Plugin for what?
> > > > >
> > > > > --
> > > > > Graeme -
> > > > >
> > > >
> > >
> > >
> >
>
>

Re: need infos about ibatis 3rd party tool

[Jeff Butler <je...@gmail.com>]

If you have an existing domain model and a lot of stored procedures, then
Abator is probably not going to help you.

However, iBATIS will still be a tremendous help to your project.  iBATIS can
execute the stored procedures and map the results to your domain objects
automatically (and do automatic type handling too) - this is the real strong
suit of iBATIS.  iBATIS also reduces the amount of boilerplate JDBC code you
will have to write to zero.  No more annoying try/catch/finally/try/catch
constructs!  The "POJOs in Action" guys did not write about Abator, they
show how to use iBATIS in the more normal case - where you code the SQL/XML
by hand.

Abator is just a simple table-based code generator.  Use it if it helps,
otherwise don't.  In your case, it sounds like it won't help you very much.
Abator is NOT required for iBATIS, and your decision whether to use iBATIS
should NOT be based on Abator.

*Clinton:* you were right :)  We need to make this VERY clear somewhere.
I'll work up a statement for the website.

Jeff Butler


On 7/17/06, hicham abassi <ha...@gmail.com> wrote:
>
> Thanks Jeff,
>
> In fact, we have an existing VB/PlSQL/Oracle application. We must
> write a new webapp with existing business model.
> We have a lot of sql query with stored procedure into the select
> clause and where clause.
> I better discovered the adv of Ibatis by reading the excellent book
> "POJOS in action".
> Hibernate even it provides some quality features doesn't well target our
> needs.
> I continue my evaluation of Ibatis to try to integrate ibatis into our
> project.
>
> As you said, if we must think for resultset , what's the adv of ibatis
> on classical rowset implementation ? ;)
>
>
>
> On 7/17/06, Jeff Butler <je...@gmail.com> wrote:
> >
> > Abator is completely table based.  This may, or may not, be a good fit
> for
> > your particular application.  We usually say that iBATIS maps result
> sets to
> > objects, NOT tables to objects.  But code generators are pretty limited
> in
> > what they can figure out on their own - so Abator generates objects to
> match
> > each table because it is the easist thing to do.  You have to decide for
> > yourself whether this provides any value in your situation.
> >
> > If you have a rich domain model that does not map easily to tables, then
> it
> > is probably worth your while to write the iBATIS configuration items
> > yourself - you might end up ignoring most of the Abator generated code
> in
> > that case.
> >
> > I think there are some cases where there can be value in the Abator
> objects
> > if your domain model does not match your database - but there is some
> debate
> > about that and you'll have to decide for yourself.  In these cases, the
> > inserts, updates, and deletes may be useful.  Probably not the selects.
> >
> > If your domain model is a relatively close match to your DB, then the
> Abator
> > objects will likely provide quite a lot of value out of the box.
> >
> > If your schema changes, then you can regenerate the Abator
> objects.  Abator
> > in the Eclipse environment will merge the old and new together to
> reflect
> > the schema changes.
> >
> >
> > Jeff Butler
> >
> >
> >
> >
> > On 7/17/06, hicham abassi < habassi@gmail.com> wrote:
> > > I just installed Abator plugin.
> > > I filled the abator config file with jdbc infos, generator infos.
> > > Abator's generated the sqlmap config files and java classes correctly.
> > > Abator use the classic way to select rows from database and also
> > > queries by example.
> > > I just want to know more infos about feedbacks on this plugin.
> > > Have you just got the generated resultmap and wrote after your custom
> > > select statement ?
> > > How abator manage database schema changes with a previous code
> generation
> > ?
> > >
> > > Thanks.
> > >
> > > On 7/17/06, Graeme J Sweeney < ibatis.user@gjsweeney.com > wrote:
> > > > On Mon, 17 Jul 2006, hicham abassi wrote:
> > > >
> > > > > What's the actually best ibatis plugin ? Abator, .... ?
> > > >
> > > > Plugin for what?
> > > >
> > > > --
> > > > Graeme -
> > > >
> > >
> >
> >
>

Re: need infos about ibatis 3rd party tool

[hicham abassi <ha...@gmail.com>]

Thanks Jeff,

In fact, we have an existing VB/PlSQL/Oracle application. We must
write a new webapp with existing business model.
We have a lot of sql query with stored procedure into the select
clause and where clause.
I better discovered the adv of Ibatis by reading the excellent book
"POJOS in action".
Hibernate even it provides some quality features doesn't well target our needs.
I continue my evaluation of Ibatis to try to integrate ibatis into our project.

As you said, if we must think for resultset , what's the adv of ibatis
on classical rowset implementation ? ;)



On 7/17/06, Jeff Butler <je...@gmail.com> wrote:
>
> Abator is completely table based.  This may, or may not, be a good fit for
> your particular application.  We usually say that iBATIS maps result sets to
> objects, NOT tables to objects.  But code generators are pretty limited in
> what they can figure out on their own - so Abator generates objects to match
> each table because it is the easist thing to do.  You have to decide for
> yourself whether this provides any value in your situation.
>
> If you have a rich domain model that does not map easily to tables, then it
> is probably worth your while to write the iBATIS configuration items
> yourself - you might end up ignoring most of the Abator generated code in
> that case.
>
> I think there are some cases where there can be value in the Abator objects
> if your domain model does not match your database - but there is some debate
> about that and you'll have to decide for yourself.  In these cases, the
> inserts, updates, and deletes may be useful.  Probably not the selects.
>
> If your domain model is a relatively close match to your DB, then the Abator
> objects will likely provide quite a lot of value out of the box.
>
> If your schema changes, then you can regenerate the Abator objects.  Abator
> in the Eclipse environment will merge the old and new together to reflect
> the schema changes.
>
>
> Jeff Butler
>
>
>
>
> On 7/17/06, hicham abassi < habassi@gmail.com> wrote:
> > I just installed Abator plugin.
> > I filled the abator config file with jdbc infos, generator infos.
> > Abator's generated the sqlmap config files and java classes correctly.
> > Abator use the classic way to select rows from database and also
> > queries by example.
> > I just want to know more infos about feedbacks on this plugin.
> > Have you just got the generated resultmap and wrote after your custom
> > select statement ?
> > How abator manage database schema changes with a previous code generation
> ?
> >
> > Thanks.
> >
> > On 7/17/06, Graeme J Sweeney < ibatis.user@gjsweeney.com > wrote:
> > > On Mon, 17 Jul 2006, hicham abassi wrote:
> > >
> > > > What's the actually best ibatis plugin ? Abator, .... ?
> > >
> > > Plugin for what?
> > >
> > > --
> > > Graeme -
> > >
> >
>
>

Re: need infos about ibatis 3rd party tool

[Jeff Butler <je...@gmail.com>]

Abator is completely table based.  This may, or may not, be a good fit for
your particular application.  We usually say that iBATIS maps result sets to
objects, NOT tables to objects.  But code generators are pretty limited in
what they can figure out on their own - so Abator generates objects to match
each table because it is the easist thing to do.  You have to decide for
yourself whether this provides any value in your situation.

If you have a rich domain model that does not map easily to tables, then it
is probably worth your while to write the iBATIS configuration
items yourself - you might end up ignoring most of the Abator generated code
in that case.

I think there are some cases where there can be value in the Abator objects
if your domain model does not match your database - but there is some debate
about that and you'll have to decide for yourself.  In these cases, the
inserts, updates, and deletes may be useful.  Probably not the selects.

If your domain model is a relatively close match to your DB, then the Abator
objects will likely provide quite a lot of value out of the box.

If your schema changes, then you can regenerate the Abator objects.  Abator
in the Eclipse environment will merge the old and new together to reflect
the schema changes.

Jeff Butler



On 7/17/06, hicham abassi <ha...@gmail.com> wrote:
>
> I just installed Abator plugin.
> I filled the abator config file with jdbc infos, generator infos.
> Abator's generated the sqlmap config files and java classes correctly.
> Abator use the classic way to select rows from database and also
> queries by example.
> I just want to know more infos about feedbacks on this plugin.
> Have you just got the generated resultmap and wrote after your custom
> select statement ?
> How abator manage database schema changes with a previous code generation
> ?
>
> Thanks.
>
> On 7/17/06, Graeme J Sweeney <ibatis.user@gjsweeney.com > wrote:
> > On Mon, 17 Jul 2006, hicham abassi wrote:
> >
> > > What's the actually best ibatis plugin ? Abator, .... ?
> >
> > Plugin for what?
> >
> > --
> > Graeme -
> >
>

Re: need infos about ibatis 3rd party tool

[hicham abassi <ha...@gmail.com>]

I just installed Abator plugin.
I filled the abator config file with jdbc infos, generator infos.
Abator's generated the sqlmap config files and java classes correctly.
Abator use the classic way to select rows from database and also
queries by example.
I just want to know more infos about feedbacks on this plugin.
Have you just got the generated resultmap and wrote after your custom
select statement ?
How abator manage database schema changes with a previous code generation ?

Thanks.

On 7/17/06, Graeme J Sweeney <ib...@gjsweeney.com> wrote:
> On Mon, 17 Jul 2006, hicham abassi wrote:
>
> > What's the actually best ibatis plugin ? Abator, .... ?
>
> Plugin for what?
>
> --
> Graeme -
>

Re: need infos about ibatis 3rd party tool

[Graeme J Sweeney <ib...@gjsweeney.com>]

On Mon, 17 Jul 2006, hicham abassi wrote:

> What's the actually best ibatis plugin ? Abator, .... ?

Plugin for what?

-- 
Graeme -