jrdc2

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...

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...

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...

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...

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...

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...

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 #...

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...

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...

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...

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

Hello, in PDO you can use one liner(almost) to get the total nr of rows of your DB table $nRows = $pdo->query('select count(*) from blah')->fetchColumn(); echo $nRows; is there something similar for jRDC, so I do not need to fetch all data and then count it in my program, but let the server...

HI ALL! BEEN AN AWESOME 3 WEEKS, BUT I FINALLY HAVE A B4A SOLUTION FOR ACCESSING A MSACCESS FILE ON A NETWORK (AT THIS STAGE WITH NO PASSWORD.. NEED YELP) USING B4J AS THE SERVER AND B4A FOR THE CLIENT. DUE TO POSTING SIZES I CAN'T SHARE ON THIS GROUP, BUT IF YOU WANT THE SOLUTION, PLS EMAIL...

Hello, is this old threads still valid? https://www.b4x.com/android/forum/threads/server-ssl-connections.40130/#content if so then where should these scripts be put? in jRDC server project created in B4J or in the B4A project which is requesting the data? For me it is not clear in that thread...

Hello, it's looks that importing data from mariadb with jRDC is very very strict, causing errors which take a lot of time to understand. (no offence, no doubt I'm the biggest cause) If I import via Select a row from DB and a column has date like yyyy-mm-dd, should the variable where this data...

Hello, Some strange is happening, I can't figure out what, it must be something very small or it is a bug. I have a few buttons,which are to do something else, but I misuse them for now to figure something out. Strange thing is that I get errors depending on who knows what. I'm just testing...

Hello, I have 1 jRDC.jar running on linux as server. Work ok with B4A test app. I did not understand the description for using 1 server for 2 database. I looked for similar other questions in forum. Then I use same jRDC for 2nd DB but changed this line in Main sub appstart to...

Hello, So I connected to my remote database successfully, but sometimes I get this warning/error. How can I avoid it? Full warning/error line: 2021-09-23 07:27:31.112:WARN:oejh.HttpParser:qtp902919927-1723: Illegal character 0x3 in state=START for buffer...

I am going through the tutorial from this post: https://www.b4x.com/android/forum/threads/tutorial-of-connecting-android-to-ms-sql-server-using-jrdc2.114856/ From the tutorial I have managed to start the webserver and can confirm the connection to the SQL server database is working. I get the...

Ola First, thanks to everyone and each of our sponsors and donators who has made this possible. This would not be possible without B4X and BANano. Many thanks to those intellects. Over the past few months we have been attempting to ensure BANanoVuetifyAD3 works very well with jRDC2. We have...