wso2 manager - com.mysql.jdbc.Driver not found

Question

I've downloaded WSO2 Stratos 1.5.2 platform. I'm trying to start wso2stratos-manager-1.5.2, but it doesn't find the mysql jdbc driver

[2012-08-08 16:31:15,201] ERROR {org.wso2.carbon.user.core.util.DatabaseUtil} - Database Error - Cannot load JDBC driver class 'com.mysql.jdbc.Driver' org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

Solmization

Answer 1

I believe you're trying to use a mysql database as the backend database of the user management repository. Did you put the MySQL JDBC driver to MANAGER_HOME/repository/components/lib directory?

Regards, Prabath

Gilboa

there's already mysql-connector-java-5.1.12-bin.jar in MANAGER_HOME/repository/components/lib. FYI, I managed to start the Identity Server successfully. – Solmization

Can you please check whether there's any spaces (before/after) in the driver class name specified in "user-mgt.xml"? – Gilboa

There's no blank space. Notice that I didn't have to add the driver jar myself, it was already embedded in the stratos package. – Solmization

As Rob Church says in below comment: "The target directory has changed for Enterprise Integrator. You should place the driver in <EI_HOME>/lib directory." – Elidiaelie

Answer 2

We do not ship the mysql-connector jar with our packs due to license issues. Therefore you need to copy the jar to repository/components/lib folder as mentioned in Prabath's reply.

Regards, Amila.

Motorboating

mysql-connector-java-5.1.12-bin.jar is in MANAGER_HOME/repository/components/lib, so you do ship the mysql driver in stratos package. – Solmization

mine didn't have the jar – Stowage

I cannot recall about what @Solmization has mentioned since it is about an old product. But we cannot ship the driver due to the license mismatches I have mentioned. – Motorboating

Answer 3

As mentioned by others but adding specific details.

When configuring the Datasource Driver in many of the WSO2 products you need to specify the class name of the JDBC driver to use.

Make sure to copy the JDBC driver relevant to the database engine to the /repository/components/lib/ directory.

For example, if you are using MySQL, specify com.mysql.jdbc.Driver as the driver and copy mysql-connector-java-5.XX-bin.jar file to this directory.

If you do not copy the driver to this directory when you create the datasource, you will get an exception similar to Cannot load JDBC driver class com.mysql.jdbc.Driver.

Birmingham

The target directory has changed for Enterprise Integrator. You should place the driver in <EI_HOME>/lib directory. – Birmingham

Answer 4

Driver name is "com.mysql.jdbc.Driver". JAR file (mysql-connector-java-x.xx.xx.jar) must be present in MANAGER_HOME/repository/components/lib

Paripinnate

Answer 5

I solved by adding the mysql jar file at the directory

C:\Program Files\WSO2\Identity Server\6.1.0\repository\components\lib

You can download jar by the following link: https://mvnrepository.com/artifact/mysql/mysql-connector-java/8.0.20

After that you should restart the WSO2 server

Stubble