topic Error setting null for parameter #1 with JdbcType OTHER in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-setting-null-for-parameter-1-with-jdbctype-other/m-p/187759#M140889 <HTML><HEAD></HEAD><BODY><SPAN>I'm trying to create a new task on an complete event</SPAN><BR /><BR /><SPAN>&lt;activiti:taskListener event="complete" class="ec.eu.activiti.listener.UserListener"&gt;&lt;/activiti:taskListener&gt;</SPAN><BR /><BR /><SPAN>Java Code below :</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />ProcessEngine processEngine = ProcessEngines<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.getDefaultProcessEngine();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TaskService taskService = processEngine.getTaskService();&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy hh:mm:ss");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task task = taskService.newTask();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; task.setDescription("description 12131");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; task.setName("taskname 2121");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; task.setPriority(50);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; task.setAssignee("dataexpert2");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; task.setOwner("dataexpert2");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date dueDate;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dueDate = sdf.parse("01/05/2015 04:05:06");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;task.setDueDate(dueDate);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} catch (ParseException e1) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// TODO Auto-generated catch block<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;e1.printStackTrace();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;taskService.saveTask(task);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Error resulted :</SPAN><BR /><SPAN>&lt;blockcode&gt;</SPAN><BR /><SPAN>Caused by: org.activiti.engine.ActivitiException: Exception while invoking TaskListener: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/HistoricTaskInstance.xml</SPAN><BR /><SPAN>### The error may involve defaultParameterMap</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select * from ACT_HI_TASKINST where ID_ = ?</SPAN><BR /><SPAN>### Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.bpmn.helper.ClassDelegate.notify(ClassDelegate.java:109)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.delegate.TaskListenerInvocation.invoke(TaskListenerInvocation.java:34)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.delegate.DelegateInvocation.proceed(DelegateInvocation.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.delegate.DefaultDelegateInterceptor.handleInvocation(DefaultDelegateInterceptor.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.persistence.entity.TaskEntity.fireEvent(TaskEntity.java:723)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 61 more</SPAN><BR /><SPAN>Caused by: org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/HistoricTaskInstance.xml</SPAN><BR /><SPAN>### The error may involve defaultParameterMap</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select * from ACT_HI_TASKINST where ID_ = ?</SPAN><BR /><SPAN>### Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:457)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.history.DefaultHistoryManager.recordTaskDescriptionChange(DefaultHistoryManager.java:468)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.persistence.entity.TaskEntity.setDescription(TaskEntity.java:501)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at ec.eu.activiti.listener.UserListener.notify(UserListener.java:63)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.delegate.TaskListenerInvocation.invoke(TaskListenerInvocation.java:34)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.delegate.DelegateInvocation.proceed(DelegateInvocation.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.delegate.DefaultDelegateInterceptor.handleInvocation(DefaultDelegateInterceptor.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.bpmn.helper.ClassDelegate.notify(ClassDelegate.java:105)</SPAN><BR /><SPAN>&lt;/blockcode&gt;</SPAN></BODY></HTML> Tue, 19 May 2015 14:19:37 GMT gi00vani_kun 2015-05-19T14:19:37Z Error setting null for parameter #1 with JdbcType OTHER https://connect.hyland.com/t5/alfresco-archive/error-setting-null-for-parameter-1-with-jdbctype-other/m-p/187759#M140889 I'm trying to create a new task on an complete event&lt;activiti:taskListener event="complete" class="ec.eu.activiti.listener.UserListener"&gt;&lt;/activiti:taskListener&gt;Java Code below <IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />rocessEngine processEngine = ProcessEngines&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.getDefaultProcessEngine();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TaskService taskServi Tue, 19 May 2015 14:19:37 GMT https://connect.hyland.com/t5/alfresco-archive/error-setting-null-for-parameter-1-with-jdbctype-other/m-p/187759#M140889 gi00vani_kun 2015-05-19T14:19:37Z Re: Error setting null for parameter #1 with JdbcType OTHER https://connect.hyland.com/t5/alfresco-archive/error-setting-null-for-parameter-1-with-jdbctype-other/m-p/187760#M140890 <HTML><HEAD></HEAD><BODY><SPAN>I believe this is an Activiti Engine question can it be moved there ? I don't seem to have the rights or means to do it.</SPAN></BODY></HTML> Tue, 26 May 2015 08:58:09 GMT https://connect.hyland.com/t5/alfresco-archive/error-setting-null-for-parameter-1-with-jdbctype-other/m-p/187760#M140890 gi00vani_kun 2015-05-26T08:58:09Z