SQLite Forum

Is SQLite support JSON_VALUE function of SQL Server?

Is SQLite support JSON_VALUE function of SQL Server?

(1.1) Originally by Kalahasthi Satyanarayana (KalahasthiSatyanarayana) with edits by Richard Hipp (drh) on 2020-03-21 22:20:54 from 1.0 [link] [source]

Is SQLite support JSON_VALUE function of SQL Server?

Error Logs :

2020-03-22 03:23:58.226 ERROR [,,,] 29356 --- [           main] o.h.engine.jdbc.spi.SqlExceptionHelper   : [SQLITE_ERROR] SQL error or missing database (no such function: JSON_VALUE)
2020-03-22 03:24:39.082 ERROR [,,,] 29356 --- [           main] c.d.g.b.invoice.service.InvoiceService   : Error in fetching InvoiceEntityList from DataStore javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement

(2) By Warren Young (wyoung) on 2020-03-22 03:20:42 in reply to 1.1 [source]

(3) By anonymous on 2020-03-22 04:47:49 in reply to 1.1 [link] [source]

I do not use SQL Server, but I looked up the documentation for the JSON_VALUE function of SQL Server, in order to see how it is working, to compare with SQLite. In the case of SQLite, use JSON_EXTRACT instead. The format of the path is similar (although lax/strict mode is not applicable to SQLite; there are some other differences too). If the path refers to a null or number or string or boolean, then it will return the value directly; if a object or array, the result is the JSON representation. See the documentation of JSON1 extension for details.