Skip to Main Content
Merative Ideas Portal

Shape the future of Merative!

We invite you to shape the future of Merative, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Start by posting ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the Merative team to refine your idea

Help Merative prioritize your ideas and requests

The Merative team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at Merative works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at Merative, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Merative External Privacy Statement:

Status Future consideration
Created by Saika Sharmeen
Created on Jul 27, 2023

Upgrading the H2 DB Driver for Curam SPM

In SPM OOTB repo, CuramSDEJ folder has a "drivers" folder which has h2-1.3.176 driver (2014).

We are looking for upgrading this driver in the OOTB, so that latest H2 functionalities can be used to execute the Oracle SQL queries in H2.

As we had created a PMR for this, it was recommended to raise an enhancement request.

Customer Name Department of Employment and Social Development (ESDC)
Persona Based Summary

As a developer, I would like to use the latest H2 database driver in my local workspace from Curam repository. This will allow us to use H2 supported functionalities in executing Oracle SQL queries in H2.

Market Segment Eligibility & Entitlement
Type of Request Customer Requirement
Market Opportunity

Upgrading the H2 driver would allow many other clients to use the H2 database with all the supported functionalities with Curam.

Usage frequency + #/type of users impacted

This solution would be used by more than 10 users frequently.

CURAM:Workarounds + Proposed Solution

Since Oracle DB build time is extremely long in the ESDC laptops using VPN with occasional timeout errors, we are using H2 database in our locals. So far the errors seen in the H2, due to Oracle SQL queries are fixed using the INIT and RUNSCRIPT feature from H2. Some examples:

1. Oracle to_date() error in H2 is fixed by creating an ALIAS in the initialization script.

2. Date format errors in H2 are fixed in the DMX files.

3. The Fetch statement is supported only for mode DB2 or Derby or PostgreSQL in H2-1.3.x version. It is supported from H2-1.4.x for all modes. To solve the issue: “SETMODE=PostgreSQL” is used as a workaround for now.

Upgrading the H2 driver in the OOTB CuramSDEJ folder, would allow us to use the latest H2 functionalities to execute the Oracle SQL queries in H2 besides writing the user defined functions as explained above.

  • Attach files
    Aug 9, 2023

    Hi Saika,

    We have reviewed your enhancement suggestion. Based on the information provided our understanding of your request is as follows:

    • You are requesting that the version of the H2 DB Driver that is shipped with product be upgraded to the latest version of the H2 database to support the capabilities that are available in the newer version of the software.

    The theme is aligned with our current strategy for our product to continue to stay current with third part tooling and we have accepted your suggestion as a consideration for a future release.

    Thank you for taking the time to share your ideas with us. We are committed to involving our users in building our product roadmap and appreciate your suggestions.

    Sheryl Brenton, SPM Product Management Team

    1 reply
    Aug 1, 2023

    Hi Saika,

    Thank you for taking the time to share your ideas with us. We are committed to involving our users in building our product roadmap and appreciate your suggestions.

    We will review the information you have provided and get back to you within 30 days. If additional details are required to complete our evaluation, we will send you a request for more information.

    Thank you,

    Sheryl Brenton, SPM Product Management Team