Oracle JDBC - Class not Found

I am trying to start Maximo 7 Reports in Eclipse BIRT 2.3!
Copied the Classes Files into C:eclipseBirtpluginsorg.eclipse.birt.report.viewer_2.3.0.v20080606birtWEB-INFclasses and it's working fine! But MaximoDatasource does not find the Oracle JDBC jar file!
I copied it already into any lib and class file I found in some blogs:
C:eclipseBirtpluginsorg.eclipse.birt.report.viewer_2.3.0.v20080606birtWEB-INFlib
C:eclipseBirtpluginsorg.eclipse.birt.report.data.oda.jdbc_2.3.0.v20080610drivers
C:eclipseBirtpluginsorg.eclipse.birt.report.data.oda.jdbc_2.3.0.v20080610
...

A default Report is also working with oracle connection but not the maximo scripted datasource. Does anybody know where to place the oraclethin.jar?

Thanks a lot
Chris

Find more posts tagged with

Comments

luananicho

I'm just setting my system up and I'm having a heck of a time getting BIRT to work with the Maximo templates.

mwilliams

Hi Chris,

I believe the oraclethin file is supposed to go in the WEB-INFlib file that you have listed there. You tried that and it's not working?

AbhayTech

Paste oraclethin file in the WEB-INFlib file . Don't extract it ,I think it will work...

voller

<blockquote class='ipsBlockquote' data-author="AbhayTech"><p>Paste oraclethin file in the WEB-INFlib file . Don't extract it ,I think it will work...</p></blockquote>
<br />
Thanks a lot for you help, but this does not work??<br />
No Idea...

Krelek1000

Hi,

I think you are using the wrong version of Eclipse Birt. BIRT needs to be version 2.1.2. It is the only version supported by IBM and their Tech departments. I do not know if any other version will work with the Maximo and the JAVA classes needed to build the reports.

I am interested in the Oracle Thin client... That is the way we will be building our reports so any expierences you have might help me set up ours when the time comes...

As far as IBM states, make sure of the following:

U use BIRT REPORT VIEWER... 2.1.2.v20070205-1728...

Copy the com.lowagie.itext_1.5.2.jar file to C:eclipseeclipseplugins...

Create a Classes folder under WEB-INF

Copy the entire com folder to BIRT under a new folder called Classes

Copy the mxreportdatasources.properties file and put under the classes as well

Set up the maximoDataSource properties in the file... according to your maximo.properties file...

Copy and only Copy the JDBC Driver you need from maximoapplicationsmaximolib.. DO NOT COPY the ENTIRE Folder! It will not let BIRT run properly... Place in the WEB-INFlib folder of BIRT...

Now they show you configuring a shortcut in the lessons planned... Up to you to use...

Something like this...

C:eclipseeclipseeclipse.exe -vm "(Reference location of Java or JDK Path}" -vmargs -Xmx512m

Give those a try and see what happens! Let me know if you need more information!