How to pass runtime Data source information

[madarapuv]

I could successfully generate an analysis view in JPivot and could perform all OLAP operations like drill down etc…Can anyone tell me how to pass a runtime data source information like jndi name from url.

Thanks in advance

------Venkat

[swood]

This would require changes to the viewOlap JSP and the OlapConnectionService to accept the connection information as a parameter.

 

Sherman

Jaspersoft

[madarapuv]

Thanks Sherman.

[madarapuv]

Thanks Sherman.

Hi Sherman,

 

Can you please provide me the Http url example how to pass the jndi_name by url so that the using jndi_name name we can cahnge  OlapConnection class and also please let me how to get The jndi_name in OlaspConnection class.

 

 

Thanks,

Venkat.

 

Post Edited by madarapuv at 03/29/2010 19:38

[swood]

You will need to change the OlapModelController to get the data source info parameter out of the HttpRequest.

 

Add the parameter into the ExecutionContext that is passed to:

        OlapModel model = getOlapConnectionService().initializeOlapModel(executionContext, olapUnit, sess);

 

In the OlapConnectionServiceImpl.getMondrianConnectProperties, get the data source value and inject it into:

                connectProps.put(RolapConnectionProperties.Jdbc.toString(),
                        jdbcDataSource.getConnectionUrl());
                String driverClassName = jdbcDataSource.getDriverClass();
                connectProps.put(RolapConnectionProperties.JdbcDrivers.toString(),
                        driverClassName);

or

                connectProps.put(RolapConnectionProperties.DataSource.toString(),
                        jndiURI);
 

 

Sherman

Jaspersoft