Hi!
We are using a scripted Datasource to connect over Oracle JDBC with Oracle DB! With Birt-Version 2.2 everything works OK (copy oraclethin.jar into lib dir of birt-viewer) but now we are using BIRT 2.3/2.5!
I always got the error, "Class not found exception: oracle.jdbc.driver.OraclDriver
when previewing in Eclipse.
However, the report works fine, when copying it direkt to Webengine.
I have already tried to copy oraclethin.jar into severel directories of my Eclipse/BIRT installation but no change???
Is this a bug with BIRT Version 2.3/2.5?? Does anybody know, where to place a *.jar file, so I can call it with JavaScript in a Scripted Datasource??
My Sourcecode in initialize Method of the Report:
importPackage(xyz.report.script);
mxReportScriptContext = ReportScriptDS.getDesigntimeConnection();
Code in ReportScriptDS Class:
public static Connection getDesigntimeConnection() throws Exception {
String url = "jdbc:oracle:thin:
@localhost:1521:instance";
String userName = "user";
String password = "pwd";
String schemaOwner = "pwd";
String driver = "oracle.jdbc.driver.OracleDriver";
Class.forName(driver);
Connection connection = DriverManager.getConnection(url, userName, password);
return connection;
}
Thanks a lot for your help
Chris
