topic Re: FirstFoundationClient and Oracle in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32483#M16872 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>This is not the same issue, which referred to Oracle forcing empty strings to be null values.</SPAN><BR /><BR /><SPAN>I'm going to guess that you're using the MySQL dialect.&nbsp; You'll need to make use of overrides (</SPAN><STRONG>config/alfresco/extensions</STRONG><SPAN>) or similar to change the Hibernate dialect (see </SPAN><STRONG>config/alfresco/domain/hibernate-cfg.properties</STRONG><SPAN>).</SPAN><BR /><BR /><SPAN>MySQL autogenerates the ID, whereas Hibernate has to use a sequence when inserting into Oracle.</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Tue, 05 Sep 2006 14:06:50 GMT derek 2006-09-05T14:06:50Z FirstFoundationClient and Oracle https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32482#M16871 Hi all,I try to run the FirstFoundationClient from the SDK with an Oracle database but unfortunately I have a Oracle PK violation when trying to create the node . Here is the stack trace :- ORA-01400: cannot insert NULL into ("ALFRESCO"."NODE"."ID")Exception in thread "main" org.springframework.dao. Wed, 09 Aug 2006 10:46:29 GMT https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32482#M16871 pcuvecle 2006-08-09T10:46:29Z Re: FirstFoundationClient and Oracle https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32483#M16872 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>This is not the same issue, which referred to Oracle forcing empty strings to be null values.</SPAN><BR /><BR /><SPAN>I'm going to guess that you're using the MySQL dialect.&nbsp; You'll need to make use of overrides (</SPAN><STRONG>config/alfresco/extensions</STRONG><SPAN>) or similar to change the Hibernate dialect (see </SPAN><STRONG>config/alfresco/domain/hibernate-cfg.properties</STRONG><SPAN>).</SPAN><BR /><BR /><SPAN>MySQL autogenerates the ID, whereas Hibernate has to use a sequence when inserting into Oracle.</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Tue, 05 Sep 2006 14:06:50 GMT https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32483#M16872 derek 2006-09-05T14:06:50Z