pocOLAP - the little OLAP project

<source classtype="com.pocolap.conn.StandardJDBC" driver="org.hsqldb.jdbcDriver"
dbString="jdbc:hsqldb:file:c:/dwh/aat/base/aat_data" user="sa" pass="" />

First of all, I haven't looked at this project for a long time! I will try my best to help you, though it may take a few tries!

You want to remove "file" from the dbString! I'm pretty sure you want dbString="jdbc:hsqldb:c:/dwh/aat/base/aat_data" (assuming that path is valid).

Next, what is the "version" error you're getting? Is it possible that the version of hsqldb that you used to create the data file is different than what is available to pocolap? Try replacing the hsqldb.jar file in pocolap's lib directory (and probably in tomcats common/lib directory too) with the same jar file you used to create your data files.

If that still doesn't work, post the error messages you're getting.

Todd

P.S. The PocOlapSampleDatabaseConnection is very similar to StandardJDBC, except that it gets data from the same db that pocolap uses to store data (which is a derby database). This was originally done to avoid having to distribute a separate set of data files simply for the purposes of providing a sample crosstab report. You want to use StandardJDBC (and ignore the ${}) since your data is external to pocolap.