Is Lucee able to make a WebService Rest API for OracleDB?

Hello everybody.

I’m studying ways to make a connection from Flutter Apps to Oracle Databases set with Windows Server.

With Lucee I’ll be able to make this bridge? I need to make the common SQL Query commands (select, update, insert etc.).

I found some tutorials in making the Rest API with NodeJS, and since Lucee is JavaScript related maybe would fit for my purposes.

absolutely, Lucee / cfml makes this all very easy working with databases, json etc

I’d advise avoiding the built in Lucee REST stuff

you’ll have more fun using a CFML framework like https://www.contentboxcms.org/ or http://taffy.io/

there was a bug with Oracle and transactions which is fixed in the latest 5.3.8 SNAPSHOTs, which will be released soonish, so I’d recommend start playing with the latest SNAPSHOT

https://luceeserver.atlassian.net/browse/LDEV-2933