topic Problem with DB2 Support in 5.4 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-with-db2-support-in-5-4/m-p/49725#M28727 <HTML><HEAD></HEAD><BODY><SPAN>Hey all !</SPAN><BR /><BR /><SPAN>when running </SPAN><PRE class="language-none line-numbers"><CODE>ant db.create<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I got the following Error:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>&nbsp;&nbsp;&nbsp;&nbsp; [java] org.activiti.engine.ActivitiException: couldn't deduct database type from database product name 'DB2/LINUXZ64'<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDatabaseType(ProcessEngineConfigurationImpl.java:432)<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDataSource(ProcessEngineConfigurationImpl.java:390)<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:259)<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:236)<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.ProcessEngines.buildProcessEngine(ProcessEngines.java:177)<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.ProcessEngines.initProcessEnginFromResource(ProcessEngines.java:150)<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:88)<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.java:207)<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEngines.java:200)<BR />&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSchemaUpdate.main(DbSchemaUpdate.java:34)<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></CODE></PRE><BR /><SPAN>I think you should add this database type to the databaseTypeMappings here: </SPAN><A href="http://svn.codehaus.org/activiti/activiti/trunk/modules/activiti-engine/src/main/java/org/activiti/engine/impl/cfg/ProcessEngineConfigurationImpl.java" rel="nofollow noopener noreferrer">http://svn.codehaus.org/activiti/activiti/trunk/modules/activiti-engine/src/main/java/org/activiti/engine/impl/cfg/ProcessEngineConfigurationImpl.java</A><BR /><BR /><SPAN>Anyway, after some hacking, I got it to work.</SPAN><BR /><SPAN>But I think I have found a bug here:</SPAN><BR /><A href="http://svn.codehaus.org/activiti/activiti/trunk/modules/activiti-engine/src/main/resources/org/activiti/db/create/activiti.db2.create.identity.sql" rel="nofollow noopener noreferrer">http://svn.codehaus.org/activiti/activiti/trunk/modules/activiti-engine/src/main/resources/org/activiti/db/create/activiti.db2.create.identity.sql</A><BR /><BR /><SPAN>where it says:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>create table ACT_ID_INFO (<BR />&nbsp;&nbsp;&nbsp; ID_ varchar(64),<BR />&nbsp;&nbsp;&nbsp; REV_ integer,<BR />&nbsp;&nbsp;&nbsp; USER_ID_ varchar(64),<BR />&nbsp;&nbsp;&nbsp; TYPE_ varchar(64),<BR />&nbsp;&nbsp;&nbsp; KEY_ varchar(255),<BR />&nbsp;&nbsp;&nbsp; VALUE_ varchar(255),<BR />&nbsp;&nbsp;&nbsp; PASSWORD_ BLOB,<BR />&nbsp;&nbsp;&nbsp; PARENT_ID_ varchar(255),<BR />&nbsp;&nbsp;&nbsp; primary key (ID_)<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></CODE></PRE><BR /><SPAN>You should declare the column ID_ with NOT NULL, because DB2 cannot have a column in the primary key, where null values are allowed. See also </SPAN><A href="http://www.google.com/search?q=SQL0542N" rel="nofollow noopener noreferrer">http://www.google.com/search?q=SQL0542N</A><BR /><BR /><SPAN>Greets, and keep up the good work !</SPAN><BR /><SPAN>Saatsch</SPAN></BODY></HTML> Fri, 08 Apr 2011 17:17:24 GMT saatsch 2011-04-08T17:17:24Z Problem with DB2 Support in 5.4 https://connect.hyland.com/t5/alfresco-archive/problem-with-db2-support-in-5-4/m-p/49725#M28727 Hey all !when running ant db.create‍I got the following Error:&nbsp;&nbsp;&nbsp;&nbsp; [java] org.activiti.engine.ActivitiException: couldn't deduct database type from database product name 'DB2/LINUXZ64'&nbsp;&nbsp;&nbsp;&nbsp; [java]&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDatabaseType(ProcessEngineConfigu Fri, 08 Apr 2011 17:17:24 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-db2-support-in-5-4/m-p/49725#M28727 saatsch 2011-04-08T17:17:24Z Re: Problem with DB2 Support in 5.4 https://connect.hyland.com/t5/alfresco-archive/problem-with-db2-support-in-5-4/m-p/49726#M28728 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for the pointer, will fix the NOT NULL on trunk and add the mapping!</SPAN></BODY></HTML> Mon, 11 Apr 2011 07:16:04 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-db2-support-in-5-4/m-p/49726#M28728 frederikherema1 2011-04-11T07:16:04Z