B4J Question Connect to jRDC2 via HTTP (NodeJS)

[cheveguerra]

Hi everybody,

I have some apps (b4a) that use DBRequestManager to connect to an Oracle database and everything is working right, and I am also experimenting with a WhatsApp Bot and I need for the bot to connect to the same database, the bot runs on NodeJS and although it is possible to connect directly to the Oracle server, I would like to avoid that kind of connection (for security reasons), so the question is ... is it possible to connect to the jRDC server via an HTTP request??

NodeJS (Javascript) has "axios" and fetch and post, so, it is possible to make an http request to the jRDC server, but I dont know the headers required, and it seems that the parameters of the request need to be serialized for jRDC2 and something different for jRDC1.

So, does anybody have any idea if this can be done?


EDIT:

By @Erel suggestion, I added a new handler to the jRDC2 server.

Best regards

 

[Erel]

jRDC1 is irrelevant. Don't use it.

jRDC2 uses B4XSerializator which isn't supported by NodeJS. You can add another handler to jRDC2 that produces a Json response instead of the binary response.

 

[cheveguerra]

jRDC1 is irrelevant. Don't use it.

jRDC2 uses B4XSerializator which isn't supported by NodeJS. You can add another handler to jRDC2 that produces a Json response instead of the binary response.

So... modify the server and just use Json on the bot's side.

Thanks @Erel

Best regards

 

[aeric]

Alternatively, you can try my Pakai project template or EndsMeet server.
They support JSON and XML content type response.

[Project Template] Pakai Server v5

Pakai Server Version 5.30 GitHub: https://github.com/pyhoon/pakai-server-b4j Template: Pakai Server (5.30).b4xtemplate Depends on: EndsMeet.b4xlib (v1.30) WebApiUtils.b4xlib (v5.30) MiniORMUtils.b4xlib (v3.70) sqlite-jdbc-3.7.2.jar mysql-connector-j-9.3.0.jar mariadb-java-client-3.5.6.jar...

www.b4x.com

 

[cheveguerra]

Alternatively, you can try my Pakai project template or EndsMeet server.
They support JSON and XML content type response.

[Project Template] Pakai Server v5

Pakai Server Version 5.30 GitHub: https://github.com/pyhoon/pakai-server-b4j Template: Pakai Server (5.30).b4xtemplate Depends on: EndsMeet.b4xlib (v1.30) WebApiUtils.b4xlib (v5.30) MiniORMUtils.b4xlib (v3.70) sqlite-jdbc-3.7.2.jar mysql-connector-j-9.3.0.jar mariadb-java-client-3.5.6.jar...

www.b4x.com

Is there somewhere a description of the project?

Because

Version: 5.00

Create REST API Backend using B4J project template

is not all that descriptive

Best regards

 

[aeric]

Is there somewhere a description of the project?

Because

Version: 5.00

Create REST API Backend using B4J project template

is not all that descriptive

Best regards

It's a project template. You use it like an additional library but start by creating a new project.
For tutorial, check this link:

Pakai framework v5

Part #1: Get Started Introduction This tutorial is based on [Project Template] Pakai Server v5. Installation Option 1: Download and put the following files to Additional Libraries folder (don't put inside new subfolder) B4J: - Pakai Server (5.00).b4xtemplate - EndsMeet.b4xlib (v1.10) -...

www.b4x.com

If you don't need the web frontend, you can try this project:

[Server] Pakai example (backend only)

This is an example project generated from Pakai framework project template without frontend. Hence the project is smaller to start with. You can then use other tools like Curl, Postman or any API testing client to test the API endpoints. The API endpoints example included are categories...

www.b4x.com