B4J Question jSQL: no such function instr?

[tchart]

I have a B4J app which inserts some data into SQLite and then does some update statements.

Two of the update statements are failing with this error;

java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such function: instr)

However "instr" is a known function if I run the same SQL statement in another SQLite client (eg DB Browser for SQLite).

Is the function missing from the jSQL library?

 

[Erel]

The jSQL doesn't process the query. It just sends it to the JDBC driver.

See the answer here: http://stackoverflow.com/questions/17887558/why-does-sqlite-say-that-instr-doesnt-exist

You can upgrade to a newer SQLite JDBC driver.

 

[tchart]

Thanks Erel

 

[tchart]

Erel, thanks I downloaded a newer JAR from here;

https://bitbucket.org/xerial/sqlite-jdbc/downloads

Just a comment, the included sqllite-jbcd jar with B4J appears to be really old, the SQLite release that includes instr is from 2012.

Is this specific B4J version included because of compatibility?

 

[Erel]

Is this specific B4J version included because of compatibility?

No. jSQL is compatible with any JDBC driver.