Skip to main content

Eclipse BIRT 2.1.1 SQL Bug

If your Eclipse BIRT report suddenly runs with errors after upgrading to BIRT 2.1.1, check if your SQL statement contains any division expression (i.e. SELECT month, sales / 12 FROM table1). This is a bug in 2.1.1 which was corrected in 2.2. Unfortunately, 2.2 is still a milestone release (not stable).

As discussed in this newsgroup thread, the solution (until 2.2 is released), is to download rcp-report-designer-2.2.0 and copy the oda-jdbc.jar found in: birt-rcp-report-designer-2_2_0\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.0.v20061009-0630

and replace the oda-jdbc.jar found at: eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_2.1.1.v20060922-1058

You will need to replace the oda-jdbc.jar in the webviewer if you are using it. I would have upgraded to 2.2M1 if the webviewer was working right.

Comments

Popular posts from this blog

iReport Default Date Parameter

If you want to set a default date for a jasperreports parameter, you can enter the following in the default value expression of the parameter. new Date() However, if you wanted the default to be relative from today, for example, 3 days ago, you will need to do go outside of the standard java date libraries (Date, Calendar) because JR parameter does not allow you to have multiple statements. You can write your own utility package or you can use Joda , a replacement library for the JDK date and time library. To use Joda in iReports, you need to extract the jar file and add it to Options -> Classpath. You may also drop the jar file in iReports' lib directory. You will also need to add this library to your application or report server. For setting a default date 5 days prior from today, use this: new org.joda.time.DateTime().minusDays(5).toDate() or this if you want the time part set to the beginning of the day: new org.joda.time.LocalDate().toDateTimeAtStartOfDay().minusDays(5).to...

Get uptime alerts in Telegram

You will be configuring 3 services. The assumption is that you have accounts already for these services. UptimeRobot — source of the uptime/downtime notifications. It currently supports email, Twitter, Slack, Pushover, Pushbullet and others but not Telegram. We will use the webhook notification as the way to send messages to Telegram. IFTTT — bridges UptimeRobot and Telegram by providing the webhook for UptimeRobot and triggering a message to Telegram. In IFTTT terminology: IF {event trigger from UptimeRobot}, then {send message to Telegram group} Telegram — destination of the notification. You will need to create a group for this. Telegram Configuration In Telegram, create a new group, if needed. You may opt to use an existing group. Go to @IFTTT and follow the instruction so link your Telegram account to your IFTTT account. Send /connect_group to @IFTTT and connect the group where you want to send the notifications. IFTTT Configuration Sign in to IFTTT and add a ne...

Oracle Apps on Mozilla Firefox

You actually don't need to install JInitiator (jinit 1.3.1.21) to run Oracle Applications on Firefox if you already installed the Sun JRE 1.4.2 and above. You will need to edit pluginreg.dat On Windows, that file is located at %APPDATA%\Mozilla\Firefox. Make a copy of the existing one first in case something goes wrong. Search for NPJava14.dll because Oracle runs on Java 1.4. This will appear whether you have installed Java 5 or 6. You will need to add the following line to at the end of the plugins. 6|application/x-jinit-applet;version=1.3.1.21|Java||$ Then update the count at the top of the section. Your modified pluginreg.dat will look like: C:\Program Files\Java\jre1.5.0_09\bin\NPJava14.dll|$ |$ 1160594743000|1|5|$ Java Plug-in 1.5.0_09 for Netscape Navigator (DLL Helper)|$ Java(TM) 2 Platform Standard Edition 5.0 Update 9|$ 7 0|application/x-java-applet;version=1.4.2|Java Applet||$ 1|application/x-java-bean;version=1.4.2|JavaBeans||$ 2|application/x-java-applet;version=1.4.1|J...