Share My Creation [Project Template] jRDC3 Server

Features​

• Multi-database support — SQLite, MySQL, MariaDB, MSSQL, PostgreSQL, Firebird, DBF
• Zero-config SQLite — works out of the box with a bundled sample database
• HTTP API — clients send DBCommand objects over HTTP and receive DBResult responses
• Batch transactions — execute multiple INSERT/UPDATE/DELETE statements atomically
• SSL/TLS — optional HTTPS with configurable keystore
• Auto-provisioning — creates tables and seed data on first run
• Health check — /test endpoint verifies database connectivity
• Status dashboard — browser-based UI at / with HTMX-powered auto-refresh
• Request log viewer — real-time request log via HTMX polling, shown in a modal
• Debug mode — hot-reload SQL queries from config file on each request
• 6 build configurations — one-click select the database driver in the IDE

Supported Databases​

Getting Started​

Using the template (end-user)​

1. Copy or install the .b4xtemplate file from release/ into your B4J Additional Libraries folder.
2. In B4J, create a new project using the jRDC3 Server template.
3. Select your database Build Configuration (SQLite is the default).
4. Open Files/config.properties and set your database connection details.
5. Press F5 (Run).
6. Visit http://127.0.0.1:17178/ to see the status dashboard.

Building the template (from source) using #Macros​

1. Clone jRDC3.b4j to $APPNAME$.b4j.
2. Open $APPNAME$.b4j in a new B4J windows.
   Remove #Macro Step 1 to Step 5 and close it.
3. Package the template to release/jRDC3 Server (3.60).b4xtemplate.
4. Copy the .b4xtemplate file to B4J's Additional Libraries directory.
5. Check the created template in target directory.

Configuration​

API Endpoints​

/rdc Protocol​

• method=query2 — Execute a SELECT query, returns rows via B4XSerializator
• method=batch2 — Execute multiple DML statements in a single transaction

Architecture​

┌──────────────┐      HTTP (B4XSerializator)       ┌──────────────────┐
│  B4A / B4i   │  ──────────────────────────────>  │  jRDC3 Server    │
│  / B4J App   │  <──────────────────────────────  │  (B4J / Java)    │
└──────────────┘                                   └────────┬─────────┘
                                                            │ JDBC
                                                            ▼
                                                   ┌──────────────────┐
                                                   │   Database       │
                                                   │  (SQLite/MySQL/  │
                                                   │   MSSQL/etc.)    │
                                                   └──────────────────┘

Modules​

aeric said:

Supported Databases​

Database	JDBC Driver
SQLite	sqlite-jdbc-min-3.49.1.0
MySQL	mysql-connector-j-9.3.0
MariaDB	mariadb-java-client-3.5.6
MSSQL	jtds-1.3.1 / mssql-jdbc-12.2.1
PostgreSQL	postgresql-42.6.0
Firebird	jaybird-5.0.0.java11
DBF	javadbf-1.13.2 + dbschema-dbf-jdbc + H2

Click to expand...

Differences from original jRDC3 Server​

1. LoadSQLCommands​

Private Sub LoadSQLCommands(Config As Map)
    Dim newCommands As Map
    newCommands.Initialize
    For Each k As String In Config.Keys
        If k.StartsWith("sql.") Then
            newCommands.Put(k, Config.Get(k))
        End If
    Next
    commands = newCommands
End Sub

Private Sub LoadSQLCommands
    mCommands.Initialize
    For Each Key As String In mConfig.Keys
        If Key.StartsWith(mDbType & ".SQL.") Or Key.StartsWith("SQL.") Then
            mCommands.Put(Key, mConfig.Get(Key))
        End If
    Next
End Sub