final Connection connection = DriverManager.getConnection("jdbc:mondrian:Jdbc=jdbc:mysql:3306//localhost//qms23; "
                + "JdbcUser=qms;"
                + "JdbcPassword=qms; "
                + "Catalog=c:\\Project\\workbench\\fbplayers.xml; "
//                        "jdbc:mondrian:Jdbc=jdbc:mysql:localhost:3306/qms23; JdbcUser=qms; JdbcPassword=qms; CatalogContent= c:\\Project\\workbench\\fbplayers.xml;"
//                        "jdbc:mondrian:" // Driver ident
//                        + "JdbcDrivers=com.mysql.jdbc.Driver;" // Relational driver
//                        + "Jdbc=jdbc:mysql://localhost:3306/qms23?user=qms&password=qms;" // Relational DB
//                        + "Catalog=file:c:\\Project\\workbench\\fbplayers.xml;"
                );   

log4j:WARN No appenders could be found for logger (mondrian.olap.MondrianProperties).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql:3306//localhost//qms23; JdbcUser=qms; JdbcPassword=qms
	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972)
	at mondrian.olap.Util.newInternal(Util.java:2403)
	at mondrian.olap.Util.newError(Util.java:2419)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:246)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:188)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216)
	at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:214)
	at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:66)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:90)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
	at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:153)
	at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
	at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
	at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
	at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:233)
	at mondrian.dao.MondrianConnect.main(MondrianConnect.java:16)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql:3306//localhost//qms23
	at java.sql.DriverManager.getConnection(DriverManager.java:596)
	at java.sql.DriverManager.getConnection(DriverManager.java:187)
	at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:226)
	... 16 more
------------------------------------------------------------------------
BUILD FAILURE
------------------------------------------------------------------------
Total time: 12.760s
Finished at: Tue Jan 28 16:07:58 YEKT 2014
Final Memory: 6M/244M
------------------------------------------------------------------------
Failed to execute goal org.codehaus.mojo:exec-maven-plugin:1.2.1:exec (default-cli) on project Mondrian: Command execution failed. Process exited with an error: 1 (Exit value: 1) -> [Help 1]

To see the full stack trace of the errors, re-run Maven with the -e switch.
Re-run Maven using the -X switch to enable full debug logging.

For more information about the errors and possible solutions, please read the following articles:
[Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException

import org.olap4j.*;
import org.olap4j.metadata.Member;
import org.olap4j.metadata.Cube;
import org.olap4j.metadata.NamedList;

import java.sql.*;

public class MondrianTest {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("mondrian.olap4j.MondrianOlap4jDriver");
        Class.forName("com.mysql.jdbc.Driver");

        OlapConnection olapConnection = (OlapConnection) DriverManager.getConnection(
                "jdbc:mondrian:" // Driver ident
                + "JdbcDrivers=com.mysql.jdbc.Driver;" // Relational driver
                + "Jdbc=jdbc:mysql://localhost:3306/qms23?user=qms&password=qms;" // Relational DB
                + "Catalog=c:\\Project\\workbench\\fbplayers.xml; "
        );

        NamedList<Cube> cubes = ((OlapConnection) olapConnection).getOlapSchema().getCubes();

        OlapStatement olapStatement = (OlapStatement) olapConnection.createStatement();

        String mdx = "SELECT\n"
                + "NON EMPTY {Hierarchize({[Measures].[VisitorWorkplace]})} ON COLUMNS,\n"
                + "NON EMPTY {Hierarchize({[Workplace.WorkplaceHierarchy].[WorkplaceLevel].Members})} ON ROWS\n"
                + "FROM [visitor]";

        CellSet cellSet = olapStatement.executeOlapQuery(mdx);

        for (Position row : cellSet.getAxes().get(1)) {
            for (Position column : cellSet.getAxes().get(0)) {
                for (Member member : row.getMembers()) {
                    System.out.println(member.getUniqueName());
                }
                for (Member member : column.getMembers()) {
                    System.out.println(member.getUniqueName());
                }
                final Cell cell = cellSet.getCell(column, row);
                System.out.println(cell.getFormattedValue());
                System.out.println();
            }
        }
    }
}