Canadian Imperial Bank of Commerce
Last activity: 21 Apr 2022 8:57 EDT
Getting NullPointer exception when trying to get nextval('sequence') using executeRDB
We have a requirement to get sequence numbers for some datatypes, the numbers should be strictly sequential hence we cannot use GenerateID since we need caching for case types.
We created a database sequence and trying to get the nextval using
tools.getDataBase().executeRDB("Select nextval('Sequence')",Clipboard Page);
However this is always returning null.
The same query works fine with RDB-List written in an activity (we want to avoid activities) and use function that takes the sequence name as a parameter.
***Edited by Moderator Marije to add Capability tags***