Is JSON_VALUE function of Microsoft SQL Server can be supported by H2 database?
Error Logs :- 2020-03-22 21:25:34.847 WARN [,,,] 10088 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 90022, SQLState: 90022 2020-03-22 21:25:34.848 ERROR [,,,] 10088 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : Function "JSON_VALUE" not found; SQL statement: select invoiceent0_.id as id1_0_, invoiceent0_.invoice_created_date as invoice_2_0_, invoiceent0_.invoice_json as invoice_3_0_, invoiceent0_.invoice_number as invoice_4_0_, invoiceent0_.invoice_status as invoice_5_0_, invoiceent0_.invoice_updated_date as invoice_6_0_, invoiceent0_.last_updated_by as last_upd7_0_ from invoice invoiceent0_ where JSON_VALUE(invoiceent0_.invoice_json, '$.invoiceNumber')=? [90022-200] javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/19e1cbf2-ce7d-41d2-ad3f-dc31224af5cc%40googlegroups.com.
