Hi,
Not in web.xml!
I just have added this:
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- For Database Driver - XSP -->
com.microsoft.jdbc.sqlserver.SQLServerDriver
</param-value>
</init-param>
But I have lot of problems with XSP and a king of caching mechanism when I make some
modifications in XSP pages.
Even if I restart Tomcat the pages are not updated in the browser.
Have you an idea what's this problem?
Thanks
Sylvain
> -----Message d'origine-----
> De: Markus Heussen [mailto:[EMAIL PROTECTED]
> Date: mardi, 18. novembre 2003 15:54
> �: [EMAIL PROTECTED]
> Objet: AW: XSP esql problem with Cocoon 2.1.2
>
>
> Are u sure you have configured the driver in your web.xml and the jdbc
> connection in cocoon.xconf?
>
> -----Urspr�ngliche Nachricht-----
> Von: [EMAIL PROTECTED]
> Gesendet: Dienstag, 18. November 2003 15:44
> An: [EMAIL PROTECTED]
> Betreff: XSP esql problem with Cocoon 2.1.2
>
>
> Hello,
>
> Since I migrated a xsp application to Cocoon 2.1.2 this esql
> code produces
> the error below.
> Is someone has a idea?
>
> **code**
> <esql:connection>
> <esql:pool>wfmgt</esql:pool>
> <esql:execute-query>
> <esql:query>SELECT ur_sector, ur_fullname, ur_role FROM
> Users WHERE
> ur_name = 'TFRTHSY1'</esql:query>
> <esql:results>
> <esql:row-results>
> <xsp:logic>
> sector = <esql:get-string column="ur_sector"/>;
> session.setAttribute("sector",sector);
> user = <esql:get-string column="ur_fullname"/>;
> session.setAttribute("user",user);
> role = <esql:get-string column="ur_role"/>;
> session.setAttribute("role",role);
> </xsp:logic>
> </esql:row-results>
> </esql:results>
> </esql:execute-query>
> </esql:connection>
> **code**
>
> **error**
> ERROR (2003-11-18) 15:23.34:842
> [sitemap.sitemap.generator.serverpages]
> (/woc_cocoon_2.1.2/wfm/login) Thread-8/login_xsp:
> java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getConnection(Unknown Source)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at
> org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.n
> ewInstance(Jdb
> cConnectionFactory.java:185)
> at
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoola
> ble(ResourceLi
> mitingPool.java:672)
> etc...
> **error**
>
> Thanks
> Sylvain
>
> ---------------------------------------------------------------------
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
