Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  BIRT 431 preview: Java/JDBC for Oracle compatibility issue

    Posted Wed November 18, 2020 12:16 PM
    Maximo 7.6.1.2; BIRT 431; Oracle 12c

    I want to preview my reports (by connecting from BIRT to the Maximo database).

    If I understand correctly, BIRT 431 requires Java 7. Yet, the latest version of JDBC for Oracle requires Java 8 (older drivers won't connect to the database).

    If that's correct, then how can I preview BIRT reports if BIRT 431 doesn't support any functioning JDBC drivers?

    (I'm new to BIRT, so please feel free to correct any inaccuracies.)
    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: BIRT 431 preview: Java/JDBC for Oracle compatibility issue

    Posted Wed December 23, 2020 01:13 PM

    We are having the same problem with SQL Server and 7.6.1.  WebSphere 9 uses Java 8, but BIRT needs Java 7.  Still working with support trying to get this resolved.  The latest from support is to install this on a separate workstation that does not have Java 8 on it.



    ------------------------------
    Mike Starkey
    IS Manager
    Washington University in St Louis
    St. Louis MO
    314-935-4485
    ------------------------------

    Original Message


  • 3.  RE: BIRT 431 preview: Java/JDBC for Oracle compatibility issue

    Posted Wed December 23, 2020 01:41 PM
    Edited by System Admin Wed March 22, 2023 11:53 AM

    Thanks. Glad to hear it wasn't just me.


    #Maximo
    #AssetandFacilitiesManagement


  • 4.  RE: BIRT 431 preview: Java/JDBC for Oracle compatibility issue

    Posted Thu December 24, 2020 08:42 AM

    Did you try utilizing the files in this technote: Configure Report designer (Eclipse) for Maximo 7.6.1.x (ibm.com)

    We develop for customers on 7.6.1 and 7.6.0 and have a similar config for both which works for us but we almost exclusively develop reports on SQL Server/DB2. I would be surprised if you couldn't connect to 12c with the driver they attached as 12c was supported for later 7.6 versions and all of the 7.6.1 versions. It's honestly not something I've tested but I will if you're still having issues.

    For running it as Java 1.7, if you don't want to install an unsupported Java version like this on your machine, you might be able to do what we do which is run the IBM Java SDK (which has an extractable option without installing) and then specify the -vm argument prior when running BIRT. For example, I've pasted a snippet of our bat file we use to launch it.

    start %BIRTdir%\eclipse431\eclipse.exe -vm %BIRTDir%\java_1.7_64\bin\javaw.exe -vmargs -Xmx512m

    Getting the version for Windows is more complicated because they don't make that readily available like they do for Linux systems. We previously downloaded it from the Eclipse Development (Java SDK downloads, Eclipse (ibm.com)) but that has been updated to 1.8. If nothing else, you could have both java versions installed and then use something similar to utilize the proper 1.7 Java runtime but that's obviously not entirely ideal.



    ------------------------------
    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH
    ------------------------------

    Original Message


  • 5.  RE: BIRT 431 preview: Java/JDBC for Oracle compatibility issue

    Posted Mon December 28, 2020 10:19 AM

    I have WebSphere 9 running on my laptop (and Microsoft SQLServer) and that combination quite happily runs Maximo 7.6.1 on my laptop. I also have Birt on the same laptop and a 'portable' version of Java 1.7 (i.e. I did not install it, I simply copied it off a different machine, thus my Windows operating system is unaware there is Java 1.7 on the laptop c: drive).
    At   `\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF`  I have `\classes-DB2`, `\classes-MSSqlServer` and `\classes-Oracle` folders. Depending on the clients configuration (DB2, MS SQL Server, Oracle), I can copy (overwrite) the appropriate folder to the \classes folder. This works ok. As Steven Shull says in this thread, put appropriate syntax against the desktop icon so it finds Java 1.7. On my desktop icon I have the target and start in and comments set to :
    C:\MyProgs\EclipseForBirtMx76\eclipse.exe -vm "C:\MyProgs\JavaVersions\17-64bit\jre\bin\javaw.exe" -vmargs -Xmx512m
    C:\MyProgs\EclipseForBirtMx76
    Birt Eclipse Kepler for Maximo 7.6 reports



    ------------------------------
    Steve Ashley
    ------------------------------

    Original Message


  • 6.  RE: BIRT 431 preview: Java/JDBC for Oracle compatibility issue

    Posted Fri September 24, 2021 08:58 AM

    A colleague provided this solution. I haven't been able to test it yet.

    Use the latest available version of the jdbc driver for Oracle designed for Java 7:

    In order to get preview features working for Eclipse BIRT 4.3.1 the following steps need to be taken:

    1. Be sure that the version of Java being used for Eclipse is version 7. If it isn't change it to version 7 as the preview feature will not work with 8.
    2. Review chapter 2 in the attached document.
    3. Save the attached file (ojdbc7.jar.txt) to the folder eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\lib below your base eclipse installation folder. Rename the file removing the ".txt".
    4. Create a copy of the file and change the extension from ".jar" to ".zip".
    5. Extract the contents of the zip file to eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\classes
    6. Confirm Eclipse configuration as per the documentation from point 2.
    7. Test with a report to confirmation functionality.
    8. If there is an issue with the built in tool for previewing report output you may need to configure Eclipse to use a web browser instead.
    9. In Eclipse use Window -> Preferences -> Report Design -> Preview.
    10. Check the option "Always use external browsers."
    11. Click on the Web Browser link.
    12. Click on the "Use external web browser" radio button and check "Default system web browser" or the browser of your choice if it appears in the list.

    Related:

    Maximo76_Designer431_Report Development Guide_Rev8.pdf


    Original Message