Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
From: Arun Sankar <arunsankar89@outlook.com>
To: "user@ofbiz.apache.org" <user@ofbiz.apache.org>
Subject: Re: Problem with description field
Thread-Topic: Problem with description field
Thread-Index: AQHSySX57zLHLI/DB0WbiJ2DNq0h4qHsz3yAgACp5EM=
Date: Wed, 10 May 2017 13:11:06 +0000
Message-ID: <KL1PR0201MB2183FAEF176AE8D588E364B2D1EC0@KL1PR0201MB2183.apcprd02.prod.outlook.com>
References: <NIEHIAPGFLPDLIACIOBOEEFJEBAA.skip@thedevers.org>,<CANAbSLzn96FsEWio3B_0Fce9mx1PzwrQzZxV+_XheikGhgpAKw@mail.gmail.com>
In-Reply-To: <CANAbSLzn96FsEWio3B_0Fce9mx1PzwrQzZxV+_XheikGhgpAKw@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-messagesentrepresentingtype: 1
x-tmn: [0e1nDMm+KRLAGtS56iII+tI4Stkd/w6K]
x-ms-publictraffictype: Email
x-microsoft-exchange-diagnostics: 1;SG2APC01HT199;5:MKxcCzP4fuUzvOMRyJfrm9k6u/y/U1jIQlcUSnvRotkMKPgFestpjs6MLNBvW1I0JodIlaz5qdHDENDFbafgGXsSmYYW2JmAt6u4g4k3r1mL2amIws/xnDyFYPbnVR2himBmjSUYBh1FuBkhxVzq5w==;24:2EHjucgy6IkQtaO8FwPWFYfa2g23yG4fH7SD+Wyx80aE4kxtxCdXbx9rEjSZlyFiGx7IRshuiYmxCYvWaAkxZGTuaLfE6IElLHJIJfPz+8I=;7:tzRzN9ZRGbDwG6+XFRpNTFwZ4L9op67APQ4lUVPG3bVZ/S4imCyvgpWdG34Np6KKYkdCAgHoe8MvY65p87vfNFBWl3WLW7U8s5wt3Bz0Ul6PD7A/3T4p9yihIbCIf38lj5U3dLo8jH53qiWpXbqe6LuOUWvygg4vNdz+vMPNNFMDimNU/M7IKbO9X7ffzRv5jz5BhQSKC50FBMdLgNbfgjBaoUKFM+7sSaodc7v/7/HDkQ9Q+NRpv31ddo6UQLv5ZQDO5cycDM2KKza2xxvdyrdUl3G/zTD0FsSL4qr35ddcz012v+rkdJ5uZew4tMv8
x-incomingheadercount: 45
x-eopattributedmessage: 0
x-forefront-antispam-report: EFV:NLI;SFV:NSPM;SFS:(7070007)(98901004);DIR:OUT;SFP:1901;SCL:1;SRVR:SG2APC01HT199;H:KL1PR0201MB2183.apcprd02.prod.outlook.com;FPR:;SPF:None;LANG:en;
x-ms-office365-filtering-correlation-id: 6c91e3cd-84ea-4e89-c512-08d497a604e1
x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001)(201702061074)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031324274)(2017031323274)(2017031322274)(1603101448)(1601125374)(1701031045);SRVR:SG2APC01HT199;
x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(444000031);SRVR:SG2APC01HT199;BCL:0;PCL:0;RULEID:;SRVR:SG2APC01HT199;
x-forefront-prvs: 03030B9493
spamdiagnosticoutput: 1:99
spamdiagnosticmetadata: NSPM
Content-Type: multipart/alternative;
	boundary="_000_KL1PR0201MB2183FAEF176AE8D588E364B2D1EC0KL1PR0201MB2183_"
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-originalarrivaltime: 10 May 2017 13:11:06.5300
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Internet
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SG2APC01HT199
archived-at: Wed, 10 May 2017 13:11:23 -0000

--_000_KL1PR0201MB2183FAEF176AE8D588E364B2D1EC0KL1PR0201MB2183_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi Skip,


Can you share the version of Postgres which you are using. I am using Postg=
res in my current project and have not experienced such an issue.


We use <field name=3D"description" type=3D"description"></field> on multipl=
e entities in ofbiz such as Product, InvoiceItem, Facility etc in Ofbiz.


Also I would suggest to create an Invoice and check the Description field o=
n the Invoice item. This would help to further understand whether this real=
ly is an issue with using the name description.


Regards,

Arun Sankar

________________________________
From: Paul Foxworthy <paul@cohsoft.com.au>
Sent: Wednesday, May 10, 2017 7:28:17 AM
To: user@ofbiz.apache.org
Subject: Re: Problem with description field

Hi Skip,

Try it with Derby instead of Postgres. Postgres handles large text
differently from other databases, arguably better. Maybe OFBiz isn't doing
the right thing for Postgres. What's the Postgres data type for the
description columns?

Cheers

Paul Foxworthy


On 10 May 2017 at 10:33, 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=3D"VendingMachinePack"
> ...
>         field name=3D"description" type=3D"description"
>         field name=3D"descAgain" type=3D"description"
> ...
>
> I write to the field like this:
>
> Map input =3D UtilMisc.toMap(...);
> input.put("description", description);
> input.put("descAgain", description);
>
> ...
> GenericValue newPack =3D delegator.makeValue("VendingMachinePack", input)=
;
> System.out.println("Have Pack =3D " + 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("Ha=
ve
> 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
>
>


--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Coherent Software - Custom software,web application and ...<http://www.cohe=
rentsoftware.com.au/>
www.coherentsoftware.com.au
Coherent Software Australia Making your business more productive. Coherent =
Software specialise in custom software for small and medium businesses.


Email: info@coherentsoftware.com.au

--_000_KL1PR0201MB2183FAEF176AE8D588E364B2D1EC0KL1PR0201MB2183_--