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: <dev@ofbiz.apache.org> > > > 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: <commits@ofbiz.apache.org> > > >>>>> 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 > > >> > > >> > > > > > > > >