AW: XSP esql problem with Cocoon 2.1.2

[Markus Heussen]

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.newInstance(Jdb
cConnectionFactory.java:185)
        at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(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]