xsp with sql worked in cocoon1.7.4 but not in 1.8 anymore ?!

[Gabi Brysch <br...@inxnet.de>]

XSL dynamic ?hi,

[win2000, tomcat3.1, cocoon1.8]

i had some xsp's samples including sql-tags which worked in cocoon 1.7.4
without problems - but now i used them
with cocoon 1.8 and they don't work anymore - what's wrong ???

this is the exception i get:
>
java.sql.SQLException: General error
	at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:6160)
	at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:2742)
	at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:838)
	at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:736)
	at
org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery(XSPSQ
LLibrary.java:185)
	at
_D_._CocoonProjekt._jakartaTomcat31._jakarta_tomcat._webapps._intranet._tran
sformTwoDB._testDB2.populateDocument(_testDB2.java:104)
	at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
	at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:494)
	at org.apache.cocoon.Engine.handle(Engine.java:359)
	at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
	at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
	at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:160)
	at
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
)
	at java.lang.Thread.run(Thread.java:484)
>

the jdbc-odbc-bridge - driver doesn't appear in the cocoon.properties file -
this might be the reason ???

is there anybody who knows this problem ???

thanks, gabi