Is JSON_VALUE function of Microsoft SQL Server can be supported by H2 database?

26 views
Skip to first unread message

kalahasthi satyanarayana

unread,
Mar 22, 2020, 1:14:17 PM3/22/20
to H2 Database
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
Reply all
Reply to author
Forward
0 new messages