<font size="2">
<div>test.jsp</div>
<div>I am connecting to an Oracle XE database</div>
<div>but getting error</div>
<div> </div>
<div>Could u help to resolve?</div>
<div>
<h2>JPivot had an error ...</h2>
<p>
<h2>javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: Mondrian Error:Internal error: Error while creating SQL dialect</h2><pre>javax.servlet.ServletException: javax.servlet.jsp.JspException
: javax.servlet.jsp.JspException: Mondrian Error:Internal error: Error while creating SQL dialect
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:844)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
</pre></p></div>
<div><jp:mondrianQuery id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc:oracle:thin:@localhost:1521:XE" catalogUri="/WEB-INF/queries/SALES.xml"></div>
<p>select {[Measures].[COST],[Measures].[SALES]} on columns,</p>
<p>{([COMPANY].[All Company], [YEAR].[All Year], [LOCATION].[All Location], [SP].[All SP])} ON rows</p>
<p>from [SALES] </p>
<p></jp:mondrianQuery></p></font><br><br>
<div><span class="gmail_quote">On 3/4/07, <b class="gmail_sendername"><a href="mailto:Pranav.Matekar@zycus.com">Pranav.Matekar@zycus.com</a></b> <<a href="mailto:Pranav.Matekar@zycus.com">Pranav.Matekar@zycus.com</a>> wrote:
</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br><font face="sans-serif" size="2">hi </font><font face="Verdana" color="#000080" size="2">Julian</font>
<font face="sans-serif" size="2">,</font> <br><br><font face="sans-serif" size="2">thanks Julian.</font> <br><br><font face="sans-serif" size="2">it's true that such query is very bad.</font> <br><font face="sans-serif" size="2">
i think userdefined function will help me, </font><br><font face="sans-serif" size="2">so that i am trying some specific types of queries via using userdefined functions</font> <br><br><font face="sans-serif" size="2">currently i am facing one small problem, in writing userdefined functions.
</font> <br><font face="sans-serif" size="2">i am getting one object of </font><br><br><font face="Courier New" color="#004041" size="2"><b><i>[Lmondrian.olap.Member;</i></b></font> <br><br><font face="sans-serif" size="2">
this class</font> <br><br><font face="sans-serif" size="2">there is interface of type mondrian.olap.member</font> <br><br><font face="sans-serif" size="2">i tried to cast it with this interface. </font><br><font face="sans-serif" size="2">
but it's giving class cast exception.</font> <br><br><font face="sans-serif" size="2">can u give me some information about such types of object?</font> <br><br><font face="sans-serif" size="2">thank you.</font> <br><br>
<font face="sans-serif" size="2"><br>Pranav</font><br>_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">
http://lists.pentaho.org/mailman/listinfo/mondrian</a><br><br></blockquote></div><br><br clear="all"><br>-- <br><a href="http://cfo-portal.blogspot.com/">http://cfo-portal.blogspot.com/</a>