XSP esql problem with Cocoon 2.1.2

[Sylvain.Thevoz]

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.newInstance(JdbcConnectionFactory.java:185)
        at 
org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLimitingPool.java:672)
etc...
**error**

Thanks
Sylvain

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]