[Mondrian] Mondrian performance
Pranav.Matekar at zycus.com
Pranav.Matekar at zycus.com
Sat Mar 3 11:20:23 EST 2007
hi,
i never tried tomcat
i used direct jdbc connection
Connection conn = DriverManager.getConnection(
"Provider=mondrian;" +
"Jdbc=jdbc:oracle:thin:UserName/Password at 192.168.1.1:1521:orcl1;" +
"JdbcDrivers=oracle.jdbc.driver.OracleDrive;"+
"Catalog=file:///C:/mondrian.xml;",
null,
false);
Query query = conn.parseQuery("select {[Store].members} on columns from
Sales ");
Result result = conn.execute(query);
if u want to connect via Datasource, try DataSource=dataSourceName; and
remove Jdbc=jdbc:oracle:thin:UserName/Password at 192.168.1.1:1521:orcl1;
thank you.
Pranav
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070303/9eadecac/attachment.html
More information about the Mondrian
mailing list