jsql

  1. C

    B4J Question Reading SQL DB script from a file

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

    B4J Question jSQL ... need to upgrade ?

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

    B4J Question SD_SQL error - java.lang.reflect.InvocationTargetException

    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)...
  4. OliverA

    Wish Enable locking for alternative SQLite JDBC drivers

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

    B4J Question Using jSQL to Lock a mySQL table for writing

    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...
  6. Pedro Caldeira

    B4J Question jSQL and postgres

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