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

JdbcSQL is actually a B4A + B4J library.
link: Hi Im trying this, however I get errors. Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driv
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

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

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: 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
link: Can jRDC2 manage multiple concurrent clients?

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

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

Hi, are there any updates for JdbcSQL.jar and JdbcSQL.xml or mariadb.jar and mariadb.xml librarys ? I have JdbcSQL version 1.5 but only works with old versions java connectors (mariadb-java-client-2.4.4.jar).
link: JdbcSQL doesn't need an update. Any error you encounter isn't related to JdbcSQL. Start a new thread and post more information.

I recommend you to switch to jRDC2. It will work better.
link: I changed the following AdditionalJar statement from #AdditionalJar: mysql-connector-java-5.1.34-bin To #AdditionalJar: mysql-connector-java-8.0.28 I
link: I know it is not recommended to use this library anymore. It is an app written in the year 2017 and all these years it worked fine until I moved to a
link: I am using jdbcsql with a mysql 5.1.43 server in an B4A app with no problems. I already have a running mysql 8.0.25 in my dev machine, so I did some t

JdbcSQL - Directly connect to remote databases: https://www.b4x.-directly-connect-to-remote-databases.84016/

Powered by ColBERT