This repository has been archived by the owner on Jul 24, 2019. It is now read-only.
This repository has been archived by the owner on Jul 24, 2019. It is now read-only.
How to connect pivot4j config.xml for mysql database rather than derby database #179
Open
Description
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,
Metadata
Assignees
Labels
No labels