I have been playing with Hibernate recently, and found more problems than I expected! Given @Entity public class Event { @Id @GeneratedValue Long id; @Column ...
As I work through the Whitepaper I see that the locking modes have become confused. Locking and Isolation is very complex in general. And to understand the...
Over the last few days I have been completely reworking the white paper. And as I do so, I review the code and design and test cases. It is all looking quite...
... nose ... Hi, I welcome this change; I am heavily using Oracle with SimpleOrm (storing and serving a few ten of thousands of biological results in an 900...
Hi Anthony, regarding Oracle, a good news is that one of our new client is demanding Oracle instead of Postgres. So I will have to test on both Oracle and ...
Hi, I think I second that. Until recently I never had any problems, but a few days ago, we had a deadlock detection under Postgresql after a code refactoring....
I have been tidying up the benchmarks, and I have installed and tested against Oracle 11g. The Netbeans profiling suggests that our main performance issue is ...
After much stuffing around the bug turned out to be under my nose. SDataSet.contains used to call map.containsValue instead of map.containsKey. So was doing...
Hi Anthony, I am in the process of porting my app to the latest SOrm. In several places, we used the SRecordMeta.select(joinStr, whereStr, orderStr) method to...
I have reworked the repository. Franck\simpleorm is now moved to truck. The old version is under branches, as is franck-presplit. Will create simpleorm\doc...
Hi, I have the case where I try to commitAndDetachDataSet(), but there is an error, say a duplicate primary key. Until now I was catching the exception and...
[Repost - didn't seem to make its way to the list ..?] Hi Anthony, I am in the process of porting my app to the latest SOrm. In several places, we used the...
Whoo, that sounds a bit scary... Makes me feel like Frankenstein's creature, Master :) So I took the opportunity to read the revised White Paper. I find it ...
Hello Franck, Hmm. Semi consistent DataSets could get tricky. In particular, each flush removes the record from the update list, one by one. So if you were...
Anthony & Melissa Ber...
berglas@...
Aug 10, 2008 2:06 am
1619
SQuery already has rawClause. But it should also have rawSql. And maybe other options. Add them if you like, but be sure to also include a test case. ...
Anthony & Melissa Ber...
berglas@...
Aug 10, 2008 9:14 am
1620
Hello Franck, Thanks for fixing the typo in the paper. Other contributions welcome. I'd actually prefer that you did not translate it into French. Certainly...
Hi, I think there is a hole with "records live only in SDataSet" when coming to generated primary keys: if we want to create a new record that has a generated...
Hello Franck, Not what I wanted to hear. The problem is actually deeper. In particular, if you generate keys when records are inserted into the database (as...
Hello Franck, I put several hours into this today, falling down one rat hole after another to get rollbackAndDetachDataSet to work. And then Abandoned it. The...
Anthony & Melissa Ber...
berglas@...
Aug 11, 2008 10:03 am
1624
Added SQuery.setRawSql, see query tests. Anthony ... Spreadsheet Detective, Southern Cross Software Queensland Pty Limited 54 Gerler Street Bardon, Queensland...
Anthony & Melissa Ber...
berglas@...
Aug 11, 2008 10:46 am
1625
Anthony, note I also added query.rawJoin(String sqlJoin) about one hour ago... I'll test both. Thanks Franck...
Hello Franck, Your join code failed on Oracle because DEPT_ID on the select list is ambiguous, which it is. I'm surprised that neither PostgreSQL nor HSQL...
Hello Franck, So you can now generate the key when reattached. Have a look at the test case. I have not integrated it with generators yet, but the key idea of...
Hello Franck, I have finished this work, so that you can now write SDataSet ds = new SDataSet(); Invoice invd1 = ds.createWithNullKey(Invoice.meta); ...
... Well, SValidatorEnumeratedValues only takes Strings values. SValidatorConstant can handle any object type (so integer, bigdecimal, boolean etc.) So we must...
Good point. So I've generalized SValidatorEnumeratedValues to take Objects, and removed SValidatorConstant. I'm putting it all together ready to ship. I'm ...
I just noticed that there is another project called "Simple ORM" (with a space). No relation to our SimpleORM. The author, Sap, has agreed to rename the...