Hi, I have enjoyed using SimpleORM for a day or 2 now. I do have a question (or wish-list) concerning the SimpleORMGenerator though. The problem I have is...
I had some old code that used this method and it seems to be of general value (and easier to use than parsing the String obtained from allFieldsString() --...
I ran into a problem with the generator utility -- when one has a table with multiple foreign key references to another table, the generated code was ...
Hi Joe Try this version. It should have fixed the problem with foreign keys. You may need to change some of the private fields in the apache classes to...
Hi, I ran into a problem running the IdentFKeysTest.java example using MySQL 4.0.14 as the DB. When trying to create the Foreign Keys, MySql requires that...
Eric B.
gcjos-SimpleORM@...
Oct 10, 2003 8:10 am
630
Hi, I'm brand new to SimpleORM and am slowly navigating my way through it. My requirements force me to use a backend DB as an MS Access DB - no choice in the...
Eric B.
gcjos-SimpleORM@...
Oct 10, 2003 8:23 am
631
Eric, Well, MSAccess doesn't support transactions (setCommit(false) giving me problems and SimpleORM appears to require it for good reasons) and is not very...
Philippe Back (High O...
phil@...
Oct 10, 2003 9:36 am
632
My sympathies Phil. In my experience, having any serious data in MS Access is a one way trip to disaster. The thing also to consider is that MSAccess doesnt...
Haven't played around with the Commit option yet, so don't have any more info about that, but I can say that I got the generator working. Only problem is that...
Eric B.
gcjos-SimpleORM@...
Oct 10, 2003 4:08 pm
634
Hi Richard, Your changes (after fixes below) did solve the FK problems better than my quick-and-dirty approach. I had to modify JdbcModelReader (attached) by...
Well, I use SimpleORM with SQLServer 2K and Sybase Anywhere and it works fine. But for this particular project, there is little hope that I will move a 140 ...
Philippe Back (High O...
phil@...
Oct 10, 2003 6:43 pm
636
Since a database table must have a primary key, I have modified the SimpleORMGenerator to check for this case and issue a warning if a table does not have a...
On the part of foreign keys I got to give it to access, its referential integrity is top notch and its visual design tool works like a charm. Foreign Keys are...
MSAccess horror story in a few words : Billing database, Multi-User context, database corruption, hell. 'nough said! As for simpleorm beeing suited to the...
Hi Lets try and get this issue sorted out. The DefaultFormatter is exactly that - a default implementation. There will always be cases where it will not work...
SimpleORM does not create indexes. The reason is that multiple fields can be in multiple indexes, so it gets quite complex. At the end of the day I figured...
Melissa & Anthony Ber...
berglas@...
Oct 13, 2003 1:56 am
641
OK, can add. Might just return sFieldMetas rather than copy it. Always a problem exposing data structures though. Anthony ... -- Spreadsheet Detective -...
Melissa & Anthony Ber...
berglas@...
Oct 13, 2003 1:56 am
642
Use SetEmpty, IsEmpty. These are named like this because in some databases "" is null, so this is an abstract layer, but it has never been implmented. ...
Melissa & Anthony Ber...
berglas@...
Oct 13, 2003 1:56 am
643
OK, can add. Not quite sure what the main uses are. ... -- Spreadsheet Detective - Southern Cross Software Queensland Pty Ltd. If the correctness test is that...
Melissa & Anthony Ber...
berglas@...
Oct 13, 2003 2:19 am
644
Anthony, My use was to do a dump(SRecordInstance) -- using SFieldMeta was in the previous version and made it easy. Here is my "generic" dump: private String...
As some of you know I am using SimpleORM with .NET . Might sound stupid but I am having a tougher time selling SimpleORM to the .NET world because of methods...
It does not appear that one can have multiple SConnections. I would, for instance, like to connect to two databases to move objects between them. This would be...
um, IsNull? This should probably be an IsEmpty version. And the value parameter is indeed redundant. Anthony ... -- Spreadsheet Detective - Southern Cross...
Melissa & Anthony Ber...
berglas@...
Oct 13, 2003 6:27 pm
648
Yes for basic fields but alas for me doesnt work with SFieldReference has shown by this code which is called by isNull . An exception is thrown if the passed...
Hi, If I have a DB that doesn't explicity declare foreign keys in its database structure, however, I know the relationships myself, do I gain anything by ...
Hi! Im totally new to this, - please forgive me if I ask silly questions! I am considering using SimpleORM in my application (mySQL-Tomcat-JSP- Struts), - here...
Why not do as following, so you will have your model for Struts: public class PersonDataObject { private person; public PersonDataObject(Person _person) { ...
Hi, thanks for the reply! Uhhmm... I dont quite see how that relates to the issue of storing Vectors into a relational db. Since I am not using SimpleORM (nor...
You need one class per table. If you want other "views" on that, you'll have to assemble them in another layer which will be using the SimpleORM classes. So 3...
Philippe Back (High O...
phil@...
Oct 15, 2003 7:58 pm
654
Hi Phillippe, thank you SO MUCH for your reply, that was nice of you! So you advice me to stick to a one object = one table structure. - Frankly this makes me...
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.
