hi folks,
i'm totally stuck trying to connect cocoon (2.0.3) to firebird.
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate():
java.lang.RuntimeException: Could not get the datasource
org.apache.avalon.excalibur.datasource.NoValidConnectionException:
No valid JdbcConnection class available
* i'm loading the driver in web.xml, works:
DEBUG (2002-12-07) 19:43.13:516 [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class:
org.firebirdsql.jdbc.FBDriver
* i set up the connection pool in cocoon.xconf:
<jdbc name="fire">
<pool-controller min="5" max="10"/>
<dburl>jdbc:firebirdsql:localhost/3050:H:\\interbase\\firebird</dburl>
<user>sysdba</user>
<password>masterkey</password>
</jdbc>
using the very same settings in a small java programm works.
* i am using the following xsp:
<esql:connection>
<esql:pool>mysql</esql:pool>
<esql:execute-query>
<esql:query>select * from test</esql:query>
<esql:results>
<esql:row-results>
<esql:get-string column="id"/>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
after having no success for more than a week i tried mysql and get the
same results - jdbc driver works in "normal" java enviroment, but i get
this "no jdbcConnection" message.
can anyone help me?
thank you,
nils
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>