Overwrite JNDI Name String in Java Code NOT ScriptedDataSourceEventAdapter

Hi everyone,
 
I need a way to change the jndi name string in the dataSource beside the ScriptedDataSourceEventAdapter.
I cannot use because in Joint DataSets it is never called when attached to sql data sources.
 
IÂ´ve already tried this in an extension of ReportEventAdapter/beforeFactory:
 
1.)
String jndiNameString = (String) element.getUserPropertyExpression("odaJndiName");
.
.
.
element.setUserProperty("odaJndiName", jndiNameString);
 
2.)
IDataSource dataSource = report.getDataSource("Data Set");
dataSource.getPrivateDriverProperty("odaJndiName"); // which does not know of odaJndiName
 
Please help, because we need to change the jndi String depending on input parameters

Find more posts tagged with

Comments

Alex Zot

Now IÂ´ve trief to change it with:
 
 
ReportingContext ownContext = (ReportingContext) reportContext.getParameterValue(ReportParameters.IReportContext.CTX); 
 SlotHandle handle = reportContext.getDesignHandle().getDataSources(); 
 int count = handle.getCount(); 
 for(int i = 0; i<count;i++ ){ 
 DesignElementHandle elementHandle = handle.get(i); 
 if(elementHandle instanceof OdaDataSourceHandle){ 
 OdaDataSourceHandle dataSetHandle = (OdaDataSourceHandle) elementHandle; 
 OdaDataSource dataSource = (OdaDataSource) dataSetHandle.getElement(); 
 dataSetHandle.getName().equals("Data Source"); 
 String jndiNameString = (String)dataSetHandle.getProperty("odaJndiName"); 
 
 ............ 
 
 try { 
 dataSetHandle.setProperty("odaJndiName", jndiNameString); 
 } catch (SemanticException e) { 
 // TODO Auto-generated catch block 
 e.printStackTrace(); 
 } 
 
 
 } 
 
 }
 
in the Method afterfactory. That does actually change the data to the correct information, but has NO Effect on the report.
 
Does anybody have an idea?

Alex Zot

Yesss! We found a solution.
For whoever has the same problem.
This is the solution:
 
in the beforefactory method use the code from above (copied here): 
 SlotHandle handle = reportContext.getDesignHandle().getDataSources(); 
 int count = handle.getCount(); 
 for(int i = 0; i<count;i++ ){ 
 DesignElementHandle elementHandle = handle.get(i); 
 if(elementHandle instanceof OdaDataSourceHandle){ 
 OdaDataSourceHandle dataSetHandle = (OdaDataSourceHandle) elementHandle; 
 OdaDataSource dataSource = (OdaDataSource) dataSetHandle.getElement(); 
 dataSetHandle.getName().equals("Data Source"); 
 String jndiNameString = (String)dataSetHandle.getProperty("odaJndiName"); 
 
 ............ 
 
 try { 
 dataSetHandle.setProperty("odaJndiName", jndiNameString); 
 } catch (SemanticException e) { 
 // TODO Auto-generated catch block 
 e.printStackTrace(); 
 } 
 
 
 } 
 
 }
 
 
So basically we overwrite the jndi String before the element is opened and therefore the correct jndi String is opened and the problem with the jointdataset does not bother us anymore!!