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]>
