[Dino Flores]

I HAVE read the existing article:’Tomcat, JNDI datasource, MyEclipse Report
‘

For me it did not work, have not been able to connect Reports at RUNtime to a tomcat JNDI datasource.

However, I have noticed that MyEclipse reports does also have parameters that can be configured for a regular JDBC definition. This feature, however gives error:

following items have errors:

OdaDataSet Data Set:
+ Error evaluating Javascript expression. Script engine error: ReferenceError: “sa” is not defined.
Script source: property binding, line: 0, text:

Basically has anybody been able the CHANGE the runtime datasource (preferable through JDNI ? I am so disappointed I have two wasted days already as a freelance programmer on this matter with MyEclipse.

Thanks,
Dino

ReportDesign

[Loyal Water]

Dino,
Can you paste the entire error message here for me.

Can you go to MyEclipse > Installation Summary > Installation Details and paste the information here for me.

I did some research on this error and it seems like you might be missing some libs while deploying your report
http://dev.wavemaker.com/forums/?q=node/233

I should be able to help you when I get the complete error message pasted here for me.

[garypinot]

In the original myEclipse report XML Source, the xml for the JDBC datasource should be like this:
<data-sources>
<oda-data-source extensionID=”com.genuitec.eclipse.reporting.oda” name=”Data Source” id=”xx”>
<property name=”meDriver”>datasource_name_you_define</property>
<property name=”odaDriverClass”>oracle.jdbc.driver.OracleDriver</property>
<property name=”odaURL”>jdbc:oracle:thin:@hostname:1521:database_name</property>
<property name=”odaUser”>username</property>
<encrypted-property name=”odaPassword”>some_password_here</encrypted-property>
</oda-data-source>
</data-sources>

For changing it to using JNDI datasource, you should change it to something like:
<data-sources>
<oda-data-source extensionID=”org.eclipse.birt.report.data.oda.jdbc” name=”Data Source”
<property name=”odaURL”>disabled(it can’t be left blank while error msg will come out during runtime)</property>
<property name=”odaUser”></property>
<encrypted-property name=”odaPassword”></encrypted-property>
<property name=”odaJndiName”>(datasource name on your server)</property>
</oda-data-source>
</data-sources>
P.S. For the odaJndiName, you can use the pattern of “java:comp/env/datasource_name” if it’s tomcat; however, my one is weblogic, it can only be “datasource_name”

Hope it can help you.

[Author]

Posts