issue with connect string in mondrian datasources.xml

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

issue with connect string in mondrian datasources.xml

Matt Becker
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



------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: issue with connect string in mondrian datasources.xml

Dan Kinsley

Perhaps you could include the error message you are seeing?

 

I could be mistaken but I think JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver should be org.luciddb.jdbc.LucidDbClientDriver.

 

- dan

 

From: Matt Becker [mailto:[hidden email]]
Sent: Thursday, September 08, 2011 4:34 PM
To: [hidden email]
Subject: [luciddb-users] issue with connect string in mondrian datasources.xml

 

Hi guys,

 

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

 

 

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

 

 


------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: issue with connect string in mondrian datasources.xml

ngoodman
<base href="x-msg://115/">
I could be mistaken but I think JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver should be org.luciddb.jdbc.LucidDbClientDriver.
I agree with Dan - it's likely a driver/URL mismatch which was incorrectly on

I've updated that Wiki article to include the new JDBC Driver name and URL.  Sorry for the issue with the old driver information still lingering on that page

JDBC driver class: org.luciddb.jdbc.LucidDbClientDrive
JDBC URL: jdbc:luciddb:http://localhost

Nick



------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: issue with connect string in mondrian datasources.xml

Matt Becker
Hi guys,

i changed that, still no dice.. it's saying the driver can't be found:
The Mondrian XML: No suitable driver found for jdbc:luciddb://localhost

in my xml connection.

Here's my new connection info in my /usr/local/tomcat/webapps/mondrian/WEB-INF/datasources.xml:
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:luciddb://localhost;JdbcUser='LUCIDDB_ANALYTICS';Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver;</DataSourceInfo>

I've definitely got the drivers copied to driver locations:
/usr/local/tomcat/webapps/mondrian/WEB-INF/lib/LucidDbClient.jar
/usr/share/java/LucidDbClient.jar

anyone have a sample connection string that works with the barebones mondrian install, as above?

thanks,

Matt







I could be mistaken but I think JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver should be org.luciddb.jdbc.LucidDbClientDriver.
I agree with Dan - it's likely a driver/URL mismatch which was incorrectly on

I've updated that Wiki article to include the new JDBC Driver name and URL.  Sorry for the issue with the old driver information still lingering on that page

JDBC driver class: org.luciddb.jdbc.LucidDbClientDrive
JDBC URL: jdbc:luciddb:http://localhost

Nick





------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: issue with connect string in mondrian datasources.xml

ngoodman

On Sep 12, 2011, at 9:12 AM, Matt Becker wrote:

The Mondrian XML: No suitable driver found for jdbc:luciddb://localhost
Matt, the URL that Dan and I sent over looked like this:

jdbc:luciddb:http://localhost
NOT
jdbc:luciddb://localhost

Can you please try to use the correct URL format and let us know if that works?  The rest of your Mondrian setup looks ok at first glance.

Nick

------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: issue with connect string in mondrian datasources.xml

Dan Kinsley
In reply to this post by Matt Becker

I think it should be jdbc:luciddb:http://localhost

 

From: Matt Becker [mailto:[hidden email]]
Sent: Monday, September 12, 2011 12:12 PM
To: Mailing list for users of LucidDB
Subject: Re: [luciddb-users] issue with connect string in mondrian datasources.xml

 

Hi guys,

 

i changed that, still no dice.. it's saying the driver can't be found:

The Mondrian XML: No suitable driver found for jdbc:luciddb://localhost

in my xml connection.

Here's my new connection info in my /usr/local/tomcat/webapps/mondrian/WEB-INF/datasources.xml:
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:luciddb://localhost;JdbcUser='LUCIDDB_ANALYTICS';Catalog=/WEB-INF/queries/analytics_schema.xml;JdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver;</DataSourceInfo>

I've definitely got the drivers copied to driver locations:
/usr/local/tomcat/webapps/mondrian/WEB-INF/lib/LucidDbClient.jar
/usr/share/java/LucidDbClient.jar

anyone
 have a sample connection string that works with the barebones mondrian install, as above?

thanks,

Matt


 


 

 

I could be mistaken but I think JdbcDrivers=com.lucidera.jdbc.LucidDbRmiDriver should be org.luciddb.jdbc.LucidDbClientDriver.

I agree with Dan - it's likely a driver/URL mismatch which was incorrectly on

 

I've updated that Wiki article to include the new JDBC Driver name and URL.  Sorry for the issue with the old driver information still lingering on that page

 

JDBC driver class: org.luciddb.jdbc.LucidDbClientDrive

JDBC URL: jdbc:luciddb:http://localhost

 

Nick

 

 

 


------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: issue with connect string in mondrian datasources.xml

Matt Becker
In reply to this post by ngoodman
Hi Nick,

thanks, that did it! I overlooked that http somehow.

thanks again,

Matt
The Mondrian XML: No suitable
 driver found for jdbc:luciddb://localhost
Matt, the URL that Dan and I sent over looked like this:

jdbc:luciddb:http://localhost
NOT
jdbc:luciddb://localhost

Can you please try to use the correct URL format and let us know if that works?  The rest of your Mondrian setup looks ok at first glance.

Nick


------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

update luciddb database with dump files

Matt Becker
hi guys,

I did this http://pub.eigenbase.org/wiki/LucidDbMondrianReplication
and it's working fine with my data source now, thanks to you guys.
i'm trying to figure out how to create a dump file and import (update) an existing luciddb db that is my mondrian cube. 
Is there a simple procedure that I can follow to create a dump file? What format should my file be in and how should the import process work?

thanks,

Matt



------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

luciddb flat file import

Matt Becker
hi guys,

i have a question about importing flat files.
I've got this set up:

file:  /var/db/analytics_olap/current/analytics.csv

I created a foreign server:

CREATE OR REPLACE SERVER file_load
FOREIGN DATA WRAPPER SYS_FILE_WRAPPER
OPTIONS (
DIRECTORY '/var/db/analytics_olap/current',
FILE_EXTENSION 'csv',
CONTROL_FILE_EXTENSION 'bcp',
FIELD_DELIMITER ',',
LINE_DELIMITER '\n',
QUOTE_CHAR '"',
WITH_HEADER 'YES')
0: jdbc:luciddb:http://localhost> CREATE OR REPLACE SERVER file_load
. . . . . . . . . . . . . . . . > FOREIGN DATA WRAPPER SYS_FILE_WRAPPER
. . . . . . . . . . . . . . . . > OPTIONS (
. . . . . . . . . . . . . . . . > DIRECTORY '/var/db/analytics_olap/current',
. . . . . . . . . . . . . . . . > FILE_EXTENSION 'csv',
. . . . . . . . . . . . . . . . > CONTROL_FILE_EXTENSION 'bcp',
. . . . . . . . . . . . . . . . > FIELD_DELIMITER ',',
. . . . . . . . . . . . . . . . > LINE_DELIMITER '\n',
. . . . . . . . . . . . . . . . > QUOTE_CHAR '"',
. . . . . . . . . . . . . . . . > WITH_HEADER 'YES')
. . . . . . . . . . . . . . . . > java.lang.NullPointerException
No rows affected (0.455 seconds)
0: jdbc:luciddb:http://localhost> Closing: de.simplicit.vjdbc.VirtualConnection


I created a foreign schema and a foreign table:
Create or REPLACE Schema FILE_STAGING;
CREATE OR REPLACE FOREIGN TABLE FILE_STAGING.analytics (
id integer,
load_id integer )
SERVER file_load
OPTIONS (filename '/var/db/analytics_olap/current/analytics.csv');
0: jdbc:luciddb:http://localhost> Create or REPLACE Schema FILE_STAGING;
No rows affected (0.165 seconds)
0: jdbc:luciddb:http://localhost> CREATE OR REPLACE FOREIGN TABLE FILE_STAGING.analytics (
. . . . . . . . . . . . . . . . > id integer,
. . . . . . . . . . . . . . . . > load_id integer )
. . . . . . . . . . . . . . . . > SERVER file_load
. . . . . . . . . . . . . . . . > OPTIONS (filename '/var/db/analytics_olap/current/analytics.csv');
No rows affected (0.444 seconds)

I then try to select from FILE_STAGING.analytics:

select * from "FILE_STAGING"."analytics";
Error: From line 1, column 15 to line 1, column 31: Table 'FILE_STAGING'.'analytics' not found (state=,code=0)

anything i'm missing?

version of luciddb is 0.9.3

thanks,

Matt



------------------------------------------------------------------------------
Cloud Services Checklist: Pricing and Packaging Optimization
This white paper is intended to serve as a reference, checklist and point of
discussion for anyone considering optimizing the pricing and packaging model
of a cloud services business. Read Now!
http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Loading...