URGENT: failed to load jdbc driver

[screenname]

Eclipse BIRT bug (https://bugs.eclipse.org/bugs/show_bug.cgi?id=197978) appears in our app.

We built a web application and used BIRT runtime to render reports. Everything is great with BIRT. However, the report generation is not very reliable and loading JDBC driver is failed from time to time on the birt runtime 2.2.2. The only solution we have found so far is to redeploy the BIRT war file. Due to the production system change restriction, we can?t really resort to redeployment to fix it every time. I have saw some threads a few months agao but no clear fix. I am wondering if anybody has found a known permanent fix to that issue.

Below is the our environment:

? BIRT: built from 2.2.2 release from CSV with Eclipse 3.3 (We did add some plain logics to check the incoming application specific parameters. They have nothing to do with JDBC or database.)
? Web Server: Sun Java Web Server 7.0 (We used the same procedures as deploying to Tomcat)
? JDBC: ojdbc14.jar (placed under birt_web\WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.2.r22x_v20071206\drivers
? Database: Oracle 10g Release 2

Also we did try BIRT 2.3 release but there seemed no build ant scripts for any component. We are open to any known permanent fix to that issue. Any help would be highly appreciated.

Regards,

[mwilliams]

Hi ,

You may want to take a look at this for building from CSV:

BIRT/FAQ/Birt Project - Eclipsepedia

This should show you how to create your own ANT files as well. Let me know if this doesn't solve your issues with BIRT 2.3. I'm not sure if there's a workaround for the issue with 2.2.2 besides the upgrade to 2.3.

[screenname]

Maybe there is a fix in the new release. but I don't see the source of Release_2_3_1 in CVS, even the binary is available from the birt site. The only source of 2.3.1 is RC1 and one nightly build.

any idea?