PDA

View Full Version : Newbie question:mondrian.properties not found



chang33
09-24-2003, 10:37 PM
Hi there,
When I clicked "JPivot pivot table" from Mondrian web examples.
I got the message in Tomcat console.
Mondrian: Warning: file 'C:\Program Files\Apache Group\Tomcat 4.1\mondrian.properties' not found
Mondrian: loaded 0 system properties
Mondrian: JDBC driver sun.jdbc.odbc.JdbcOdbcDriver loaded successfully
Mondrian: Warning: JDBC driver org.hsqldb.jdbcDriver not found
Mondrian: JDBC driver oracle.jdbc.OracleDriver loaded successfully
Mondrian: Warning: JDBC driver com.mysql.jdbc.Driver not found
And I got the message in web browser.
org.apache.jasper.JasperException: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I had imported the oracle data and these are my env.
Apache Tomcat/4.1.27
j2sdk1.4.1_05
Any ideas?
Thanks in advance.

chang33
09-24-2003, 11:40 PM
Hi,
I just copied the mondrian.war to tomcat/webapps.
There is a question comes to me.
Where do I configure the database connect string?
The version is Mondrian 1.0.1.
Thanks in advance.

sgwood
09-25-2003, 12:40 AM
Check out the Mondrian project home page at
http://apoptosis.dyndns.org:8080/open/mondrian/doc/index.html.
The Download/Install menu item has Section 6, "Run the web app", with some explanation about configuration.
To fix the missing mondrian.properties, take the one in the bin folder and modify it for your needs. Have you got the demo FoodMart database set up?

chang33
09-25-2003, 04:29 PM
Hi,
These were what I did.
1) build the Mondrian 1.0.1 source code(SUCCESSFUL)
2) deploy to tomcat 4.1.27 (SUCCESSFUL)
3) Copy mondrian.properties to C:\Program Files\Apache Group\Tomcat 4.1
When I clicked "JPivot pivot table" from Mondrian web examples. I still got the error message like my first post.
What's wrong and where should I set the database connect string?
It seems that my database connect string setting is wrong.
Thanks.

chang33
09-25-2003, 04:34 PM
Hi,
Yes, I have got the demo FoodMart and import to my oracle database.
When I Run build deploy-webapp, it said "Target `deploy-webapp' does not exist in this project."
So I run "build deploy-war and it successed.
After that, I still got the same error.
Any ideas?
thanks.

chang33
09-25-2003, 09:37 PM
Hi,
I put the mondrian.properties in C:/, and I modified the mondrian.olap.MondrianProperties to read the file.
private static final String mondrianDotProperties = "/mondrian.properties";
After redeployed the mondrian.war, mondrian.properties could be read.
When I clicked "JPivot pivot table" from Mondrian web examples, I got the message in web browser.
org.apache.jasper.JasperException: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
I imported the foodmart data to my oracle database.
What's wrong with my mondrian.properties?
This is my mondrian.properties.
----
mondrian.jdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver,oracle.jdbc.OracleDriver,com.mysql.jdbc.Driver
mondrian.foodmart.jdbcURL=jdbc:oracle:oci8:foodmart/foodmart@helpdesk
catalina.home=C:/Program Files/Apache Group/Tomcat 4.1
----
Thanks in advance.

sgwood
09-25-2003, 11:57 PM
Now I see your problem.
The webapp distributed with Mondrian includes JPivot. The link you are selecting is part of JPivot.
In the mondrian.war that is distributed with Mondrian, you will find testpage.jsp, which uses another jsp, mondrian.jsp. The JPivot tag in mondrian.jsp is where the DataSource is defined, not mondrian.properties. The standard mondrian.jsp uses the JDBC/ODBC bridge to get to the database. You can create an ODBC datasource or change the tag parameters in mondrian.jsp to be the same as what you have in your current mondrian.properties.
Cheers,
Sherman

ebengtso
09-26-2003, 12:00 AM
Do you have this ?
mondrian.test.connectString=\
Provider=mondrian;\
Jdbc=jdbc:oracle:oci8:foodmart/foodmart@helpdesk;\
Catalog=/WEB-INF/queries/FoodMart.xml;\
JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver,oracle.jdbc.OracleDriver,com.mysql.jdbc.Driver;\
mondrian.foodmart.jdbcURL=jdbc:oracle:oci8:foodmart/foodmart@helpdesk

chang33
09-26-2003, 12:04 AM
Got it.
Thanks a lot.