Search Results

This is a port of B4J jSQL library. The SQL type was renamed to JdbcSQL and ResultSet was renamed to JdbcResultSet, this allows using it together with the SQL library. SQL library - local SQLite databases. JdbcSQL - Any remote SQL database with a supported JDBC driver. MySQL and MS SQL are support
link: I´ll remove my library and i will use this Lib instead. :-) I also recoment it to anyone but keep the insecure in mind.
link: @DonMafred Finally.
link: Hi, I'm trying to use JdbcSQL library to manage Firebase Database service (for an online scoreboard), but don't know if it's possible and, if so, whic

JdbcSQL and PHP are related to exact 0% You EITHER use jdbcsql OR php. With jdbcsql you need to use your database credentials in B4A and you also query/update/insert the data using SQL Commands in B4A. With jdbcsql you NEVER use any PHP-Script.
link: Oh I see! Basically I want secure access to read and write data. So which do I need ? Hopefully the one without the PHP? Please advise Richard
link: Hi I have read the tutorial and downloaded the example code Mysql and I can read the database held at job.PostString("https://www.b4x.com/android/c
link: Then you should NOT use jdbcsql (especially not when you upload the app to the playstore!). Note that the DB-Credentials are inside your app and they

STDBY$EVENTS LOGSTDBY$APPLY_MILESTONE LOGSTDBY$SCN LOGSTDBY$FLASHBACK_SCN LOGSTDBY$PLSQL LOGSTDBY$SKIP_TRANSACTION LOGSTDBY$SKIP LOGSTDBY$SKIP_SUPPORT LOGSTDBY$HISTORY LOGSTDBY$EDS_TABLES Enjoy...
link: Hello Hope, That's not an IP address issue, you have to grant the correct permission to the user on the IP address. The logs in my original post were
link: call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(Thre

JdbcSQL is actually a B4A + B4J library.
link: Watch the SQL video tutorial: https://www.b4x.com/etp.html I'm not sure whether this library supports async methods and parameterized queries. If not
link: It does not support them, although it is possible to implement them. Simply because it is a solution born for b4a and specific for rare cases that it

I see the problem. You should use jSQL. JdbcSQL is a B4A program and it doesn't work with ConnectionPool.
link: You haven't initialized the SQL object. Note that JdbcSQL is a B4A library. No reason to use it with B4J (though it will work).
link: At some point I added the jdbcSQL library and replaced all my "jSQL" object references with "jdbcSQL" objects. If I revert back to jSQL it all works p

Try this: https://www.b4x.com/android/forum/threads/sql-simplyfying-calling-stored-procedures.73181/#content
link: Hello, i try to call a stored procedure in sql server using in/out parameters, but i dont know how to set in or out direction. My code: Private Sub S

jRDC2 - middleware server, based on jSQL (same as B4A JdbcSQL) that acts as a proxy between the clients and the db server. JdbcSQL = jSQL - library to directly connect to databases. If you are building a mobile solution then you should use jRDC2.
link: Can jRDC2 manage multiple concurrent clients?
link: Hi everyone, I don't know if this is the right forum. I apologize in case it's the wrong one. It may have been already explained in the related tuto

B4A JdbcSQL = B4J jSQL. Same library. The difference is in the Mariadb driver which probably isn't compatible with Android. Solution: Run jRDC2 on your RPi.
link: ? Erel I'm sorry ... the strange code is for explain why I can't connect form android devices to the remote database. But it seems that my explanation
link: If mariadb-java-client-2.4.2.jar is compatible with Android then you can use the JdbcSQL library. It is identical to B4J jSQL library. However a bett

I repeat if you didn't get it. Only JdbcSQL provides direct connection in B4A and B4J. jRDC2 is a middleware server that you need to install on the server (or another server that use JdbcSQL or having direction connection to the database server if it does exist).
link: The JdbcSQL library links contains an example in first post https://www.b4x.-directly-connect-to-remote-databases.84016/
link: This is a critical system and not one to screw around with. Nor to divert more resources for unnecessary scripting. Please stop asking to ignore that
link: The 3 most common solutions in this forum are explain in the following threads: 1. JdbcSQL 2. jRDC2 3. PHP I don't use above solutions. I created my

Ok ,thank you all the solution was here JdbcSQL - Directly connect to remote databases | B4X Programming Forum
link: Yes , i understand but the problem is that the jdbcSQL library does not appears in library tab , otherwise i would have checked it. My problem is e
link: i added #AdditionalJar: jtds-1.3.1.jar to #Region Project Attributes and did the same for mssql-jdbc but the package remains unloaded and the line

Powered by ColBERT