You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Lars Huttar <la...@sil.org> on 2011/07/28 00:32:45 UTC
database access in Cocoon 3?
Hello,
In the past (Cocoon 2.1) we used XSP pages for database queries to
return results as XML for processing in Cocoon pipelines.
Looking toward the future with 2.2 and beyond, we saw that XSP pages
were deprecated, so we started using SQL transformer instead.
With Cocoon 3.0, is the SQL transformer still part of the picture? (I
don't see it among the samples.) Or is there something else that is
recommended for grabbing data from a database as input to a pipeline?
Thanks,
Lars
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: database access in Cocoon 3?
Posted by Lars Huttar <la...@sil.org>.
OK, I have done this:
https://issues.apache.org/jira/browse/COCOON3-74
Could someone please adjust the description of the COCOON project to indicate that it is only for C2 and not C3, so that newcomers who take the time to file JIRA issues don't stumble over this?
Thanks,
Lars
On 8/5/2011 12:39 AM, Nathaniel, Alfred wrote:
> Please open the issue under https://issues.apache.org/jira/browse/COCOON3 since the COCOON project in JIRA is for C2 related issues.
>
> Cheers, Alfred.
>
> -----Original Message-----
> From: Lars Huttar [mailto:language-maps_intl@sil.org]
> Sent: Freitag, 5. August 2011 00:31
> To: users@cocoon.apache.org
> Cc: Simone Tripodi
> Subject: Re: database access in Cocoon 3?
>
> On 8/1/2011 2:03 PM, Simone Tripodi wrote:
>> Hi guys!!!
>> would you mind to fill an Issue on Cocoon bug tracker for this feature request?
>> Many thanks in advance, have a nice day!!!
>> Simo
>>
>> http://people.apache.org/~simonetripodi/
>> http://www.99soft.org/
> I didn't realize I could do this!
>
> Here's the new issue:
> https://issues.apache.org/jira/browse/COCOON-2312
>
> Lars
>
>
> The content of this e-mail is intended only for the confidential use of the person addressed.
> If you are not the intended recipient, please notify the sender and delete this e-mail immediately.
> Thank you.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
RE: database access in Cocoon 3?
Posted by "Nathaniel, Alfred" <Al...@six-group.com>.
Please open the issue under https://issues.apache.org/jira/browse/COCOON3 since the COCOON project in JIRA is for C2 related issues.
Cheers, Alfred.
-----Original Message-----
From: Lars Huttar [mailto:language-maps_intl@sil.org]
Sent: Freitag, 5. August 2011 00:31
To: users@cocoon.apache.org
Cc: Simone Tripodi
Subject: Re: database access in Cocoon 3?
On 8/1/2011 2:03 PM, Simone Tripodi wrote:
> Hi guys!!!
> would you mind to fill an Issue on Cocoon bug tracker for this feature request?
> Many thanks in advance, have a nice day!!!
> Simo
>
> http://people.apache.org/~simonetripodi/
> http://www.99soft.org/
I didn't realize I could do this!
Here's the new issue:
https://issues.apache.org/jira/browse/COCOON-2312
Lars
The content of this e-mail is intended only for the confidential use of the person addressed.
If you are not the intended recipient, please notify the sender and delete this e-mail immediately.
Thank you.
Re: database access in Cocoon 3?
Posted by Lars Huttar <la...@sil.org>.
On 8/1/2011 2:03 PM, Simone Tripodi wrote:
> Hi guys!!!
> would you mind to fill an Issue on Cocoon bug tracker for this feature request?
> Many thanks in advance, have a nice day!!!
> Simo
>
> http://people.apache.org/~simonetripodi/
> http://www.99soft.org/
I didn't realize I could do this!
Here's the new issue:
https://issues.apache.org/jira/browse/COCOON-2312
Lars
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: database access in Cocoon 3?
Posted by Simone Tripodi <si...@apache.org>.
Hi guys!!!
would you mind to fill an Issue on Cocoon bug tracker for this feature request?
Many thanks in advance, have a nice day!!!
Simo
http://people.apache.org/~simonetripodi/
http://www.99soft.org/
2011/7/29 Frank <fr...@tpg.com.au>:
> Hello,
>
> I would agree on the need of an SQL transformer.
>
> We have a significant investment in 2.1 code using the SQL transformer. We don't intend to look at cocoon 3.0 until production release (mainly because we are a small group and don't have the time or resources to evaluate at this stage)
> But in order to upgrade our sitemap code to a version that does not have such a transformer would be too costly. At worst we would have to develop our own transformer when the time comes.
>
> This would not be ideal as i am sure we don't have the same level of expertise in the java/cocoon 3.0 framework as the Apache developers. So I would agree with Lars and request that the team include an SQL transformer in the framework.
>
> Cheers,
> Frank
>
> On 29/07/2011, at 2:47 AM, Lars Huttar wrote:
>
>> On 7/28/2011 2:26 AM, Francesco Chicchiriccò wrote:
>>> On 28/07/2011 00:32, Lars Huttar wrote:
>>>> Hello,
>>>>
>>>> In the past (Cocoon 2.1) we used XSP pages for database queries to return results as XML for processing in Cocoon pipelines.
>>>>
>>>> Looking toward the future with 2.2 and beyond, we saw that XSP pages were deprecated, so we started using SQL transformer instead.
>>>>
>>>> With Cocoon 3.0, is the SQL transformer still part of the picture? (I don't see it among the samples.) Or is there something else that is recommended for grabbing data from a database as input to a pipeline?
>>>
>>> Not as far as I know: anyway, nothing obstacles to add it in cocoon-optional or - better - in a separate module.
>>> Nowadays there are many choices (JPA, iBatis, ...) not available at the time of the SQL transformer...
>>>
>>> Regards.
>>>
>>
>> Thanks for this reply.
>> Is there any way I can contribute toward SQL transformer (or a replacement) being added to Cocoon 3?
>> I know basic Java development, but am not familiar with the various libraries and frameworks involved (spring, maven, avalon, etc.).
>>
>> Some kind of database input is central to the web apps we are developing (as it is to most web apps, I suppose), so having this functionality early on will determine whether going with C3 is feasible for us.
>>
>> Regards,
>> Lars
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
>> For additional commands, e-mail: users-help@cocoon.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: database access in Cocoon 3?
Posted by Frank <fr...@tpg.com.au>.
Hello,
I would agree on the need of an SQL transformer.
We have a significant investment in 2.1 code using the SQL transformer. We don't intend to look at cocoon 3.0 until production release (mainly because we are a small group and don't have the time or resources to evaluate at this stage)
But in order to upgrade our sitemap code to a version that does not have such a transformer would be too costly. At worst we would have to develop our own transformer when the time comes.
This would not be ideal as i am sure we don't have the same level of expertise in the java/cocoon 3.0 framework as the Apache developers. So I would agree with Lars and request that the team include an SQL transformer in the framework.
Cheers,
Frank
On 29/07/2011, at 2:47 AM, Lars Huttar wrote:
> On 7/28/2011 2:26 AM, Francesco Chicchiriccò wrote:
>> On 28/07/2011 00:32, Lars Huttar wrote:
>>> Hello,
>>>
>>> In the past (Cocoon 2.1) we used XSP pages for database queries to return results as XML for processing in Cocoon pipelines.
>>>
>>> Looking toward the future with 2.2 and beyond, we saw that XSP pages were deprecated, so we started using SQL transformer instead.
>>>
>>> With Cocoon 3.0, is the SQL transformer still part of the picture? (I don't see it among the samples.) Or is there something else that is recommended for grabbing data from a database as input to a pipeline?
>>
>> Not as far as I know: anyway, nothing obstacles to add it in cocoon-optional or - better - in a separate module.
>> Nowadays there are many choices (JPA, iBatis, ...) not available at the time of the SQL transformer...
>>
>> Regards.
>>
>
> Thanks for this reply.
> Is there any way I can contribute toward SQL transformer (or a replacement) being added to Cocoon 3?
> I know basic Java development, but am not familiar with the various libraries and frameworks involved (spring, maven, avalon, etc.).
>
> Some kind of database input is central to the web apps we are developing (as it is to most web apps, I suppose), so having this functionality early on will determine whether going with C3 is feasible for us.
>
> Regards,
> Lars
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: database access in Cocoon 3?
Posted by Lars Huttar <la...@sil.org>.
On 8/2/2011 3:53 AM, Thorsten Scherler wrote:
> On Thu, 2011-07-28 at 11:47 -0500, Lars Huttar wrote:
>> On 7/28/2011 2:26 AM, Francesco Chicchiriccò wrote:
>>> On 28/07/2011 00:32, Lars Huttar wrote:
>>>> Hello,
>>>>
>>>> In the past (Cocoon 2.1) we used XSP pages for database queries to
>>>> return results as XML for processing in Cocoon pipelines.
>>>>
>>>> Looking toward the future with 2.2 and beyond, we saw that XSP pages
>>>> were deprecated, so we started using SQL transformer instead.
>>>>
>>>> With Cocoon 3.0, is the SQL transformer still part of the picture? (I
>>>> don't see it among the samples.) Or is there something else that is
>>>> recommended for grabbing data from a database as input to a pipeline?
>>> Not as far as I know: anyway, nothing obstacles to add it in
>>> cocoon-optional or - better - in a separate module.
>>> Nowadays there are many choices (JPA, iBatis, ...) not available at
>>> the time of the SQL transformer...
>>>
>>> Regards.
>>>
>> Thanks for this reply.
>> Is there any way I can contribute toward SQL transformer (or a
>> replacement) being added to Cocoon 3?
> Yes there is. :) Please have a look on my commit r1142136 there I
> migrated the "old" DirectoryGenerator.java to c3. With this commit you
> can see the main tasks involved.
Can you tell me where to find commit r1142136?
Thanks,
Lars
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: database access in Cocoon 3?
Posted by Thorsten Scherler <sc...@gmail.com>.
On Thu, 2011-07-28 at 11:47 -0500, Lars Huttar wrote:
> On 7/28/2011 2:26 AM, Francesco Chicchiriccò wrote:
> > On 28/07/2011 00:32, Lars Huttar wrote:
> >> Hello,
> >>
> >> In the past (Cocoon 2.1) we used XSP pages for database queries to
> >> return results as XML for processing in Cocoon pipelines.
> >>
> >> Looking toward the future with 2.2 and beyond, we saw that XSP pages
> >> were deprecated, so we started using SQL transformer instead.
> >>
> >> With Cocoon 3.0, is the SQL transformer still part of the picture? (I
> >> don't see it among the samples.) Or is there something else that is
> >> recommended for grabbing data from a database as input to a pipeline?
> >
> > Not as far as I know: anyway, nothing obstacles to add it in
> > cocoon-optional or - better - in a separate module.
> > Nowadays there are many choices (JPA, iBatis, ...) not available at
> > the time of the SQL transformer...
> >
> > Regards.
> >
>
> Thanks for this reply.
> Is there any way I can contribute toward SQL transformer (or a
> replacement) being added to Cocoon 3?
Yes there is. :) Please have a look on my commit r1142136 there I
migrated the "old" DirectoryGenerator.java to c3. With this commit you
can see the main tasks involved.
> I know basic Java development, but am not familiar with the various
> libraries and frameworks involved (spring, maven, avalon, etc.).
I had a quick look on the SQLTransformer and besides the
avalon/excalibur there is not too much rewrite. The basic datasource
would be configured in spring and not in the xconf and the methods
service/configure/setup/recycle/dispose would be removed/adopted to the
c3 way of doing things.
I would estimate 0.5-1 MT for the rewrite including test cases. I am ATM
only able to work on stuff related to my work but I am more then willing
to review and help with the migration via eMail. However the
SQLTransformer is very low on my personal todo because like other
pointed out there a lots of ORM tools which can be quickly integrated
into cocoon and are much more powerful, but the nice thing on the
sqltransformer is that is very generic I admit.
If you are need it quickly integrated/migrated my company codeBusters.es
offers profesional support. just contact me about a quote if you are
interested.
> Some kind of database input is central to the web apps we are developing
> (as it is to most web apps, I suppose), so having this functionality
> early on will determine whether going with C3 is feasible for us.
I agree that such an integration example would be most welcome in a new
module cocoon-db + cocoon-db-sample.
salu2
--
Thorsten Scherler <thorsten.at.codebusters.es>
codeBusters S.L. - web based systems
<consulting, training and solutions>
Tel.: +34 954 520 169
http://www.codebusters.es/
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: database access in Cocoon 3?
Posted by Lars Huttar <la...@sil.org>.
On 7/28/2011 2:26 AM, Francesco Chicchiriccò wrote:
> On 28/07/2011 00:32, Lars Huttar wrote:
>> Hello,
>>
>> In the past (Cocoon 2.1) we used XSP pages for database queries to
>> return results as XML for processing in Cocoon pipelines.
>>
>> Looking toward the future with 2.2 and beyond, we saw that XSP pages
>> were deprecated, so we started using SQL transformer instead.
>>
>> With Cocoon 3.0, is the SQL transformer still part of the picture? (I
>> don't see it among the samples.) Or is there something else that is
>> recommended for grabbing data from a database as input to a pipeline?
>
> Not as far as I know: anyway, nothing obstacles to add it in
> cocoon-optional or - better - in a separate module.
> Nowadays there are many choices (JPA, iBatis, ...) not available at
> the time of the SQL transformer...
>
> Regards.
>
Thanks for this reply.
Is there any way I can contribute toward SQL transformer (or a
replacement) being added to Cocoon 3?
I know basic Java development, but am not familiar with the various
libraries and frameworks involved (spring, maven, avalon, etc.).
Some kind of database input is central to the web apps we are developing
(as it is to most web apps, I suppose), so having this functionality
early on will determine whether going with C3 is feasible for us.
Regards,
Lars
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: database access in Cocoon 3?
Posted by Francesco Chicchiriccò <il...@apache.org>.
On 28/07/2011 00:32, Lars Huttar wrote:
> Hello,
>
> In the past (Cocoon 2.1) we used XSP pages for database queries to
> return results as XML for processing in Cocoon pipelines.
>
> Looking toward the future with 2.2 and beyond, we saw that XSP pages
> were deprecated, so we started using SQL transformer instead.
>
> With Cocoon 3.0, is the SQL transformer still part of the picture? (I
> don't see it among the samples.) Or is there something else that is
> recommended for grabbing data from a database as input to a pipeline?
Not as far as I know: anyway, nothing obstacles to add it in
cocoon-optional or - better - in a separate module.
Nowadays there are many choices (JPA, iBatis, ...) not available at the
time of the SQL transformer...
Regards.
--
Francesco Chicchiriccò
Apache Cocoon Committer and PMC Member
http://people.apache.org/~ilgrosso/
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org