posgresql

Hello all,

I'm asking about the possibility of using Bonita Community version 2023.1 and postgresSQL database version 14.

THANKS;

hi
I have used the likes as follows in JPQL query

SELECT c
FROM CarProperties c
WHERE
(c.pDateTime = :pDateTime or :pDateTime is NULL)
and (c.driverName like '%'||:driverName||'%' or :driverName is NULL) 
ORDER BY c.persistenceId ASC

this work in BonitaStudioTomcat and H2 DB
But dont work in Tomcat bundle and PostgreSQL and raise Error :
org.bonitasoft.engine.commons.exceptions.SRetryableException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet