jrdc2

  1. cheveguerra

    Android Question Database connection with jRDC2 - Best Practices

    Hi everybody, I have an app that has to connect to 3 different database servers, and was wondering what is the best way to do it: Create 3 different instances of DBRequestManager and use each one depending on what database I have to access. Create a single global instance of DBRequestManager...
  2. Serge Nova

    Android Tutorial B4A Social Network Version 1.50

    Hello every one, The old version (1.30) of this social network can be found in this link: https://www.b4x.com/android/forum/threads/b4a-social-network-version-1-30.141765/#post-921065 After several days of work, version 1.50 of this social network which brings the correction and several...
  3. Alex.Gi

    iOS Question jRDC2 DB access problem

    Hi, January 24, I've released last update of my APP on Apple Store. On iPhone SE, 6, 7 app runs ok. On latests version of iPhone jRDC2 server sends these messages: feb 07, 2024 5:23:19 PM org.firebirdsql.logging.JulLogger warn WARNING: WARNING: No connection character set specified (property...
  4. vfafou

    B4J Question jRDC2 Windows 11 problem when running in release mode outside the IDE

    Hello! I need a way to run the jRDC2 before the user run my application. I've built the jRDC as a standalone package but I take the following errors when I run my application! I use jdk-14.0.1 and trying with 11.0.1 I have the same results. Running in release mode from the IDE, all are working...
  5. EnriqueGonzalez

    B4x Focused VPS

    Hello everyone! In the past few years i have been working with many people here in the forum with a wide range of projects yet all of them have in common that they need a server, sometimes for a simple JRDC2 and other times for a full fledged Jserver implementation. Well today i am offering a...
  6. C

    Android Question Connection to two MS SQL Database depending on the registered user

    Hello. I need help with the following situation: Context: I have an initial screen that asks for a username and password. Depending on the user that enters I need to make the connection to database #1 or #2 or #3. I connect to MS SQL Server using jRDC2 and a file containing the config...
  7. M.LAZ

    B4J Question jRDC2 Testing ip address

    Hi,, i'm trying testing jRDC2 on my local browser and my Dedicated Server : when put in local browser or Server browser : http://localhost:51029/test result is this is Your ip : [0:0:0:0:0:0:0:1] http://127.0.0.1:51029/test result is this is Your ip : 127.0.0.1 in...
  8. aeric

    B4J Code Snippet [Project Template] [B4X] jRDC2 Client (B4J, B4A, B4i)

    Version: 1.00 Description: JRDC Client Template to be used with jRDC2 Server Template. . . . . Note: The designs are similar to Web API Client but the code are different. How to use: 1. Create a new project from B4A, B4i or B4J 2. Change the rdcLink in Main module to your server IP 3. Run
  9. aeric

    B4J Code Snippet [Project Template] jRDC2 Server (SQLite, MySQL, MS SQL, Firebird, Postgresql, DBF)

    jRDC2 Server Template Version: 1.12 (based on jRDC2 version 2.23) Create a new project and run it! To be accompanied with jRDC2 Client Template Introduction: To be edited Version 1.00 : 9KB Version 1.11 : 127KB Version 1.12 : 127KB Version 2.00 (beta) : 127KB Note: If you think the latest...
  10. M

    B4J Question jRDC2 (EofException) org.eclipse.jetty.io.EofException: Closed

    What would be the best way of handling this error in the jRDC2 server when a clients connection is interrupted to the server?. I have the usual try/catch on the outputstream.writebytes but still seems to be happening, it's intermittent with connections and then is normally followed by...
  11. aspi

    Spanish [Solucionado] Conexión a SQL SERVER con jRDC2

    Hola a todos. Siguiendo el tutotal de José Aguilar (https://www.b4x.com/android/forum/threads/tutorial-acceder-a-base-de-datos-con-jrdc2.130278/), he conseguido hacer funcionar el ejemplo con mis consultas desde B4A a un servidor sql server a través de B4J. Hasta aquí todo bien. El problema...
  12. Alex.Gi

    Android Question [Solved] jRDC2 problem with date parameter

    Hello guys, I have a Firebird DB on my server, all runs OK, all querys run OK, but I have a little problem when I try to set a string parameter tha contains a date. This is the error message: Error 500 org.firebirdsql.jdbc.field.TypeConversionException: Error converting to object. in...
  13. amorosik

    B4J Question How to protect communication from mobile device to jRdc2 server?

    I would like to create a system for taking orders from customers at home to pizzerias The app used by the individual customer runs on a smartphone or tablet and uses a jRdc2-type system for reading/writing information on the 'orders' database The 'orders' database physically resides on a...
  14. mmieher

    B4J Question [SOLVED] jRDC Noob Binding Puzzler - Failed to bind to 0.0.0.0/0.0.0.0:17178

    Years ago, I made RDC work in B4A with an insecure Windows server. Today, more confident UBUNTU server is resisting connection. I do not know why I get this in DEBUG? Where is "0.0.0.0" coming from? 2023-01-25 08:42:03.104:INFO :oejss.DefaultSessionIdManager:main: Session workerName=node0...
  15. B

    Android Question RDC conector not take database specified in config.properties file

    Hi, I've running RDC server and works fine, but the test URL always shows this RemoteServer is running (10/25/2022 13:44:24) Error fetching connection. In config.properties file I've this config #DATABASE CONFIGURATION DriverClass=com.mysql.jdbc.Driver...
  16. J

    B4J Question [B4X] jRDC2 - Issues with sql command not found

    Hello I'm experimenting with the jRDC2 tool, but at this point, I'm receiving a weird issue. I created a sql query, just like in this tutorial, but for some queries I receive the message that the command could not be found out of the config.properties file. jRDC2 server: #SQL COMMANDS #...
  17. J

    B4J Question [B4X] jRDC2 - How to use multiple databases and add basic authentication and TLS

    Hello I tested out the functionalities of jRDC2 and I want to implement this in new software we're going to develop. But with the library I got from this tutorial, all connections to the jRDC2 webservice are plain text http (no TLS) and there's also no basic authentication implemented. How can...
  18. P

    B4J Question How do I use the JRDC when the database and JRDC are on different servers?

    I rented a cloud database, so my database and JRDC are located in different servers. I can connect to my cloud database using Navicat, but I can't connect to the WEBSITE using JRDC, I don't know what the problem is. I changed the JdbcUrl of the config file to < database external IP >: database...
  19. I

    iOS Question Accessing a database residing on a Local Network Pi Server

    Hi All, I have a requirement to use a Raspberry PI as a Local DB server, but I need to support both Android and iOS clients. I was looking at this post: https://www.b4x.com/android/forum/threads/mariadb-does-not-wait-for-query-results.132054/post-833507, and it seems to be straightforward with...
  20. W

    B4J Question Timestamp in INSERT error

    I have timestamp column in my postgres db. When I want insert record, there is an error: "PSQLException: ERROR: syntax error at or near $2" This is my sql: INSERT INTO table (name, "date") VALUES (?, TIMESTAMP ?) Column type: name - varchar, date - timestamp
Top