Because the connection is explicitaly coded as a parameter in a sitemap and
you have more controls over the parameter it seems: see
http://cocoon.apache.org/2.1/userdocs/transformers/sql-transformer.html
But rereading your mail, I don't understand what you intend to do: share the
connections? The SQL? The result?
<map:transform type="sql">
<map:parameter name="use-connection" value="personnel"/>
<map:parameter name="show-nr-of-rows" value="true"/>
<map:parameter name="clob-encoding" value="UTF-8"/>
</map:transform>
Le Mercredi 28 Janvier 2004 10:41, Olivier Billard a �crit :
> Hi Nicolas,
>
> Thanks for your answer.
> How could the SQL transformer help ?
>
> On 28/01/2004 10:41, Nicolas Toper wrote:
> > Bad but working & easy :=) if your ESQL is only called once a time it's
> > OK. Otherwise, why not try the SQL Transformer?.
> >
> > Le Mercredi 28 Janvier 2004 10:30, Olivier Billard a �crit :
> >>Hi Cocooners !
> >>
> >>I use the esql stylesheet to execute a transaction. But I would like to
> >>isolate the most business code possible in a java component, and sharing
> >>the transaction to this component.
> >>
> >>The ESQLConnection is meant to be hidden and abstracted by the
> >> stylesheet, so it would be baaad to do something like
> >>
> >>myComponent.dealWithBusinessCode(_esql_connection, ...);
> >>
> >>So what is the best way to do this ?
> >>Thanks,
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
