Hi, Thanks for the hint about using Prototypes, it is really useful.


That brought to my mine a questing that is a little out of the topic.

If you have an attribute prototyped as currencyAmount the precision is set to 38 and the scale to 4. The Data Type suggested is java.math.BigDecimal. How are you guys controlling that the BigDecimal in your java class does not have a value whit a scale superior of 4 before saving the editing context to avoid an exception?

We are currently solving this just rounding the value before saving, or in the validation method to ensure the scale is not superior that the value defined in modeler. But one of the great things of prototyping is that if for some reason I want to change the scale to 5 instead 4, all the attribute definition's that are using that prototype will be updated, what about the BigDecimal?

Maybe I am wrong on thinking that I should be sure that the scale of my BigDecimal must be less than or equals to the scale defined in the modeler to avoid exception on saving.

How do you guys handle this?





On Jul 7, 2009, at 2:42 PM, Johann Werner wrote:


Am 07.07.2009 um 21:09 schrieb Scott M. Neal:


On Jun 30, 2009, at 5:43 PM, David Avendasora wrote:


On Jun 30, 2009, at 8:29 PM, Scott M. Neal wrote:

Well, if you're looking for excuses to "upgrade" things, maybe transition to using Prototypes. I'm sure the Postgress Prototypes in Wonder's ERPrototypes will all have the proper External Types. :-)

        Wow, thank you Dave, that DOES make things substantially easier
(and less prone to error--sure enough, had a missing external type in
one of the entities).  All this modern fanciness, still getting used
to it...

        Now my question is, for the Postgresql prototypes, which one
is recommended to use for primary keys?  Googling reveals some people
using long (called longNumber in prototypes), which is what I historically used, while others are using varchar (but not consistent regarding size:
10? 100? 10,000,000?  :-))

Why don't you just choose the most obvious prototype: 'id'? Life can be so easy ;-)

jw



                        Thank you,

                                Scott


Otherwise, you should be able to just select one entity at a time and click the SQL button and see which one(s) generate the error. I see pretty clear error messages with this, that say exactly what external type is not recognized.

Dave

Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com

This email sent to [email protected]




_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/miguel%40toracom.net

This email sent to [email protected]



_______________________________
Ing. Miguel Angel Torres Avila
Director General
Tel: +52 (33) 3367 1892
Cel: +52 (33) 3106 8758
E-mail: [email protected]
www.toracom.net




 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to