- This topic has 2 replies, 3 voices, and was last updated 15 years, 8 months ago by
.
-
Posts
-
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,
DinoReportDesign
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/233I should be able to help you when I get the complete error message pasted here for me.
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.
