I have a custom JDBC driver that I need to use while creating reports in the BIRT RCP Designer. I have run into two problems depending on the version of BIRT that I am running and I don?t know how to resolve them. I would like to determine a way that would work for both Birt2.2.2 and Birt2.3.2 versions if possible. <br />
<br />
I am not having a problem when I go to run the reports in my application, as the reports are embedded in my application and it replaces the data source using a JNDI lookup, so my problem is only when previewing and viewing reports from the BIRT RCP Designer.<br />
<br />
<strong class='bbc'>JDBC Driver Requirements:</strong><br />
Main jar: AjJDBC.jar<br />
Supporting jars: AjConnectors.jar, wlfullclient.jar, sqljdbc.jar<br />
<br />
All of these files need to be in the classpath when connecting and querying the data. The driver wraps the normal sql server jdbc driver and makes JEE calls to Weblogic when it intercepts certain data fields being returned in the result set. Also, part of this is using the Java Security Framework (JAAS) to log in to Weblogic.<br />
<br />
This works fine outside of BIRT when it has everything in it?s class path. However, I am getting class not found errors in BIRT during different circumstances when previewing a report.<br />
<br />
<strong class='bbc'>Problem Summaries:</strong><br />
<strong class='bbc'>Problem 1:</strong> Cannot put all .jar files in plugins/org.eclipse.birt.report.data.oda.jdbc_version/drivers directory because it causes BIRT to hang when viewing the DataSource because of .jar size (wlfullclient.jar is 56MB).<br />
<br />
<strong class='bbc'>Problem 2:</strong> Even if all .jar files are in the ../drivers directory, in Birt 2.2.2 when previewing a report, the ContextClassLoader is a WebApp classloader and the login security has the wrong classloader, so it cannot find and load subject during the login.<br />
<br />
I can provide a <em class='bbc'>lot</em> more details of what I have tried if you are interested
<br />
<br />
<strong class='bbc'>Requested solution:</strong><br />
I am looking for a solution that would let me configure BIRT so that I would not have to modify my jdbc driver, but when Birt was accessing the ODA JDBC data source using my JDBC driver it will have the correct .jar files available to the correct class loader. <br />
<br />
If that is not possible, then I need to know what the appropriate changes would be to correctly let clients use the BIRT RCP Designer with our JDBC driver.<br />
<br />
Any help in this would be greatly appreciated
