Thanks Adrian, This seems the best way in a production environment I guess. This is the kind of good ideas we may put in a cookbook in the Wiki.
I just created one http://docs.ofbiz.org/pages/createpage.action?spaceKey=OFBIZ&fromPageId=146 Actually this page is intended to be the root of cookbooks. Because I know that the OpenSource Strategy team wants to open its cookbooks to community. This could be the place to begin... Thus the community may extend this cookbooks. BTW I will drop and recreate not clever but easier in my case, less manipulations ;o) Jacques > Seems to me you could do the following: > > 1. Export the table to xml > 2. Drop the table > 3. Start OFBiz - table recreated with new structure > 4. Import xml data from #1 > > > Jacques Le Roux wrote: > > > Was a breeze with pgAdminIII. Now it's another story for Derby. I installed > > Eclipse Derby's plugins (nice but no UI), connected to > > the DB with ij without problem but did not succed in changing field type. > > > > I found this http://best-practice-software-engineering.blogspot.com/2006/09/tech-derbys-next-round.html#comment-8980636160782036513 > > > > I can't believe it :(. So in such cases the easier is to drop the DB and > > recreate it, that's it ? Of course this is not a production > > environment. > > > > Thanks > > > > Jacques > > > > > > > >>Yes ! > >> > >>Thanks Chris, did not figured that out. > >> > >>Jacques > >> > >> > >>> Jacques, since the field type of > >>>CarrierShipmentBoxType.packagingTypeCode was changed from very-short to > >>>id in r504996, you may need to alter the SQL type of that column in your > >>>database, if it hasn't happened automatically. > >>> > >>> Chris > >>> > >>> > >>>Jacques Le Roux wrote: > >>> > >>>>Si, > >>>> > >>>>I cant see any changes (commits) for DemoShipping.xm since this commit. > >>>>So logically the problem remains. > >>>> > >>>>Jacques > >>>> > >>>>----- Original Message ----- > >>>>From: "Si Chen" <[EMAIL PROTECTED]> > >>>>To: <[email protected]> > >>>>Sent: Friday, February 09, 2007 6:26 PM > >>>>Subject: Re: svn commit: r504996 [1/2] - in /ofbiz/trunk/applications: > >>>>ecommerce/data/ product/ product/config/ > >> > >>product/entitydef/ > >> > >>>>product/servicedef/ product/src/org/ofbiz/shipment/thirdparty/fedex/ > >>>>product/templates/ product/templates/shipment/ > >>>>product/webapp/fac > >>>> > >>>> > >>>> > >>>> > >>>>>Jacques Le Roux wrote: > >>>>> > >>>>> > >>>>>>I did not want to send it because some parts are in french, here we go : > >>>>>> > >>>>>> [java] 2007-02-09 10:33:11,593 (main) [ > >>>>>> GenericDelegator.java:577:ERROR] > >>>>>> [java] ---- exception report > >>>>>> ---------------------------------------------------------- > >>>>>> [java] Failure in create operation for entity > >>>>>> [CarrierShipmentBoxType]: org.ofbiz.entity.GenericEntityException: > >> > >>Exception > >> > >>>>>>while inserting the following entity: > >>>>>>[GenericEntity:CarrierShipmentBoxType][cre > >>>>>>atedStamp,2007-02-09 > >>>>>>10:33:11.546(java.sql.Timestamp)][createdTxStamp,2007-02-09 > >>>>>>10:33:11.109(java.sql.Timestamp)][lastUpdatedStamp,2007-02-09 > > > > 10:33:11.546(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-09 > > > >>1 > >> > >>>>>> > > 0:33:11.109(java.sql.Timestamp)][packagingTypeCode,FEDEXENVELOPE(java.lang.String)][partyId,FEDEX(java.lang.String)][shipmentBoxType > > > >>>>>>Id,FXENV(java.lang.String)] (while inserting: > >>>>>>[GenericEntity:CarrierShipment > >>>>>>BoxType][createdStamp,2007-02-09 > >>>>>>10:33:11.546(java.sql.Timestamp)][createdTxStamp,2007-02-09 > >>>>>>10:33:11.109(java.sql.Timestamp)][lastUpdatedStamp,2007-02-09 > >>>>>>10:33:11.546(java.sql.Timestamp)][lastUpdatedTxStamp, > >>>>>>2007-02-09 > >>>>>> > >>>>>> > >>>> > > 10:33:11.109(java.sql.Timestamp)][packagingTypeCode,FEDEXENVELOPE(java.lang.String)][partyId,FEDEX(java.lang.String)][shipmentBoxTyp > > > >>>>>>eId,FXENV(java.lang.String)] (SQL Exception while executing the f > >>>>>>ollowing:INSERT INTO OFBIZ.CARRIER_SHIPMENT_BOX_TYPE > >>>>>>(SHIPMENT_BOX_TYPE_ID, PARTY_ID, PACKAGING_TYPE_CODE, OVERSIZE_CODE, > >>>>>>LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > >>>>>>CREATED_TX_STAMP) VALUES (?, > >>>>>> ?, ?, ?, ?, ?, ?, ?) ($$$Une erreur de troncature a t dtecte lors de > >>>>>> la tentative de rduction de VARCHAR 'FEDEXENVELOPE' > > > > une > > > >>>>>>longueur de 10.))). Rolling back transaction. > >>>>>> [java] Exception: org.ofbiz.entity.GenericEntityException > >>>>>> [java] Message: Exception while inserting the following entity: > >>>>>> > >>>> > >>>>[GenericEntity:CarrierShipmentBoxType][createdStamp,2007-02-09 > >>>> > >>>> > >>>>>>10:33:11.546(java.sql.Timestamp)][createdTxStamp,2007-02-09 > >>>>>>10:33:11.109(jav > >>>>>>a.sql.Timestamp)][lastUpdatedStamp,2007-02-09 > >>>>>>10:33:11.546(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-09 > >>>>>>10:33:11.109(java.sql.Timestamp)][packagingTypeCode,FEDEXENVELOPE(java.lang.String)][partyId,FEDEX > >>>>>>(java.lang.String)][shipmentBoxTypeId,FXENV(java.lang.String)] (while > >>>>>>inserting: > >>>>>>[GenericEntity:CarrierShipmentBoxType][createdStamp,2007-02-09 > >>>>>>10:33:11.546(java.sql.Timestamp)][createdTxStamp,2007-02-09 > >> > >>10:3 > >> > >>>>>>3:11.109(java.sql.Timestamp)][lastUpdatedStamp,2007-02-09 > >>>>>>10:33:11.546(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-09 > >>>>>>10:33:11.109(java.sql.Timestamp)][packagingTypeCode,FEDEXENVELOPE(java.lang.String)][p > >>>>>>artyId,FEDEX(java.lang.String)][shipmentBoxTypeId,FXENV(java.lang.String)] > >>>>>> (SQL Exception while executing the > > > > following:INSERT > > > >>>>INTO > >>>> > >>>> > >>>>>>OFBIZ.CARRIER_SHIPMENT_BOX_TYPE (SHIPMENT_BOX_TYPE_ID, PARTY_ID, > >>>>>>PACKAGING_T > >>>>>>YPE_CODE, OVERSIZE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > >>>>>>CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, > > > > ?, > > > >>>>?, ?) > >>>> > >>>> > >>>>>>($$$Une erreur de troncature a t dtecte lors de la tentative de rducti > >>>>>>on de VARCHAR 'FEDEXENVELOPE' une longueur de 10.))) > >>>>>> [java] ---- stack trace > >>>>>> --------------------------------------------------------------- > >>>>>> > >>>>>>Did you try to load data ? > >>>>>> > >>>>>>Jacques > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>>What is the actual error you're getting? > >>>>>>> > >>>>>>>-David > >>>>>>> > >>>>>>> > >>>>>>>On Feb 9, 2007, at 8:19 AM, Jacques Le Roux wrote: > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>>Si, > >>>>>>>> > >>>>>>>>I found a problem while loading demoshipping data : > >>>>>>>>'FEDEXENVELOPE' seems too long or something > >>>>>>>> > >>>>>>>>Jacques > >>>>>>>> > >>>>>>>>----- Original Message ----- > >>>>>>>>From: <[EMAIL PROTECTED]> > >>>>>>>>To: <[email protected]> > >>>>>>>>Sent: Thursday, February 08, 2007 7:41 PM > >>>>>>>>Subject: svn commit: r504996 [1/2] - in /ofbiz/trunk/applications: > >>>>>>>>ecommerce/data/ product/ product/config/ product/entitydef/ > >>>>>>>>product/servicedef/ product/src/org/ofbiz/shipment/thirdparty/ > >>>>>>>>fedex/ product/templates/ product/templates/shipment/ > >>>>>>>>product/webapp/fac... > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>>>Author: sichen > >>>>>>>>>Date: Thu Feb 8 10:41:20 2007 > >>>>>>>>>New Revision: 504996 > >>>>>>>>> > >>>>>>>>>URL: http://svn.apache.org/viewvc?view=rev&rev=504996 > >>>>>>>>>Log: > >>>>>>>>>Support for FedEx subscription and ship requests via FedEx Ship > >>>>>>>>>Manager Direct API > >>>>>>>>> > >>>>>>>>>Added: > >>>>>>>>> ofbiz/trunk/applications/product/servicedef/ > >>>>>>>>>services_shipment_fedex.xml (with props) > >>>>>>>>> ofbiz/trunk/applications/product/src/org/ofbiz/shipment/ > >>>>>>>>>thirdparty/fedex/ > >>>>>>>>> ofbiz/trunk/applications/product/src/org/ofbiz/shipment/ > >>>>>>>>>thirdparty/fedex/FedexServices.java (with props) > >>>>>>>>> ofbiz/trunk/applications/product/templates/ > >>>>>>>>> ofbiz/trunk/applications/product/templates/shipment/ > >>>>>>>>> ofbiz/trunk/applications/product/templates/shipment/ > >>>>>>>>>FedexShipRequestTemplate.xml (with props) > >>>>>>>>> ofbiz/trunk/applications/product/templates/shipment/ > >>>>>>>>>FedexSubscriptionRequestTemplate.xml (with props) > >>>>>>>>>Modified: > >>>>>>>>> ofbiz/trunk/applications/ecommerce/data/DemoShipping.xml > >>>>>>>>> ofbiz/trunk/applications/product/config/ > >>>>>>>>>ProductUiLabels.properties > >>>>>>>>> ofbiz/trunk/applications/product/config/shipment.properties > >>>>>>>>> ofbiz/trunk/applications/product/entitydef/ > >>>>>>>>>entitymodel_shipment.xml > >>>>>>>>> ofbiz/trunk/applications/product/ofbiz-component.xml > >>>>>>>>> ofbiz/trunk/applications/product/webapp/facility/WEB-INF/ > >>>>>>>>>controller.xml > >>>>>>>>> ofbiz/trunk/applications/product/webapp/facility/shipment/ > >>>>>>>>>EditShipmentPackages.ftl > >>>>>>>>> ofbiz/trunk/applications/product/webapp/facility/shipment/ > >>>>>>>>>EditShipmentRouteSegments.ftl > >>>>>>>>> > >>>>>>>>>Modified: ofbiz/trunk/applications/ecommerce/data/DemoShipping.xml > >>>>>>>>>URL: > >>>>>>>>> > >>>>>>>>> > >>>>>>>> > >>>>>>>>http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/ > >>>>>>>>data/DemoShipping.xml?view=diff&rev=504996&r1=504995&r2=504996 > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>> > >>>>>Can you try it now? It's been changed to "id" which is a longer field > >>>>>now. > >>>>> > >>>>>Si > >>>>> > >>>>> > >>>> > >>>> > > > >
