|
Re: Oraclethin.jar+Cripted DataSource [message #368373 is a reply to message #368364] |
Tue, 26 May 2009 15:23 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Chris,
This should be working if you put it in the scriptlib dir. Can you try
one of two other methods:
1 - Create a java project in the same workspace as your report project.
In this java project create your scripted data source code. Make sure
to add the thin driver to your classpath by configuring the build path.
Set an example report in the report project to point to the scripted
ds and preview.
2 - Add the jar to the report using add jar button on the reports
resources tab in the property editor. You will need to move it into the
resource folder to see it.
Also does your report work in the deployed webviewer.
Jason
vollerchris wrote:
> 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 directory 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.
>
> I already tried to copy the jar-files into:
>
> )
> eclipse\plugins\org.eclipse.birt.report.viewer_2.3.2.r232_20 090212\birt\WEB-INF\lib
>
>
> )eclipse\plugins\org.eclipse.birt.report.viewer_2.3.2.r232_2 0090212\birt\WEB-INF\classes
>
>
> )eclipse\plugins\org.eclipse.birt.report.viewer_2.3.2.r232_2 0090212\birt\scriptlib
>
>
> Problem still remains!!!
>
>
> 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 = "jdbcracle: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
>
>
|
|
|
|
Re: Oraclethin.jar+Cripted DataSource [message #368393 is a reply to message #368386] |
Wed, 27 May 2009 16:49 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Chris,
To get the debugger to work look at the classpath tab in the debug
configuration and add the project that contains the scripted ds.
Jason
vollerchris wrote:
> Hi Jason!
>
> Thanks a lot for your help!!!!
>
> Part 1 is working with preview, however not with the javascript debugger
> (already tried to add classpath in the report debugger view) :-)
>
> But main problem is solved!
>
> thanks
> chris
>
|
|
|
Powered by
FUDForum. Page generated in 0.02573 seconds