Computers/IT : Testing/Quality-Asurance Team Lead Testing - 3 to 10 years of experience - Okhla - Delhi Client of ALP HR Services - Freshers & Experianced ...
Hi all, in a recent project we are attempting to make use of triggers to increment snapshot ids (kept in separate tables), which will save CPU cycles when ...
Alex B
alex4b@...
Aug 16, 2007 7:13 pm
1533
Hello Alex, The point about the result test is simply that when we are updating by primary key we should only update at most one record because the primary key...
Anthony & Melissa Ber...
berglas@...
Aug 17, 2007 12:52 am
1534
Hi, I'm just starting to use SimpleORM and I think it will work for me. One thing, though, is that although much of my work is with MySQL, SQL Server, or...
SimpleORM uses pretty standard SQL, and the drivers that customize it for databases are fairly straight forward to adapt. But have not tried Access. Anthony ...
Anthony & Melissa Ber...
berglas@...
Nov 21, 2007 1:33 am
1536
I have a need to copy a record in a database, and then modify the original and the copy. I make a new record using ParcelORM newOne = (ParcelORM)...
SimpleORM seems to work fine with Microsoft Access via JDBC:ODBC if you manually set the driver to SQLServer. Should this be added to the documentation? ...
Looks good to me. Best to avoid detaching. Note how easy it was to write the copying code. Sorry for not responding earlier, I missed it. Anthony ... EMail:...
Anthony & Melissa Ber...
berglas@...
Dec 16, 2007 4:18 am
1539
Hi, I am considering making detaching the records from the connection the default behaviour, instead of destroying them, when committing/closing the...
Simply that accessing records after a commit is probably a bug. Updates to the records will not be reflected in the database. So the symptoms could be...
Anthony & Melissa Ber...
berglas@...
Feb 3, 2008 9:49 am
1541
Hi Anthony, in my app, I tend to always detach records, to display and update them in the presentation layer. I also detach them to handle business rules in...
I like your idea of a detach all records method. It also avoids the issues of partial detachment, where children are detached but not parents. Anthony ... ...
Anthony & Melissa Ber...
berglas@...
Feb 4, 2008 11:03 am
1543
Ok, so I went on and added a SConnection.detachDataSet() static method to SConnection. Beware, SConnection.commit(), SConnection.detachAndClose(), ... still ...
Hi, just a note to tell I have updated simpleorm in the 'franck' branch to (hopefully) better handle offset and limit options. What I have done is : 1) add a...
Hi, I use SimpleOrm quite a lot, and I have this annoyance that "" is not treated as NULL when it should be. In Oracle (and also Informix and maybe others), ""...
Your approach sounds reasonable. There is an isEmpty test in SField. Anthony ... Spreadsheet Detective, Southern Cross Software Queensland Pty Limited 54...
Anthony & Melissa Ber...
berglas@...
Apr 14, 2008 3:30 am
1547
Frank Routier has been working on a new version on a branch in subversion. It is looking very good. Simpler in many ways, cleaned up. After a long hiatus...
Frank, Please check carefully what I have done to SFieldReference.innerRawSetFieldValue and SFieldScalar.innerRawSetFieldValue. I think it is now correct, but...
Hello Franck, I think that as part of 3.0 we should consider splitting SimpleOrm into two pieces, each in their own Jars. simpleorm.records that contains...
Hello Frank, Moving SQuery out is possible. One would have to store the built query as a structure rather than a query string, and then translate to string in...
Anthony & Melissa Ber...
berglas@...
Jun 30, 2008 10:45 am
1551
Anthony, maybe we should consider introducing SDataSet (or SDataSetManager ?) right now. First it would be equivalent to SConnection's transaction cache and ...
Hello Franck, Hmm. The design gets ever more ambitious. I am concerned that if we take on too much we will not finish. But it would be good to get this...
Hi Anthony, that seems fine to me, except for one point that is not that clear :) shouldn't "myDS.create(new Employee().set(Employee.ID, "123").set.....);"...
Anthony, I've done some work, namely steps 1 to 6, execpt for the 'flush before query part'. Lot of thinks are now public, including some fields. Bad. Also...
Hello Franck, Wow, you have been busy. I agree that we need to be careful about our vocabulary, I had been a bit sloppy. SCon."attach/detach" had referred to ...
Hello Anthony, I agree with everything you say here. Regarding naming, maybe we should consider JPA terminology ? Then Session would be EntityManager. And...
Hi, ok, I really like SSession.newSessionAndAssociateWithCurrentThreadAndOpenJdbcConnection(), which really says what it does..... :) I agree with the fact...
Anthony, I was wondering, why must have so many static methods in SSession, that most of the time end up finding the current scon in threadlocal, instead of...
Hello Franck To keep it simple, the semantics of attaching a data set to a session could be exactly the same as attaching each record in it, one by one. As ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
