How to connect pivot4j config.xml for mysql database rather than derby database

[surendiranganesan]

HI,

before going to the issue i have to tell one thing first

Pivot4j is awesome

now going to the issue,

I can able to connect pivot4j with XMLA but how to connect it to other database rather than derby [default one] .

I am using the below xml but pivot4j is not even loading after changing the derby database from the following code.

<datasource>
            <name>FoodMart Mondrian</name>
            <description>FoodMart sample data source.</description>

            <connection-info>
                <url>jdbc:mondrian:</url>
                <driverClass>mondrian.olap4j.MondrianOlap4jDriver</driverClass>

                <properties>
                    <property name="Catalog">file:${webRoot}${FS}Test.xml</property>
                    <property name="Jdbc">jdbc:mysql://localhost/test</property>
                    <property name="JdbcDrivers">com.mysql.jdbc.Driver</property>
                    <property name="JdbcUser">root</property>
                    <property name="JdbcPassword">pass</property>
                </properties>
            </connection-info>
        </datasource>   

Please help me how to connect pivot4j to other database rather than derby.

Regards,

[mysticfall]

Hi,

Provided that you have a working Mondrian/MySQL setup already, you should be able to run Pivot4J on top of it.

if you have encountered any problems, there should be a relevant stacktrace in your log file, so please see if you can find any error messages there and let me know the details.

Thanks!

[surendiranganesan]

Thank you Xavier .

I have successfully connected mysql with PIVOT 4J.

I am newbie to mondrian . can you please tell me where to see log files of pivot4J.

i am using tomcat 6 and i have placed the pivot4J war in the webapps folder.

Regards

[ptitpendit]

Hello,

I am also try to launch Pivot4j above one mysql database, which has already bean loaded by a mondrian archive and its test database.
But it seems that som serialization problem due to missing tables from the embedded derby schema prevents it to work correctly.

Could you please indicated to me how did you succeed to connect both MySql and Pivot4j, from github project directly, from War file analytics sample application ?

Due to my proxy configuration at work I cannot get all mandatories .jar files to build the source from github project :(

Regards, and thanks in advance for all the help you would bring to me
Julien (fr developer, bank company)

[mysticfall]

Hi Julien,

Basically, what surendiranganesan describes above is the correct way to connect to a Mysql database. If you see any errors, please post the full stacktrace here so I could investigate the issue further.

As to the proxy problem, I'm sorry to hear that your work environment has imposed such a limitation. I had a similar experience before and it was quite frustrating to me.

Anyway, I'm afraid there's no other way around than to manually collect any dependencies yourself and install them locally. The war distribution of Pivot4J contains major parts of its dependencies inside the archive, so it might be a good way to start.

But a better way would be use another computer to built the project and copy the whole ~/.m2 directory to your work desktop, probably via USB or DVD. It would be much easier that way.