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]>

Reply via email to