On Sep 2, 2011, at 12:35 AM, David Avendasora wrote:
> Hi all,
>
> This is one for posterity. AKA: When I'm an idiot in the future.
>
> I was having a problem with a WODisplayGroup that would have the right number of objects in the selectedObjects Array, but they were all instances of the same EO.
>
> Easy, you say; there's something wrong with the item setter on the WORepetition. Not so fast. It the setter was fine. The SQL that was being used to fetch the data was right too.
>
> The model was wrong. The PK in the FrontBase DB was a LONGINT, but the PK in the EOModel had an external type of INT. The value stored in the DB field was not too long for an INT and an ALTER TABLE statement changed it without issue. Apparently there something about the process in the JDBC driver or EOF that chokes on it turning a Long into an Integer, but not enough to throw an exception, but enough to make all the values the same, in a non-deterministic way. If I quit and relaunched the app, it would likely repeat a different instance, but not always.
>
> Dave _______________________________________________
Was this in a Wonder app or a vanilla WO app? One thing that has occurred to me in the past is that there can be some model validation on application launch. If this problem was logged out from the app, would that have helped.
I know one thing that always gets me in the fact that WOLips will reverse engineer an INT in a MySQL database into a Long. Also, there are bad things that people do in inheritance situations and bad things that people do while setting up certain relationships and we could just say that this is going to be bad.
A class that would wait for applicationDidLaunch and then check the loaded models could go into ERExtensions. It could start small, people can add rules for the databases they know, and it could just advise on problems and otherwise stay out of the way. Unless this is already done somehow via a name I am not recognizing. Anyone know?
cheers - ray
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
