jrdc2

  1. 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 #...
  2. 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...
  3. 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...
  4. 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...
  5. 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
  6. S

    B4J Question total rows from db table via jRDC

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

    Android Question MSACCESS & jRDC2: SOLVED!!

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

    B4J Question jRDC and SSL Let's Encrypt

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

    B4J Question What type should the variable be, when importing Date from DB?

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

    B4J Question Get error when request data from jRDC server

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

    B4J Question Error connect B4J via 2nd jRDC on Linux

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

    B4J Question JRDC2 Warning/Error

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

    Android Question [Solved] JRDC2 and SQL Server: B4A client issue or SQL server or firewall?

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

    BANanoVuetifyAD3 - Contact Manager WebApp featuring MySQL + jRDC2 (no PHP)

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

    B4J Question jRDC2 connection via linux server

    Hi i have a problem connecting my jRDC2 connector in my linux server to my b4a app. In my CentosOS 7 i run my jrdc2 and open my server port using : sudo iptables -I INPUT -p tcp -m tcp --dport 17170 -j ACCEPT then curl http://xxx.xxx.xxx.xx:17170/test and get an output RemoteServer is running...
  16. J

    Android Question Login Form using MySql in jRDC2 Help!

    Hi! I'm an absolute newbie here, I need help in validating my database using MySQL. here's my query sql.validate=SELECT * FROM `tbl_userinfo` WHERE `Username` = '" & uName.Text & "' AND `Password`='" & pWord.Text & "' In here, I have two edit texts, uName and pWord. It works just fine when I...
  17. José J. Aguilar

    Spanish [B4XPages] jRDC2 + MySQL CRUD + Login

    Hola a todos: Por fin me he puesto a probar un poco con B4XPages, y he empezado a adaptar el ejemplo B4XPages + B4XDrawer Creo que he visto algunos ejemplos con php + mysql para hacer login, etc... pero he visto pocos con jRDC2. Los datos de la base de datos y la interfaz gráfica son bastante...
  18. José J. Aguilar

    Android Example [B4XPages] jRDC2 + MySql CRUD + Login

    Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A...
  19. G

    Android Question [B4A] Cannot connect to database

    Hello there, Can anyone help me? i tried to use b4a to mysql with b4j jRDC and show this error ResponseError. Reason: java.net.ConnectException: Failed to connect to /192.168.0.8:17178, Response: ERROR: java.net.ConnectException: Failed to connect to /192.168.0.8:17178 The IP Addresses is...
  20. OliverA

    B4J Library Alpha/Beta testing if jRDC2 with returning auto-generated key values after INSERT

    I've had this mod sitting on the sidelines since last fall. Looks like there is a need for this as shown in this post: https://www.b4x.com/android/forum/threads/rdc2-select-last_insert_id.126310/ In order to retrieve the auto generated key values for an INSERT statement, I've added the...
Top