Thank you for information, I did not try connection pooling.
What I was thinking of, was to store database and database account
in one place, to avoid modification of many documents when changing
db accout password.
With connection pool I probably can solve this problem, am I right?
Where can I configure pooling for my esql logicsheets ? And how to
use it? (example or where can I find it?)
Regards,
Oskar Werewka
>Oskar,
>
>would a connection pool not work for you? It is much easier than what you
>want to do, and performance is better, too (since you don't wait to log in
>every time.) However, if you really want to do this, you should be able to
>by creating a logicsheet. Your logicsheet would have a template something
>like this:
>
><xsl:template match="connect:login">
> <esql:driver>....</esql:driver>
> <esql:dburl>....</esql:dburl>
> etc.
></xsl:template>
>
>and then you can use this logicsheet with your XSP, like:
>
><esql:connection>
> <connect:login/>
> <esql:execute-query>
> etc.
>
>Both your logicsheet and your XSP file would need to declare the esql
>namespace.
>
>-Christopher
>
>
>
>
>Please respond to [EMAIL PROTECTED]
>
>To: [EMAIL PROTECTED]
>cc:
>
>Subject: esql connection basic
>
>
>
>I have this (sample):
>
> <esql:connection>
> <esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
> <esql:dburl>jdbc:oracle:thin:oskarw/............
>@dbsrv:1527:desy</esql:dburl>
> <esql:execute-query>
> <esql:query>select * from helpdesk_labels</esql:query>
> <esql:results>
> <esql:row-results>
> <esql:get-columns/>
> <!--<user><esql:get-string column="labid"/></user>-->
> </esql:row-results>
> </esql:results>
> <esql:no-results>
> <user>No employees</user>
> </esql:no-results>
> </esql:execute-query>
> </esql:connection>
>
>and want to have one style sheet where can I define
>a database connection, how can I divide it?
>
>That means how can I divide query and connection
>definition.
>
>Thank you for help.
>
>Regards,
>Oskar Werewka
>
>
>
>
>
>---------------------------------------------------------------------
>Please check that your question has not already been answered in the
>FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
>To unsubscribe, e-mail: <[EMAIL PROTECTED]>
>For additional commands, e-mail: <[EMAIL PROTECTED]>
--
Kamera wideo Sony, 5000 zl
wygraj w konkursie eMarketu i Onet.pl [ http://konkursy.onet.pl/emarket ]
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
