Exception on Oracle: Illegal character ((CTRL-CHAR, code 0)): only regular white space (\r, \n, \t) is allowed between tokens
Issue Symptoms
When updating or launching the iObeya application, you get the following error in the logs:
org.hibernate.HibernateException: com.fasterxml.jackson.core.JsonParseException: Illegal character ((CTRL-CHAR, code 0)): only regular white space (\r, \n, \t) is allowed between tokens
Solution
This is a JDBC driver issue. Your driver version may no longer be compatible with the Java version you have installed. You need to update your JDBC connector to a new driver version. At least ojdbc8.jar for Java 8 and ojbc11.jar for Java 11.
- Stop Tomcat
- If you are using Java 8 download the ojdbc8.jar connector. if you are using Java 11 download the ojdbc11.jar connector (https://www.oracle.com/fr/database/technologies/appdev/jdbc-downloads.html)
- Remove the ojdbc7.jar connector from the tomcat libraries
- Add the new version of the connector to the Tomcat libraries
- Start Tomcat
Support
If you require assistance to resolve the problem, please ask for support. (See Requesting Support)