Hi,
I've been attempting to deploy BIRT 2.6.2 in Apache Tomcat 6.0.33. I have run into some issues. I can get the supplied test.rptdesign and test1.rptdesign reports to run. However, I cannot get our reports to run.
So far, (This all refers to the WebViewerExample in BIRT 2.6.2)
* Got commons-logging-1.1.1 extracted and installed into WEB-INF/lib in the WebViewerExample.
* Created a META-INF/context.xml with the JNDI configuration.
* Added the resource-ref to WEB-INF/web.xml
* Added the postgres JDBC (postgres-8.3-jdbc3.jar) to WEB-INF/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.2.r262_v20110127/drivers/
* Ensured that both the JNDI URL and the JDBC values are in the report.
When I created the war, I used 'jar -cf birt.war .' inside of WebViewerExample, and then symbolically linked it from the webapps directory of Tomcat.
I then started Tomcat and verified that I could view the test reports before running up our report. The stack trace from logs/catalina.out is at:
http://pastebin.com/uVEH1GVm. I have also tests a few other postgres drivers:
* postgresql-8.2-512.jdbc2.jar
* postgresql-8.2-512.jdbc2ee.jar
* postgresql-8.3-607.jdbc2.jar
* postgresql-8.3-607.jdbc2ee.jar
* postgresql-8.3-607.jdbc3.jar
* postgresql-8.4-703.jdbc3.jar
Given the range of drivers which don't work; I suspect that it is a mis-configuration issue somewhere else. I am trying to follow the book 'Integrating and Extending BIRT (Third Edition)' by Jason Weathersby, Chapter 4.
The list of versions of things that I am using for reference is:
* Apache Tomcat 6.0.33
* BIRT runtime 2.6.2
* PostgreSQL 8.4 (We use the postgres-8.3-607.jdbc3.jar successfully in our application with this dev. machine. The live server is on 8.3)
* Commons Logging 1.1.1
I have also tried to get this up and running with Apache Tomcat 7.0.22 & BIRT runtime 3.7.1 (I.e. the latest software) to no use. I've also attached a relevant extract of catalina.out.
Many Thanks.
