• JDBC Access

    By John Q Parker 1 decade ago

    I am disappointed that it seems IBM is not releasing any more upgrade packs beyond Upgrade Pack 1. I was hoping that the stated intention to release them faster than fixpacks would be upheld, but it doesn't look like it. I understand that Domino 9.0 was released with the two-year old Upgrade Pack 1 incorporated in it.

    I am looking to do some integration with Oracle, but I am concerned that if I switch to the unsupported OpenNTF code library to get the JDBC access, other things may break in my code.

    Can I make the switch without breaking existing dbs? I am using the Extension Library controls all over the place.

    Also, what about Domino 9.0? Will I be able to remove the Upgrade Pack 1 and replace it with the OpenNTF version? Will IBM ever release an Upgrade Pack 2?

    Should I avoid the whole issue and go web services instead? Or use LEI or DECS?

    Help!

    • Re: JDBC Access

      By Cameron Donnelly 1 decade ago

      Hi John,

       

      I've been playing with JDBC access, and have successfully created a SQL-Server Plugin, created a REST service that does a query to the Database and populates a JQuery Grid on an XPage.  It's a bit of a long winded process to create the OSGI plugin, and I followed step by step the instructions in the XPages Extension Library book from IBM, including the .JDBC file in the Package Explorer of the database.  But, it works, it's fast.

       

      Cameron

       

       

      • You used the OpenNTF version?

        By John Q Parker 1 decade ago
        • Yes,used the OpenNTF version

          By Cameron Donnelly 1 decade ago
    • Nobody?

      By John Q Parker 1 decade ago

      So nobody has any answers or suggestions for me?

    • RDBMS support

      By Paul Hannan 1 decade ago
          <p dir="ltr">
              The RDBMS support, along with the Social Enabler support, is part of the extended components (extlibx) of the XPages Extension Library. It is only posted as part of the OpenNTF release of the ExtLib and not as part of the the IBM releases of the ExtLib.</p>
          <p dir="ltr">
              The ExtLib is constantly changing through new features, enhancement to existing features, and bug fixes.</p>
          <p dir="ltr">
              To lessen the already low risk of any perceived failure to an app that use the IBM ExtLib (which has had but two releases - 8.5.3 UP1 and 9.0) and switching to the OpenNTF releases of the ExtLib it may be prudent to take releases from OpenNTF that match the IBM releases. So for the 853 UP1 release, take the <a href="http://www.openntf.org/internal/home.nsf/release.xsp?databaseName=CN=NotesOSS2/O=NotesOSS!!Projects%5Cpmt.nsf&amp;documentId=FF91393957F92ECE8625796D00630BB8&amp;action=openDocument" target="_blank">December 2011</a> OpenNTF release; for the IBM Notes Domino 9.0 release take the <a href="http://www.openntf.org/internal/home.nsf/release.xsp?databaseName=CN=NotesOSS2/O=NotesOSS!!Projects%5Cpmt.nsf&amp;documentId=27191EA33DB016A086257B55004D7035&amp;action=openDocument" target="_blank">April 2013</a> release. Though you may find that by keeping your ExtLib up-to-date with releases from OpenNTF that your apps could benefit from bug fixes and enhancements.</p>
          <p>
              Hope this helps.</p>
          <p>
              &nbsp;</p>
      </div>
      

  • By B Gleeson 10 years ago

    You may or may not be aware, but in release 7 of the v901 Xpages Extension Library, the RDBMS feature in XPages was moved out of ExtlibX and into the main ExtLib. You can download it or a later release from the Downloads/Releases page of this project.

    To answer another of your questions, installing an ExtLib release on top of your domino server will mean that all the plugins from that extlib release will take precendence over any matching plugins from an Update Pack or from the base domino server install. It is always our attention not to break existing apps/dbs with each extlib release, but obviously things can go wrong & unforeseen issues can arise. If you report any problems to us in this forum, then we will endeavour to fix them in future extlib releases.

    Hope this helps.