I just got simpleorm building and running with derby, and ran into some tests that failed. I figured this was somewhat normal, although I couldn't determine...
Hello All, Apologies for the spam, I have been away. The group is now set so that new members need to be authorized. If someone else would like to do this...
Anthony & Melissa Ber...
berglas@...
Feb 21, 2007 6:53 am
1518
I am not aware of anyone using Derby. If you need to change the driver then please post the changed driver here when you are done. It should be fairly easy. ...
Help, I have a table with the following definition: CREATE TABLE USER_ROLES ( USER_NAME VARCHAR(20) NOT NULL, ROLE_ID INTEGER NOT NULL ); PRIMARY KEY...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the SimpleORM group. File :...
SimpleORM@yahoogroups...
Mar 14, 2007 3:33 am
1521
Hi, sure, it is the very purpose of SFieldReference. you should just add the following fields to you UserRole class : public static final SFieldReference ROLE...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the SimpleORM group. File :...
SimpleORM@yahoogroups...
Mar 14, 2007 5:46 pm
1523
Hi, Thanks for the reply. Thats what I tried first, but I get a "Duplicate Column Name" error for ROLE_ID and USER_NAME. The problem is their are only two...
John, Please include the code that is causing you the issue in a message. But first look at the Employee/Department example. Note that Employee just...
Hello! What is the best way to count records in a table with SimpleORM? Using the aggregate count-function most RDBMS have or another way? What is the best way...
Guenter Wildmann
a8909020@...
Mar 29, 2007 4:21 pm
1526
Direct SQL, all in one query, evaluated on the server. (Could actually be two queries with little overhead in this case.) It will be a bit of a query though....
Hello Anthony, ... Ok, so it is best to use a direct SQL query, thank you. ... As i would like to keep the 500 newest records the query-part will look like...
Guenter Wildmann
a8909020@...
Apr 4, 2007 8:53 am
1528
Hi I have to adopt our Web and Applet based Measurement Management Systen to new security measurements beeing right now established. As a consequence system...
Christoph Hintermueller
christoph.hintermuell...
Apr 10, 2007 7:58 am
1529
There is an example of detaching and serialization in the examples. Just uses java serialization. Be aware that if you are using applets outside the firewall...
Hi Anthony ... I've to admit till now i managed to not be required to use java for all my developments (+). Thus do you know asside from the examples, good...
Christoph Hintermueller
christoph.hintermuell...
Apr 11, 2007 9:21 am
1531
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...
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.
