No subject

value in the second example.

Now I would agree that these ARE different:
INSERT INTO some_table (field1, field2) VALUES("", "test");
INSERT INTO some_table (field2) VALUES("test");

An empty value is not the same as a null value, but two nulls will always be
two nulls. I can see your problem if you are passing an empty string to the
service, since that will not be treated as a null.

If I am wrong let me know.

-Andy

> -----Original Message-----
> From: ofbiz-devel-admin at lists.sourceforge.net
> [mailto:ofbiz-devel-admin at lists.sourceforge.net]On Behalf Of Adam Heath
> Sent: Wednesday, January 22, 2003 12:57 PM
> To: Andy Zeneski
> Cc: David E Jones; ofbiz-devel at lists.sourceforge.net
> Subject: RE: [OFBiz-Devel]PostalAddress,
> commonapp/src/org/ofbiz/commonapp/party/contact/ContactMechServices.java
>
>
> On Wed, 22 Jan 2003, Andy Zeneski wrote:
>
> > What are you talking about? The service definition is correct,
> it is using
> > the right location and invoke for the create/update postalAddress
> > service(s). The definitions look file and DO include the
> stateProvinceGeoId
> > parameter. The event (which uses the map processor) seems to be fine as
> > well. So, I have no idea what you are talking about.
>
> The problem is that said parameter is optional in the service
> definition, but
> the java code copies it anyways, even if it doesn't exist in the
> input map.
>
> A key not existing in an entity is different than existing in the
> entity with
> a null value.  It's the latter condition that is causing the
> database to fail
> with the error.
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Scholarships for Techies!
> Can't afford IT training? All 2003 ictp students receive scholarships.
> Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more.
> www.ictp.com/training/sourceforge.asp
> _______________________________________________
> OFBiz-Devel mailing list
> OFBiz-Devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ofbiz-devel
>