Lucee Restful API cannot run Oracle Sequence

dev support
1

Hi,

Currently, I’m developing RESTFUL API for my project. After I triggered Oracle command to get sequence number from my Oracle Database, my restful function dont get the sequence number from database. My code as below:

SELECT OPAS_AMS_SEQ.NEXTVAL AS AMS_SEQ FROM DUAL

Is there any issue on lucee restful on Oracle?

Don’t forget to tell us about your stack!

OS: RHEL JBoss
Database: Oracle 12c
Java Version: 1.8.0_141 (Oracle Corporation) 64bit
Tomcat Version: ???
Lucee Version: 5.2.9.31

2

Check your permissions its a permissions issue with oracle.

3

I have tried this coding in other system with same permission but for restful api. The code cannot run normally.

4

Lucee runs with oracle

run this.

sqlplus / as sysdba

SQL> Grant connect, resource to THEUSERLUCEEISRUNNINGAS;

5

test

Thank you Terry for your suggestions.

I found another solution by creating identity column and create trigger for sequence so that column got automatic ID