mysql error

org.hibernate.exception.SQLGrammarException: could not extract ResultSet"

Submitted by mehdimir on Mon, 10/08/2018 - 23:43

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

posgresql
like
#customquery #JPQL
mysql error

cannot configure the production environment (BonitaBPMCommunity-7.5.4)

Submitted by parvez_mys on Sun, 09/03/2017 - 23:05

bundle : BonitaBPMCommunity-7.5.4-wildfly-10.1.0.Final

[INFO] Starting PlatformSetupApplication on shariff-PC with PID 4384 (C:\BonitaB
PMCommunity-7.5.4-wildfly-10.1.0.Final\setup\lib\platform-setup-7.5.4.jar starte
d by shariff in C:\BonitaBPMCommunity-7.5.4-wildfly-10.1.0.Final\setup)
[DEBUG] Running with Spring Boot v1.3.2.RELEASE, Spring v4.3.7.RELEASE
[INFO] The following profiles are active: default
[INFO] configuration for Database vendor: mysql
[INFO] Started PlatformSetupApplication in 2.871 seconds (JVM running for 3.713)

configure the production environment
mysql error
org.apache.tomcat.jdbc.pool.ConnectionPool
Notifications