Re: XSP esql problem with Cocoon 2.1.2

[julien bloit]

Hi Sylvain,
Didn't you simply forget to copy your database connector in
cocoon/web-inf/lib ?

Regards,
Julien

----- Original Message ----- 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 3:43 PM
Subject: 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]