ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Skip" <s...@thedevers.org>
Subject RE: Problem with description field
Date Wed, 10 May 2017 19:08:55 GMT
Thanks Jeremy

That was a typo.  It is actually description (lower case).  I also took the time to compare
the description fields in ReturnItem and VendingMachinePack in pgAdmin and they are identical
except for Position.

Also, because I can put data in this field using WebTools, I don't think the issue is in postgres.

I have written hundreds of custom services for ofbiz and millions of lines of java code. 
This particular service is different in one regard.

Usually, I write these kinds of services like this:

	add new or modified  records to a "toStore" iist

This one is different because I am modifying InventoryItem records in a loop like this

	get count of inventory items needed
	while count > 0
		get inventory item and reduce count by availabletopromise
		modify inventoryItem record and put in toStore
		create a VendingMachinePack and other entities and add to toStore

So, as you can see, there can be multiple delegator.storeAll() calls in a single transaction.
 However, I have spent three days testing this and I can pick a product where a single inventoryItem
exists that can fullfil the request and the results are the same.

Thanks again for thinking about this very strange issue.


-----Original Message-----
From: Jeremy Olmstead [mailto:jolmstead1@gmail.com]
Sent: Wednesday, May 10, 2017 11:00 AM
To: user@ofbiz.apache.org
Subject: Re: Problem with description field

This is a long shot but, in your statement below, description is spelled

Looking at the table with pgAdmin (I am using postgres), I find the field
DESCRITPTION as expected, but it is empty.

On Tue, May 9, 2017 at 7:33 PM, Skip <skip@thedevers.org> wrote:

> I have a problem with a field named "description".  The problem is that
> when
> I write to this field, it never ends up in the database.
> The entity definition looks like this:
>    <entity entity-name="VendingMachinePack"
> ...
>         field name="description" type="description"
>         field name="descAgain" type="description"
> ...
> I write to the field like this:
> Map input = UtilMisc.toMap(...);
> input.put("description", description);
> input.put("descAgain", description);
> ...
> GenericValue newPack = delegator.makeValue("VendingMachinePack", input);
> System.out.println("Have Pack = " + newPack);
> //newPack.create();
> toStore.add(newPack);
> System.out.println("Have description " + newPack.getString("
> description"));
> ....
> delegator.storeAll(toStore);
> My log file shows the correct description from the System.out.println("Have
> description " statement.
> However, looking at the table using WebTools, the description field is
> EMPTY!!!
> I added a second description field called "descAgain" and this shows up
> fine
> as well as all the other 20 fields in the table.  Just the description
> field
> is empty.
> There are dozens of uses of "description" as a field name.
> Looking at the table with pgAdmin (I am using postgres), I find the field
> DESCRITPTION as expected, but it is empty.
> I have tried deleting the table with pgAdmin and having it automatically
> recreated.  As can be seen above, I have tried calling newPack.create();
> instead of delegator.storeAll(toStore); as well as a bunch of other stuff.
> Nothing I have tried has any effect on "description" this field.
> My log file has no errors.
> Anyone have any ideas on what might be going on?
> Skip

View raw message