This content has been marked as final.
Show 1 reply
-
1. Re: Sem & Mondrian: Passing DB Connection
nordmeyer Feb 12, 2010 2:12 PM (in response to nordmeyer)Thats how I solved it. Unfortiunately, my code must know the JNDI name of my datasource.
// get Datasource from JNDI InitialContext ctx = new InitialContext(); DataSource dataSource = (DataSource)ctx.lookup("java:/renaDatasource"); // assemble mondrian parameters Util.PropertyList props = new Util.PropertyList(); props.put ( "Provider", "mondrian" ); props.put ( "Catalog", "my-mondrian-schema.xml"); CatalogLocator locator = null; // use default catalog locator Connection connection = DriverManager.getConnection(props, locator, dataSource); Query query = connection.parseQuery(mdxQuery); Result result = connection.execute(query);