Errors while running the test suite

[chanduDB]

Hi there-

I am building/running the Mondrian project for the first time, and I am using a Intel based Mac.

>ant (Buiding the code) was successful.

After setting jdbc-url and jdbc-driver to proper values in several files I was able to solve most of the errors I got when I executed the test suite ( I came to know later that the proper way to set these is to change .properties files instead of chanding the files itself)

But now I am not sure what needs to be fixed for the following errors


>ant test

Buildfile: /usr/local/mondrian-3.1.2.13008/build.xml

version:

download-ivy:
[get] Getting: http://repo1.maven.org/maven2/org/ap...-2.0.0-rc2.jar
[get] To: /usr/local/mondrian-3.1.2.13008/ivy/ivy.jar
[get] Not modified - so not downloaded

install-ivy:

resolve:
[echo] symlink=true
[ivy:resolve] :: Ivy 2.0.0-rc2 - 20081028224207 :: http://ant.apache.org/ivy/ ::
:: loading settings :: file = /usr/local/mondrian-3.1.2.13008/ivysettings.xml
[ivy:resolve] :: resolving dependencies :: pentaho#mondrian-workbench;3.1.0
[ivy:resolve] confs: [default]

...

info:
[echo] ================================================== ============
[echo] | Mondrian configuration info |
[echo] ================================================== ============
[echo] project.location = /usr/local/mondrian-3.1.2.13008
[echo] jdk.home = /Volumes/BKUP/Library/Java/Home/
[echo] catalina.home = ${env.CATALINA_HOME}
[echo] junit.home = /Volumes/BKUP/System/Library/Frameworks/junit4.8.1/
[echo] log4j.configuration = log4j.properties
[echo] mondrian.foodmart.catalogURL = file:/usr/local/mondrian-3.1.2.13008/demo/FoodMart.xml
[echo] mondrian.foodmart.jdbcURL = jdbc:mysql://localhost/foodmart?user=root&password=root
[echo] mondrian.jdbcDrivers = com.mysql.jdbc.Driver
[echo] driver.classpath (additions) =
[echo] ================================================== ============

compile.tests:
[javac] /usr/local/mondrian-3.1.2.13008/build.xml:567: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds

check-FoodMartCreateData-uptodate:

unzip-FoodMartCreateData:

check-FoodMartAccessDB-uptodate:

...

[javadoc] Loading source files for package mondrian.test.loader...
[javadoc] Loading source files for package mondrian.xmla.test...
[javadoc] Constructing Javadoc information...
[javadoc] /usr/local/mondrian-[COLOR="rgb(255, 140, 0)"]3.1.2.13008/src/main/mondrian/olap4j/FactoryJdbc4Impl.java:93: cannot find symbol
[javadoc] symbol : class RowId
[javadoc] location: class mondrian.olap4j.FactoryJdbc4Impl.EmptyResultSetJdb c4
[javadoc] public RowId getRowId(int columnIndex) throws SQLException {
[javadoc] ^
[javadoc] /usr/local/mondrian-3.1.2.13008/src/main/mondrian/olap4j/FactoryJdbc4Impl.java:97: cannot find symbol
[javadoc] symbol : class RowId
[javadoc] location: class mondrian.olap4j.FactoryJdbc4Impl.EmptyResultSetJdb c4
[javadoc] public RowId getRowId(String columnLabel) throws SQLException {
[javadoc] ^
[javadoc] /usr/local/mondrian-3.1.2.13008/src/main/mondrian/olap4j/FactoryJdbc4Impl.java:101: cannot find symbol
[javadoc] symbol : class RowId
[javadoc] location: class mondrian.olap4j.FactoryJdbc4Impl.EmptyResultSetJdb c4
[javadoc] public void updateRowId(int columnIndex, RowId x) throws SQLException {
[javadoc] ^
[javadoc] /usr/local/mondrian-3.1.2.13008/src/main/mondrian/olap4j/FactoryJdbc4Impl.java:105: cannot find symbol
[javadoc] symbol : class RowId
[javadoc] location: class mondrian.olap4j.FactoryJdbc4Impl.EmptyResultSetJdb c4
[javadoc] public void updateRowId(String columnLabel, RowId x) throws SQLException
[javadoc] ^
[javadoc] /usr/local/mondrian-3.1.2.13008/src/main/mondrian/olap4j/FactoryJdbc4Impl.java:130: cannot find symbol
[javadoc] symbol : class NClob
[javadoc] location: class mondrian.olap4j.FactoryJdbc4Impl.EmptyResultSetJdb c4
[javadoc] public void updateNClob(int columnIndex, NClob nClob)
[javadoc] ^
[javadoc] /usr/local/mondrian-3.1.2.13008/src/main/mondrian/olap4j/FactoryJdbc4Impl.java:137: cannot find symbol
[javadoc] symbol : class NClob
[javadoc] location: class mondrian.olap4j.FactoryJdbc4Impl.EmptyResultSetJdb c4
[javadoc] String columnLabel, NClob nClob) throws SQLException
[javadoc] ^
[javadoc] /usr/local/mondrian-3.1.2.13008/src/main/mondrian/olap4j/FactoryJdbc4Impl.java:142: cannot find symbol
[javadoc] symbol : class NClob
[javadoc] location: class mondrian.olap4j.FactoryJdbc4Impl.EmptyResultSetJdb c4
[javadoc] public NClob getNClob(int columnIndex) throws SQLException {
[javadoc] ^
[javadoc] /usr/local/mondrian-3.1.2.13008/src/main/mondrian/olap4j/FactoryJdbc4Impl.java:146: cannot find symbol
[javadoc] symbol : class NClob
[javadoc] location: class mondrian.olap4j.FactoryJdbc4Impl.EmptyResultSetJdb c4
[javadoc] public NClob getNClob(String columnLabel) throws SQLException {
[javadoc] ^
[javadoc] /usr/local/mondrian-3.1.2.13008/src/main/mondrian/olap4j/FactoryJdbc4Impl.java:150: cannot find symbol
[javadoc] symbol : class SQLXML
[javadoc] location: class mondrian.olap4j.FactoryJdbc4Impl.EmptyResultSetJdb c4
[javadoc] public SQLXML getSQLXML(int columnIndex) throws SQLException {
[/COLOR]
...

Any help on these 'cannot find symbol' errors, and do I need to care about the warning "warning: 'includeantruntime' was not set" in the beginning.

Thanks in advance-
Chandu.

[chanduDB]

Alright, I am able to fixe above errors if I compile and run the test with the source code synced from perforce.

>ant
>ant test

Both of the above commands ran fine, no failures.

>ant war => ran fine and created mondrian.war, I copied this to $TOMCAT_HOME/webapps,
started mysql demon, TOMCAT and , http://localhost:8080/mondrian/, gave a page with all the links. I tried adhoc query but got these erros when executing 'Sample Query #0".

Results: Error:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Connect string '@mondrian.webapp.connectString@=; Catalog='null'' must contain either 'Jdbc' or 'DataSource'
at mondrian.resource.MondrianResource$_Def0.ex(Mondri anResource.java:813)
at mondrian.olap.Util.newInternal(Util.java:1459)
at mondrian.rolap.RolapConnection.createDataSource(Ro lapConnection.java:422)
at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:149)
at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:92)
at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:110)
at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:74)

Am I missing any more settings?
Where should I set the value for 'mondrian.webapp.connectString' ?

Thanks in advance-
Chandu