I have already configured the pooling, thank you ;)
>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]>
--
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]>
