PDA

View Full Version : [Mondrian] MonetDB



Venks
04-19-2007, 10:00 PM
Hi,

I am interested in making Mondrian work against MonetDB. I am new to MonetDB
but have lot of expertise working in Oracle and very knowledgeable with
PostgreSQL and MySQL. I was able to install and run the demo on all the
above databases except MonetDB. I was able to load the data into MonetDB but
unable to run the demo and I think it has something to do with SQL Dialect
as I am getting the following error:

*org.apache.jasper.JasperException: javax.servlet.jsp.JspException:
javax.servlet.jsp.JspException: Mondrian Error:Internal error: Error while
creating SQL dialect*


Please let me know how to proceed from here. I would like to do the
necessary changes to make Mondrain against MonetDB. I really appreciate your
help in this regard.


- Venkatesh Mantha

_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Julian Hyde
04-19-2007, 10:11 PM
See my reply to your forum post.


_____

From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Venks
Sent: Thursday, April 19, 2007 6:59 PM
To: mondrian (AT) pentaho (DOT) org
Subject: [Mondrian] MonetDB


Hi,

I am interested in making Mondrian work against MonetDB. I am new to
MonetDB but have lot of expertise working in Oracle and very
knowledgeable with PostgreSQL and MySQL. I was able to install and run
the demo on all the above databases except MonetDB. I was able to load
the data into MonetDB but unable to run the demo and I think it has
something to do with SQL Dialect as I am getting the following error:

org.apache.jasper.JasperException: javax.servlet.jsp.JspException:
javax.servlet.jsp.JspException: Mondrian Error:Internal error: Error
while creating SQL dialect


Please let me know how to proceed from here. I would like to do the
necessary changes to make Mondrain against MonetDB. I really appreciate
your help in this regard.


- Venkatesh Mantha


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Venks
04-19-2007, 10:22 PM
Julian,

Thanks very much for your prompt attention. I updated the forum with some
additional info and I will continue to use the forum in this matter.

Regards,

- Venkatesh


On 4/19/07, Julian Hyde <julianhyde (AT) speakeasy (DOT) net> wrote:
>
> See my reply to your forum post.
>
> ------------------------------
> *From:* mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
> *On Behalf Of *Venks
> *Sent:* Thursday, April 19, 2007 6:59 PM
> *To:* mondrian (AT) pentaho (DOT) org
> *Subject:* [Mondrian] MonetDB
>
>
> Hi,
>
> I am interested in making Mondrian work against MonetDB. I am new to
> MonetDB but have lot of expertise working in Oracle and very knowledgeable
> with PostgreSQL and MySQL. I was able to install and run the demo on all the
> above databases except MonetDB. I was able to load the data into MonetDB but
> unable to run the demo and I think it has something to do with SQL Dialect
> as I am getting the following error:
>
> *org.apache.jasper.JasperException: javax.servlet.jsp.JspException:
> javax.servlet.jsp.JspException: Mondrian Error:Internal error: Error while
> creating SQL dialect*
>
>
> Please let me know how to proceed from here. I would like to do the
> necessary changes to make Mondrain against MonetDB. I really appreciate your
> help in this regard.
>
>
> - Venkatesh Mantha
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian (AT) pentaho (DOT) org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>

_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Sherman Wood
04-19-2007, 11:00 PM
You will need to identify MonetDB to Mondrian, so that Mondrian can
generate SQL in a syntax appropriate to MonetDB. This is done in the
SqlQuery.Dialect class. There are a number of places in Mondrian where the
generated SQL is modified based on the type of database - you will see
tests for sqlQuery.getDialect().isMySQL() etc.







Sherman

JasperSoft



_____

From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Venks
Sent: Thursday, April 19, 2007 6:59 PM
To: mondrian (AT) pentaho (DOT) org
Subject: [Mondrian] MonetDB



Hi,



I am interested in making Mondrian work against MonetDB. I am new to
MonetDB but have lot of expertise working in Oracle and very knowledgeable
with PostgreSQL and MySQL. I was able to install and run the demo on all
the above databases except MonetDB. I was able to load the data into
MonetDB but unable to run the demo and I think it has something to do with
SQL Dialect as I am getting the following error:

org.apache.jasper.JasperException: javax.servlet.jsp.JspException:
javax.servlet.jsp.JspException: Mondrian Error:Internal error: Error while
creating SQL dialect


Please let me know how to proceed from here. I would like to do the
necessary changes to make Mondrain against MonetDB. I really appreciate
your help in this regard.



- Venkatesh Mantha


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian