Changing database to MYSQL instead of using postgresql

[iyliaa]

Hi anyone can help? I cannot access my Jasper server login page after change database from postgresql to mysql.

Tomcat 9.0 

Jasper server 7.8 

Jave jre 1.8.0

MySQL 8.0

2022-03-24T15:04:47,188 ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-7:116 - There was an error on the server. Try again or contact site administrators. (Error UID: d78b7430-0cbc-4929-9ef4-50a4f2caeb11)
2022-03-24T18:42:53,983 ERROR SqlExceptionHelper,main:131 - (conn=19) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ilike 'organizations'' at line 1
2022-03-24T18:42:54,030 ERROR ContextLoader,main:350 - Context initialization failed org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

[vchiem]

A SQL syntax that have worked in Postgres may not necessary work in MySQL.  A lot depends on what was actually done in changing the database type to see whether it is the correct approach. A clean install of JRS 7.8 into MySQL repository db followed by a js-export of everything from the Postgres repository and js-import into the MySQL repository may be worth considering.  Certified versions of Tomcat, database, OS needs to be checked against the Supported Platforms guide. 

 

[iyliaa]

Hi,

 

Its okay because it resolve already. I manage to manually installed Jasper server using WAR file. Thanks!