PostgreSQL usage #11
Description
After connection of JDeSurvey to the PostgreSQL database I still have issues with two tables. It's global_settings and velocity_templates. After I imported data, seeing the such errors in log:
For global_settings:
DEBUG 2018-10-16 13:42:04,834 [http-bio-8080-exec-3] (org.apache.tiles.impl.BasicTilesContainer:615) [render] - Render request recieved for definition 'settings/globalSettings/show' DEBUG 2018-10-16 13:42:04,843 [http-bio-8080-exec-3] (com.atomikos.diagnostics.Slf4jConsole:88) [println] - getCompositeTransaction() returning NULL! DEBUG 2018-10-16 13:42:04,843 [http-bio-8080-exec-3] (com.atomikos.diagnostics.Slf4jConsole:88) [println] - getCompositeTransaction() returning NULL! DEBUG 2018-10-16 13:42:04,852 [http-bio-8080-exec-3] (org.apache.tiles.impl.BasicTilesContainer:615) [render] - Render request recieved for definition 'uncaughtException'
For velocity_template:
Caused by: org.postgresql.util.PSQLException: Bad value for type long : <html><body><h2>Invitation</h2><p>Hi ${full_name};</p><p>You have been invited to participate in the folllowing survey:<br />Survey: ${survey_name}<br /><br />To participate please click on the following link:</p><p>${survey_link}</p></body></html> at org.postgresql.jdbc.PgResultSet.toLong(PgResultSet.java:2869) at org.postgresql.jdbc.PgResultSet.getLong(PgResultSet.java:2093) at org.postgresql.jdbc.PgResultSet.getClob(PgResultSet.java:459) at org.postgresql.jdbc.PgResultSet.getClob(PgResultSet.java:445) at org.apache.commons.dbcp.DelegatingResultSet.getClob(DelegatingResultSet.java:568) at org.apache.commons.dbcp.DelegatingResultSet.getClob(DelegatingResultSet.java:568) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104) ... 122 more ERROR 2018-10-16 13:35:30,559 [http-bio-8080-exec-10] (com.jd.survey.web.settings.SurveyDefinitionController:1198) [handleRuntimeException] - java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.DataException: Bad value for type long : <html><body><h2>Invitation</h2><p>Hi ${full_name};</p><p>You have been invited to participate in the folllowing survey:<br />Survey: ${survey_name}<br /><br />To participate please click on the following link:</p><p>${survey_link}</p></body></html>
Does somebody faced with this issue? Trying to resolve it.