Sounds like you have not committed your transactions and are running on a MVC system such as Oracle or Daffodil. When you Select the rows you select their...
Anthony & Melissa Ber...
berglas@...
Jul 2, 2006 4:37 am
1410
Hello Martin, The naive SelectMAX approach has concurrency problems in a multi-user system -- it locks the entire table (or has race conditions). And most...
Anthony & Melissa Ber...
berglas@...
Jul 2, 2006 5:25 am
1411
Hello Darren, Thank you for doing this work. Your approach sounds generally good. I will not have time to look at in detail for a while, but others on the...
Anthony & Melissa Ber...
berglas@...
Jul 2, 2006 5:34 am
1412
Sorry to insist... in case you have both a "raw" id field (say SFieldString) and a SFieldReference for the same foreign identifying key, would you : - set...
To answer this I looked to see what simple orm does when you create a reference without creating the foreign key explicitly. In this case the foreign key is...
Thanks Brian for your clever answer. I will try the different scenario and look at the sql. I'll keep the list informed, I might even try to update the wiki...
Hi, while experimenting with SFieldReference, I realized that overlapping foreign key are not supported !! This is the most common case in my database, as I...
Hello Frank, Identifying foreign keys are certainly supported, have a look at Payrol.java/IdentFKeysTest. Overlapping ones are more obscure, and have semantic...
Anthony & Melissa Ber...
berglas@...
Jul 9, 2006 8:46 am
1417
Hi Anthony, I agree that Simpleorm sometimes tries to be too smart, in particular when expressing references : - Trying to recurse fields for references is...
Hello Frank, Suppose we have T(A, B, C, D) T.R (A, B) references X (A, B) T.S (A, C) references Y (A, C) (ie. there is a reference R in T that uses columns A...
Anthony & Melissa Ber...
berglas@...
Jul 15, 2006 4:59 am
1419
Hi Anthony, I see the difficulty with overlapping foreign keys, but then is another point : my overlapping keys are almost always part of my primary key. So...
Hi, has anybody produced anything resembling a sequence diagram of Simpleorm ? What I am looking for is a description (graphical or textual) of how simpleorm...
Yes. Demo version works for that as well. /Phil _____ From: SimpleORM@yahoogroups.com [mailto:SimpleORM@yahoogroups.com] On Behalf Of Franck Routier Sent:...
I'd just like to point out, again (I emailed about this back in january, got a reply that it was fixed, and wrote back when I checked and it was not), that the...
So, what's your point ? If you are not okay with this, either improve the situation or else. The source code is available and great, which is enough for my...
Well the first step to improving any situation is recognizing that it could use improvement. I think my point was clear. It's a pity that some people have to...
I started a wiki space for simpleorm a while ago and frankly, there was not that much activity there. So, please add some pages and let's move forward. I am...
You seem to be saying that because there are more important issues to be attended to (in your opinion) it's invalid for me to even raise this (less important)...
I should also point out that the disarray of SimpleORM's web presence also relates to the lack of traffic on your wiki. There is no link to it from the yahoo...
I'm going to have to side with Mr blackbrook on this one. The project is a bit scatterbrained. For example the web page is on Sourceforge, the email list is...
Hi, I agree the project would benefit from more visibility and community activity. Just to be true, don't forget Philippe has set up the wiki on its own ...
Hello All, The various web sites are indeed a legacy. The current source is up on Sourceforge/subversion. The mailing list is on Yahoo, and I am not inclined...
Anthony & Melissa Ber...
berglas@...
Jul 19, 2006 11:29 am
1433
There is a class diagram in the java docs covering most of the classes, and another that explains how the complex SReferenceFields are related. No plans for...
Anthony & Melissa Ber...
berglas@...
Jul 19, 2006 12:06 pm
1434
Primary keys should be immutable, you should get an exception if you try to set one. (Please feel free to check.) It would indeed be possible to add more...
Anthony & Melissa Ber...
berglas@...
Jul 19, 2006 12:13 pm
1435
One nice thing about moving the web site to sourceforge is that you can give out access to someone who is willing to update the pages. The web site itself...
Hi Anthony, ... Yes, I have seen it since my mail. I even think that they are immutable _once the record is attached_, but not when detached (well, this is a ...
Hi, I made this schema to show what happens when you 'getReference'. Any comment is welcome, as I'm neither an UML expert (so it's more 'UML like' than 'real...
Thanks Frank for doing this. Better documentation is good. Personally I think that a Class diagram is useful because they form a network. But for control...