[luciddb-users] issue with connect string in mondrian datasources.xml

[Matt B. <mat...@ya...>]

Hi guys,

I'm trying to use Lucid directly with my Mondrian cube, the data is already there, i followed the guide here:

http://pub.eigenbase.org/wiki/LucidDbMondrianReplication

and i am able to connect to my database from the sqllineClient like this:

bin/sqllineClient -n LUCIDDB_ANALYTICS
select count(*) from "fact_analytics";
+---------+
| EXPR$0  |
+---------+
| 18219   |
+---------+
1 row selected (0.089 seconds)

My mondrian bare-bones install is currently functional with mysql and my OLAP cube in there. When I try to switch to Lucid, I'm using this connect string in my datasources.xml: 


<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:luciddb://localhost?user=LUCIDDB_ANALYTICS;Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver;</DataSourceInfo>

The driver works fine, I tested with the standalone sqlline client in debian, it can connect fine:
# sqlline -u jdbc:luciddb:http://localhost -d org.luciddb.jdbc.LucidDbClientDriver -n LUCIDDB_ANALYTICS
Connecting to jdbc:luciddb:http://localhost
- Virtual JDBC-Driver successfully registered
- Couldn't load HSQL-Driver, caching deactivated
- VJdbc-URL: servlet:http://localhost:8034/vjdbc,FarragoDBMS
- VJdbc in Servlet-Mode, using URL http://localhost:8034/vjdbc
- Connecting to datasource FarragoDBMS
Connected to: LucidDB (version 0.9.3)
Driver: LucidDbJdbcDriver (version 0.9)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
sqlline version 1.0.2 by Marc Prud'hommeaux
0: jdbc:luciddb:http://localhost> select count(*) from "fact_analytics" ;
+---------+
| EXPR$0  |
+---------+
| 18219   |
+---------+
1 row selected (0.07 seconds)
0: jdbc:luciddb:http://localhost>



However, from my mondrian install, the connect string above fails.

Here's my current (working) mysql connect string for datasources.xml:
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost/analytics?user=root&amp;password=password;Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=com.mysql.jdbc.Driver;</DataSourceInfo>



If you can give me some feedback on what's wrong with my luciddb connect string that would be great.
I can provide more details as well.

thanks,

Matt