Thanks again Julian,<br><br>I already had the postgres driver jar on my classpath, but I had my connection string wrong.<br>Now I'm having another error, but I want to face it a bit more.<br>Best regards<br><br><div class="gmail_quote">
2009/6/23 Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><span><font color="#000080" face="Lucida Sans" size="2">JDBC can't find a driver to connect to postgres. You need to put the
postgres driver jar on your classpath and add the driver to JdbcDrivers connect
string property.</font></span></div>
<div><span><font color="#000080" face="Lucida Sans" size="2"></font></span> </div>
<div><span><font color="#000080" face="Lucida Sans" size="2">You probably can omit the second step if you're running JDK 1.6 or
higher. JDBC drivers are automatically loaded if they are in jars on the
classpath. (Assuming that the postgres folks built their jar
correctly.)</font></span></div>
<div><span><font color="#000080" face="Lucida Sans" size="2"></font></span> </div>
<div><span><span style="word-spacing: 0px; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 16px; line-height: normal; font-size-adjust: none; font-stretch: normal; text-transform: none; color: rgb(0, 0, 0); text-indent: 0px; white-space: normal; letter-spacing: normal; border-collapse: separate;"><span style="font-size: 19px; color: rgb(85, 85, 85); white-space: pre; text-align: center;"><a href="http://lmgtfy.com/?q=mondrian+%22no+suitable+driver%22" target="_blank">http://lmgtfy.com/?q=mondrian+%22no+suitable+driver%22</a></span></span></span></div>
<div><div></div><div class="h5">
<div><span><span style="word-spacing: 0px; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 16px; line-height: normal; font-size-adjust: none; font-stretch: normal; text-transform: none; color: rgb(0, 0, 0); text-indent: 0px; white-space: normal; letter-spacing: normal; border-collapse: separate;"><span style="font-size: 19px; color: rgb(85, 85, 85); white-space: pre; text-align: center;"></span></span></span> </div>
<div><span><font color="#000080" face="Lucida Sans" size="2">Julian</font></span></div><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> Kezern [mailto:<a href="mailto:kezern@gmail.com" target="_blank">kezern@gmail.com</a>]
<br><b>Sent:</b> Monday, June 22, 2009 9:24 AM<br><b>To:</b>
<a href="mailto:jhyde@pentaho.com" target="_blank">jhyde@pentaho.com</a><br><b>Cc:</b> Mondrian developer mailing
list<br><b>Subject:</b> Re: [Mondrian] begining with
olap4j<br></font><br></div>
<div></div>Julian, you was rigth. After rebooting the error changed and I had
to add commons-vfs.jar to the path.<br>now I have an error of no suitable
driver.<br>Exception in thread "main" org.apache.commons.dbcp.DbcpException:
java.sql.SQLException: No suitable driver<br>I have searched in google and in
the forum but I didn't find any answer.<br><br>
<div class="gmail_quote">2009/6/22 Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com" target="_blank">jhyde@pentaho.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><span>When faced with an error stack, you should look for the error
message and google it. This is the error:</span></div>
<div>
<div><span><font color="#000080" face="Lucida Sans" size="2"></font></span> </div>
<div><span></span>NoClassDefFoundError:
org/apache/commons/pool/ObjectPool</div>
<div><font color="#000080" face="Lucida Sans" size="2"></font> </div></div>
<div><span></span><font face="Lucida Sans"><font color="#000080"><font size="2">A<span>nd google tells you that you need to put
commons-pool.jar on your path.</span></font></font></font></div>
<div><font face="Lucida Sans"><font color="#000080"><font size="2"><span></span></font></font></font> </div>
<div><font face="Lucida Sans"><font color="#000080"><font size="2"><span>Julian</span></font></font></font></div>
<div><br></div><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> Kezern [mailto:<a href="mailto:kezern@gmail.com" target="_blank">kezern@gmail.com</a>]
<br><b>Sent:</b> Monday, June 22, 2009 8:43 AM<br><b>To:</b> <a href="mailto:jhyde@pentaho.com" target="_blank">jhyde@pentaho.com</a><br><b>Cc:</b> Mondrian developer
mailing list<br><b>Subject:</b> Re: [Mondrian] begining with
olap4j<br></font><br></div>
<div>
<div></div>
<div>
<div></div>Hi Julian,<br>Thanks for your answer. I have made some changes
following your instructions.<br>I have a postgresql database and a cuble
defined into mondrian in a xml file.<br>Now my code is as
follows:<br>
Class.forName("mondrian.olap4j.MondrianOlap4jDriver");<br>
OlapConnection connection
=<br>
(OlapConnection) DriverManager.getConnection(<br>
"jdbc:mondrian:Jdbc=jdbc:postgresql://localhost:5432/CdM_db;JdbcUser=postgres;JdbcPassword=Tbcrkpi47a8;"
+<br>
"Catalog=/descargas/apache-tomcat-5.5.27/webapps/mondrian-embedded/WEB-INF/queries/tickets4.mondrian.xml;"
+<br>
"Role='California
manager'");<br> OlapWrapper
wrapper = (OlapWrapper)
connection;<br> OlapConnection
olapConnection = (OlapConnection)
wrapper.unwrap(OlapConnection.class);<br>
OlapStatement statement = olapConnection.createStatement();<br><br>And I
get this error:<br>Exception in thread "main"
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while creating connection pool (with URI
jdbc:postgresql://localhost:5432/CdM_db)<br> at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)<br>
at mondrian.olap.Util.newInternal(Util.java:1435)<br> at
mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:396)<br>
at
mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173)<br>
at
mondrian.rolap.RolapConnection.<init>(RolapConnection.java:117)<br>
at
mondrian.olap.DriverManager.getConnection(DriverManager.java:110)<br>
at
mondrian.olap.DriverManager.getConnection(DriverManager.java:74)<br>
at
mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:111)<br>
at
mondrian.olap4j.FactoryJdbc3Impl$MondrianOlap4jConnectionJdbc3.<init>(FactoryJdbc3Impl.java:110)<br>
at
mondrian.olap4j.FactoryJdbc3Impl.newConnection(FactoryJdbc3Impl.java:30)<br>
at
mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:109)<br>
at java.sql.DriverManager.getConnection(Unknown
Source)<br> at
java.sql.DriverManager.getConnection(Unknown Source)<br>
at olap.App.main(App.java:22)<br>Caused by:
java.lang.NoClassDefFoundError:
org/apache/commons/pool/ObjectPool<br> at
mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:392)<br>
... 11 more<br><br>What I'm doing wrong?<br><br>
<div class="gmail_quote">2009/6/19 Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com" target="_blank">jhyde@pentaho.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Your
connect string is wrong. Something
like<br><br>jdbc:mondrian:Datasource=jdbc/SampleData;Catalog=./foodmart/FoodMart.xml;<br><br>or<br><br>jdbc:mondrian:Jdbc=jdbc:mysql://localhost/foodmart;JdbcUser=foodmart;JdbcPas<br>sword=foodmart;Catalog=./foodmart/FoodMart.xml;<br>
<br>Always
starts 'jdbc:mondrian:' if you're using the mondrian olap4j
driver,<br>or 'jdbc:xmla:' if you're using the XMLA driver.<br><br>Then
you need 'Datasource=' or, more commonly, 'Jdbc=' to give it the URL
of<br>the underlying database.<br><br>Other options for the mondrian
driver are documented here:<br><br><a href="http://mondrian.pentaho.org/documentation/configuration.php#Connect_string_p" target="_blank">http://mondrian.pentaho.org/documentation/configuration.php#Connect_string_p</a><br>
roperties<br><br><br>Julian<br><br><br><br>>
-----Original Message-----<br>> From: <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a><br>> [mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] On Behalf Of
Kezern<br>> Sent: Friday, June 19, 2009 12:30 AM<br>> To: <a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a><br>> Subject: [Mondrian]
begining with olap4j<br>><br>> Hi all,<br>> I have just started
with mondrian and olap4j. I'm trying to<br>> build a java<br>>
class which connects to my mondrian and extract some data.<br>> I
have deployed the mondrian-embedded.war into my tomcat and<br>> I
have made<br>> some test with jpivot.<br>> Now I'm building the
new class in eclipse following the<br>> instrucions of<br>> the
olap4j functional specifications.<br>> I have written this
class.<br>><br>> package olap;<br>><br>> import
java.sql.DriverManager;<br>> import java.sql.SQLException;<br>>
import org.apache.log4j.Logger;<br>><br>> import
org.olap4j.*;<br>><br>> public class App<br>> {<br>>
public static void main( String[] args ) throws<br>>
ClassNotFoundException, SQLException<br>> {<br>>
System.out.println( "Hello World!"
);<br>>
Class.forName("mondrian.olap4j.MondrianOlap4jDriver");<br>>
OlapConnection connection =<br>>
(OlapConnection)
DriverManager.getConnection(<br>><br>>
"jdbc:mondrian:local:jdbcURL=jdbc:odbc:MondrianFoodMart;" +<br>>
"Catalog=/WEB-INF/queries/FoodMart.xml;" +<br>>
"Role='California manager'");<br>>
OlapWrapper wrapper = (OlapWrapper) connection;<br>>
OlapConnection olapConnection =
(OlapConnection)<br>> wrapper.unwrap(OlapConnection.class);<br>>
OlapStatement statement =
olapConnection.createStatement();<br>><br>> //
OlapResult result =<br>> //
statement.execute(<br>> //
"SELECT {[Measures].[Unit Sales]} ON
COLUMNS,\n" +<br>> //
" {[Product].Members} ON ROWS\n" +<br>> //
"FROM [Sales]");<br>>
}<br>> }<br>><br>> And I get this error when the
class tries to make de connection:<br>> Exception in thread "main"
mondrian.olap.MondrianException: Mondrian<br>> Error:Internal error:
Connect string<br>>
'local:jdbcURL=jdbc:odbc:MondrianFoodMart;<br>>
Catalog=/WEB-INF/queries/FoodMart.xml; Role=California manager'
must<br>> contain either 'Jdbc' or 'DataSource'<br>> I have been
looking for a solution but I couldn't find one.<br>> Thanks every
body.<br>><br>><br>><br>><br>>
_______________________________________________<br>> Mondrian mailing
list<br>> <a href="mailto:Mondrian@pentaho.org" target="_blank">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>><br>><br><br></blockquote></div><br></div></div></blockquote></div></blockquote></div><br></blockquote></div></div></div>
</blockquote></div><br>