Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Dynamic JDBC Data Source setting from ReportEventAdapter
p.K
<p>I need to set JDBC Data Set (url, name, password etc.) dynamically from Java class. I would like to create ReportEventAdapter.beforeFactory <span><span>method and there I would like to set my Data Set (according to .properties file)</span></span> and reuse the event adapter for many reports. But I wasn't able to access Data Set properties/setting from ReportEventAdapter.beforeFactory</p>
<p> </p>
<p><span><span>I welcome</span> <span>any</span> <span>help</span></span>.</p>
<p>Thank you.</p>
Find more posts tagged with
Comments
p.K
<p><span><span>It seemed</span></span> that dataSource.setPrivateDriverProperty does works but I found that it is all right... So my solution is:</p>
<p> </p>
<p>public class MyReportBeforeFactory extends ReportEventAdapter{<br>
@Override<
;br>
public void beforeFactory(IReportDesign report, IReportContext reportContext) throws ScriptException {</p>
<p> IDataSource dataSource = report.getDataSource("DataSourceName");<br>
dataSource.setPrivateDriverProperty("odaUser", "user");<br>
dataSource.setPrivateDriverProperty("odaPassword", "pssw");<br>
dataSource.setPrivateDriverProperty("odaURL", "url");<br>
dataSource.setPrivateDriverProperty("odaDriverClass", "oracle.jdbc.OracleDriver");<br>
}<br>
}</p>