You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Sy...@swisscom.com on 2003/11/18 15:43:50 UTC
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(JdbcConnectionFactory.java:185)
at org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLimitingPool.java:672)
etc...
**error**
Thanks
Sylvain
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: XSP esql problem with Cocoon 2.1.2
Posted by julien bloit <Ju...@ircam.fr>.
Hi Sylvain,
Didn't you simply forget to copy your database connector in
cocoon/web-inf/lib ?
Regards,
Julien
----- Original Message -----
From: <Sy...@swisscom.com>
To: <us...@cocoon.apache.org>
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
AW: XSP esql problem with Cocoon 2.1.2
Posted by Markus Heussen <he...@rheinland-online.com>.
Are u sure you have configured the driver in your web.xml and the jdbc
connection in cocoon.xconf?
-----Ursprüngliche Nachricht-----
Von: Sylvain.Thevoz@swisscom.com
Gesendet: Dienstag, 18. November 2003 15:44
An: users@cocoon.apache.org
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org