Cannot load JDBC driver for class: com.mysql.jdbc.Driver

Hi All,

I have been using orbeon with Sql for quite some time now. With windows it has been working fine without any issues.
But at server end, where the application has to be loaded, I am facing issues. It is giving me the following error. The Operating System on the server is  Cent OS .

It seems in linux the jdbc connector has to be placed and dealt with in some different manner of which I have no idea at all.

Any help is welcome. Thanks in advance... Its Urgent

 org.orbeon.oxf.common.OXFException: Cannot load JDBC driver for class: com.mysql.jdbc.Driver
 at org.orbeon.oxf.processor.DatabaseContext.getConnection(DatabaseContext.java:98)
        at org.orbeon.oxf.processor.sql.SQLProcessorInterpreterContext.getConnection(SQLProcessorInterpreterContext.java:314)
        at org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:168)
  at org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:542)
        at org.orbeon.oxf.processor.sql.SQLProcessor$ForwardingContentHandler.endElement(SQLProcessor.java:634)
        at org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:544)

If you're using a separate <datasource> input for the SQL processor, you
need to make sure "mysql.jar" is in your web application's WEB-INF/lib
directory.

If you're using a connection pool - that is, if you have a line in your
SQL processor configuration like this:

<sql:datasource>my-datasource</sql:datasource>

then your database connection is being managed by your servlet
container, not by Orbeon. In this case, you need to make sure that
"mysql.jar" is in a directory where the servlet container will see it.
For Tomcat, that would be ${TOMCAT_HOME}/common/lib .

In that case, you also need to have the database connection configured
in your servlet container. For Tomcat, you can do this either in
server.xml or (preferably) in your webapp directory in META-INF/config,
which would look like this:

<Context antiResourceLocking="false"
          antiJARLocking="false"
          allowLinking="true"
          reloadable="false">
     <Resource name="jdbc/mysql" auth="Container"
               type="javax.sql.DataSource"
               initialSize="3" maxActive="10"
               maxIdle="20" maxWait="30000"
              driverClassName="com.mysql.jdbc.Driver"
              poolPreparedStatements="true"
               username="your_username"
              password="YOUR_PASSWORD"
url="jdbc:mysql://hostname.of.your.database:3306/databaseName"/>

</Context>

Of course, you may want to configure your connection pool differently,
but I hope this will give you an idea of where to start. If you're not
using Tomcat, then I can't help you with the details, but the same
principles should still apply.

</Jeff>

adev wrote:

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws