Database access problem - Linux

[Michael Mangeng <mi...@ideefix.net>]

Hi

I´ve encountered a funny Problem. I´ve started developing a little webapp
which uses esql to grab data from the db, the DatabaseAuthenticatorAction to
login and a self written action to auth the user at each request which
simply checks for a attribute in the session. I´ve started creating this
webapp under WinXP, J1.4.0, Tomcat 4.0.4-b2 and Cocoon2.0.2. Now i´ve packed
all into a .war and deployed this on a linux2.4.17 box with Tomcat4.0.4-b3,
J1.4.0 and Cocoon2.0.2. (Database is a mysqld @ linux. The WinXP connects to
the linux mysqld, the linux box to itself.)

With WinXP the Authentification works fine. After a correct login the user
can see the index page, menues, etc.
With Linux i cannot do the Login. All is exactly the same. (The
FormValidationActione all works, The dbAuth not.).

Errorpage shows:
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
... but there IS is a connection...

Wathing the mysql-log shows each time i make a login-request:
###
020526 23:19:16       2 Connect     tms@localhost on
                      2 Init DB     tms
                      2 Query       SHOW VARIABLES
###
... with a view Quits... (pooling) But there is no query.
Thats the DatabaseAuthenticatorAction...

Then i´ve started to make some test pages.
I´ve discovered that as soon as i use the esql logicsheet on a page it
generates the "No valid JdbcConnection class available
" error. But i do not know why because tomcat definitly creats the
connections.

In web.xml i´m using:
    <init-param>
      <param-name>load-class</param-name>
      <param-value>org.gjt.mm.mysql.Driver</param-value>
    </init-param>

cocoon.xconf:
        <jdbc name="tms">
            <pool-controller min="2" max="10"/>
            <dburl>jdbc:mysql://hermes.vis.at:3306/tms</dburl>
            <user>tms</user>
            <password>***</password>
        </jdbc>

....

On my testpages i´m using a simply query to show a value. There cannot be a
typo because it works with WinXP.


Any ideas?

greetings
mike