[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