I am trying to create an SQLIte database, build and populate its tables from code using the SQL object from jSQL library.
I want to read the SQL script/queries from a text file but am finding when I do that I get an error:
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database...
Hi,
I have a SQLite problem with a simple query ...
When I run this query from windows, I get correct results.
When I run it from B4J, I get wrong results.
I just upgrade to B4J version 9.80, the jSQL.jar date is 2022-07-05 (version 1.61 in B4J IDE)
Should I upgrade to a more recent jSQL.jar...
Hello, I kept getting this Error when trying to insert into MYSQL Database (Using WAMP). The First Item is inserted then, it crashes
Waiting for debugger to connect...
Program started.
---------- NorthWind Database (MySQL) ----------
connected
Error occurred on line: 41 (SD_SQL)...
This wish is for enabling jSQL's locking for alternative SQLite JDBC drivers. Various methods for enabling this could be (this is a repeat found in my post here: https://www.b4x.com/android/forum/threads/sqlite-jdbc-driver-with-encryption-and-authentication-support.110565/#post-690205):
1) If...
Hello.
I'm writing an app that allows several computers to add new orders to the database. To avoid any conflicts, I want to make sure that when one system is adding a new list of orders, no others can interrupt and will have to wait for the first one to finish up. I understand that the most...
Hello,
I am trying to reference a postgres database with jSQL and i get the following error:
Waiting for debugger to connect...
Program started.
Error occurred on line: 57 (Main)
java.lang.RuntimeException: Class not found: org.postgresql.driver
Are you missing an #AdditionalJar attribute...