Mondrian Cannot find schema in VFS when used in Webapp

Question

I have a webapp, I'm trying to use Mondrian internally. And I get the following exception when I try to open a connection:

Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: /WEB-INF/olap/mycube.xml 

I tested this cube with a simple J2SE program from the command line and it works fine. However, when I tried to execute the same cube in my web application, I got the error above. My connection string is as follows:

 jdbc:mondrian:Jdbc=jdbc:mysql://${server.db.host}/HRWarehouse?user=${server.db.username}&password=${server.db.password};Catalog=/WEB-INF/olap/mycube.xml; 

This is very similar to what I found in the Mondrian web application. However, somehow this application installed ServletContext in VFS, but there is exactly zero documentation there that I can find through google about any special configuration for mondrian in the web application.

I worked on the problem by setting the path to the schema as an absolute link instead of relating to the webapp context. Although this allowed me to continue testing, this is not a suitable solution to the problem. I am looking for an answer on how to fix an exception that allows a relative webapp context URL.

Answer 1

I think you need to specify the working file in the Directory,

  `jdbc:mondrian:Jdbc=jdbc:mysql://${server.db.host}/HRWarehouse?user=${server.db.username}&password=${server.db.password};Catalog=file:/path/to/schema.xml;` 

I can’t remember whether it was an absolute path or not, try both times.

I would also double check the connection string to make sure it is spelled correctly. In addition, here is a link that may be useful if you do not already have one.

Update Try adding jndi:/ at the beginning of your path: jndi:/localhost/path/to/file.xml