Since you don't want to alter your DB, I guess the easier for you is to change fieldtypepostgres.xml Replace VARCHARby TEXT where needed. Beware though: TEXT is unlimited, should be ok most of the time
Jacques Le 12/01/2015 13:41, Anchit Jindal a écrit :
Hi All, I want to upgrade my old ofbiz with its latest version from trunk and also want to use my existing database(which is postgres) with latest ofbiz. For this i set my database name in entityengine.xml file. While running the ofbiz it gives error for table fields datatype mismatch e.g (Column [ATTR_VALUE] of table [public.CUST_REQUEST_ATTRIBUTE] of entity [CustRequestAttribute] is of type [text] in the database, but is defined as type [VARCHAR] in the entity definition.). Can any one tell me how to solve this type mismatch error for the fields except alter datatype of each table. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Upgrade-existing-postgres-database-with-latest-ofbiz-give-table-fields-mismatch-error-tp4661247.html Sent from the OFBiz - User mailing list archive at Nabble.com.
