[esb-issues] [JBoss JIRA] Commented: (JBESB-1435) Message longer than 255 chrs cannot be passed to jBPM

[ http://jira.jboss.com/jira/browse/JBESB-1435?page=comments#action_12394481 ] Tom Baeyens commented on JBESB-1435: ------------------------------------ to get the best possible db portability, we have to take into account all the restrictions of all the databases. we sometimes end up with these kinds of low values in the default configuration because we want to have the default schema generation to work on as many db's as possible out of the box. therefor it is usually desirable to optimize the default db schema that comes out of the generation for perticular dbs. we currently expect the users to do this themselves, since we don't have the manpower to maintain individual schema tweaks for all the dbs. i have used 2 lengths for strings in the schema generation. the default (255) and i have explicitely set it to 4000 for columns where longer texts can be expected. i think it might be opportune to update the length of the string variable column to 4000 as well. the motivation to limit the number of columns with length 4000 is that for some dbs (db2?) the default schema generation results fixed length disc space that is reserved for columns, resulting in huge row sizes. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira