Hi BJ, We're still in development, so I was hoping to continue to use Derby for the time being.
And yes, I did check the Derby docs - but as I mentioned below, I can't find anyplace where OFBiz changes the default size for CLOB. I'll keep digging... thanks, -mike On 3/2/10 12:06 AM, "BJ Freeman" <bjf...@free-man.net> wrote: > derby should not be used for production system. > you might try the Derby docs on apache > http://db.apache.org/derby/docs/ > > ========================= > BJ Freeman > http://bjfreeman.elance.com > Strategic Power Office with Suppilier Automation > <http://www.businessesnetwork.com/automation/viewforum.php?f=93> > Specialtymarket.com <http://www.specialtymarket.com/> > > Systems Integrator-- Glad to Assist > > Chat Y! messenger: bjfr33man > Linkedin > <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab > _pro> > > > Mike Voytovich sent the following on 3/1/2010 9:43 PM: >> Hi, >> >> I¹m attempting to use the UPS shipment code in OFBiz to generate shipping >> labels. Note that we¹re still using the default Derby database. >> >> OFBiz is able to send the confirm/accept requests and receive the responses, >> but an error is returned from UPS in handleUpsShipmentAcceptResponse - ³The >> XML document is not well formed². >> >> It turns out that we¹re properly receiving a 20,000 byte ³ShipmentDigest² >> from UPS in the handleUpsShipmentConfirmResponse method; but it looks like >> this is being truncated to exactly 8K when written out to the >> ShipmentRouteSegment entity. i.e., the ShipmentDigest data is correct in / >> ofbiz/work/ofbiz/upscert/UpsShipmentConfirmResponse log file; but is 8K (with >> the remainder padded with "�") in the UpsShipmentAcceptRequest log file. >> >> The trackingDigest field-type is ³very-long² with a SQL type of ³CLOB², so I >> would expect it to save ~20K without issue. >> >> Has anyone else run into this type of problem? Is there something that needs >> to be configured in Derby to allow large entity fields? I did find some >> documentation on Derby for setting the CLOB size, but I don¹t see anywhere in >> OFBiz where this is done. >> >> thanks, >> -mike >> > >
