topic Error in TextAreaGenerator if more than 1000 characters in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-in-textareagenerator-if-more-than-1000-characters/m-p/161006#M114960 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>i did a custom "LargeMultilingualTextAreaGenerator" based on MultilingualTextAreaGenerator with more rows and colums in order to allow user to type bigger text. This textarea is used in edit properties dialog.</SPAN><BR /><BR /><SPAN>If user type more than average 1000 characters i have error :</SPAN><BR /><PRE class="language-none line-numbers"><CODE>Could not execute JDBC batch update<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Im using an Oracle database and it seems that string_value in alf_attributes is limited to 1024 characters (attributes.hbm.xml). So i want to find a way to alert contributor that he is limited to 1000 characters.</SPAN><BR /><BR /><SPAN>What is easy way to do that ?</SPAN><BR /><SPAN>Can i configure that somewhere (in model ?, in web-client-config ?) ? Can i do easily a javascript ?</SPAN><BR /><SPAN>Have you any suggestion ?</SPAN><BR /><BR /><SPAN>Thanks in advance.</SPAN></BODY></HTML> Tue, 05 Feb 2008 10:57:00 GMT ribz33 2008-02-05T10:57:00Z Error in TextAreaGenerator if more than 1000 characters https://connect.hyland.com/t5/alfresco-archive/error-in-textareagenerator-if-more-than-1000-characters/m-p/161006#M114960 Hi,i did a custom "LargeMultilingualTextAreaGenerator" based on MultilingualTextAreaGenerator with more rows and colums in order to allow user to type bigger text. This textarea is used in edit properties dialog.If user type more than average 1000 characters i have error :Could not execute JDBC batc Tue, 05 Feb 2008 10:57:00 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-textareagenerator-if-more-than-1000-characters/m-p/161006#M114960 ribz33 2008-02-05T10:57:00Z Re: Error in TextAreaGenerator if more than 1000 characters https://connect.hyland.com/t5/alfresco-archive/error-in-textareagenerator-if-more-than-1000-characters/m-p/161007#M114961 <HTML><HEAD></HEAD><BODY><SPAN>The easiest way would be to use some client side JavaScript to alert or stop the user from entering more than 1000 chars.</SPAN><BR /><BR /><SPAN>There is a function in /scripts/validation.js called "validateStringLength" you could use this to check the string length as the user types i.e. attach an onkeyup handler.</SPAN><BR /><BR /><SPAN>Another option is to add a constraint to the property definition in the model, the client side validation should then be done for you, but this isn't the safest&nbsp; upgrade route if it's an Alfresco property!</SPAN></BODY></HTML> Tue, 05 Feb 2008 13:52:07 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-textareagenerator-if-more-than-1000-characters/m-p/161007#M114961 gavinc 2008-02-05T13:52:07Z