What would be really helpful is to have the "long" version of the 5 table definitions for the IdentFKeysTest example. The "long" version would explicitly...
Trying my own suggestion, I tried to modify Employee.java to have explicit references. Here is what I tried, but it throws an exception in SFieldReference at...
I think that should be static final SFieldReference fkfldDeptId = new SFieldReference( meta, Department.meta, new SFieldMeta[]{DEPT_ID }, new SPropertyValue[] ...
Nope -- DEPT_ID is in Department.java. Supposedly, this is the remote name but then it is really redundant since we have already defined the remote table in...
The field in Employee is called DEPARTMENT. So isn't it then static final SFieldReference fkfldDeptId = new SFieldReference( meta, Department.meta, new...
Why do you need anything in the property value field. From what I have seen in the javaDoc ORM will match the array of local keys you supply against the...
But what if the key names do not match (as they do not in this case)? For example, the recursive reference for a MANAGER being an EMPEE_ID requires that you...
The first local key is mapped to the first primary field of the foreign key table, the second local key matches the 2nd primary key, etc. In our example the...
Here is a version that mostly works. I tried to round-trip the IdentFKeys.java example: 1. Run IdentFKeys (this will leave the tables in the database) 2. Run...
OK, appologies for not responding sooner but I have (and am) very busy at the moment. I still have not had time to run your code, but hopefully the following...
Melissa & Anthony Ber...
berglas@...
May 4, 2003 3:13 am
415
Hello Joe, Looks good. Please recognize the common case where there are <= two properties. ie. all that is needed is:- ... More importantly, please try to...
Melissa & Anthony Ber...
berglas@...
May 4, 2003 3:26 am
416
Hi Anthony I have also been hacking away trying to produce a Quick Start solution and have attached the code that my program produces. Like Joe I have...
Hi Anthony, In looking over the apache.sql stuff, I see that they already handle dropping constraints before dropping the table. Perhaps the easiest approach ...
... handle ... easiest approach ... already has ... I'll have a look at it, might be good. But as you know I prefer to avoid dependencies. ... needed in ... ...
Hello Richard, I've had a quick look at your generated code and it looks OK. I'll try to investigate further on the weekend. One quick thing that you could...
... handle ... easiest approach ... already has ... Forgive my ignorance, but what exactly to you mean by "the apache.sql stuff". Is it part of some other...
As I noted in my main program, you can download the org.apache.commons.sql from their CVS (the other ibiblio sources did not seem current) using: cvs -d...
I wish we could coordinate our effects but different people have different styles. Joe tends to use a single large class while I break everything up into lots...
Hello Richard and Joe, ... different styles. When working on shared projects one has to tollerate different styles. As long as it is not awful and is well...
Hi Anthony Here is my latest and greatest for the Quick Start development. I have included the output code for the test database in simpleorm.dbtest.br and...
Hello My question is: How can i change debug level of simpleorm dinamicaly. Not recompiling the simpleorm classes? i found that level is specified in SLog...
HEllo, what I personnaly do is to have a value in a propertie file (or a db) and set it on run time (SLog.level = X; where X is got by reading the prop file, ...
From TraceUte.java String traceLevel = System.getProperty("trace.level"); if (traceLevel != null && !traceLevel.equals("")) SLog.slog.level =...
Melissa & AnthonyBerg...
berglas@...
May 17, 2003 8:14 pm
428
Hello Richard, Looks good. I like the way you handle Employee.Department as a single reference. This is the common case I was worried about. If you were...
Melissa & AnthonyBerg...
berglas@...
May 18, 2003 5:21 pm
429
Hello Alix, You're not easy to forget :). The current version is the one on the web site. But before you proceed please have a look and a think and write up a...
Melissa & AnthonyBerg...
berglas@...
May 18, 2003 5:21 pm
430
Hi Your comment "If you were realy clever you would also realize that MANAGER_ is used as a prefix" is rather pointless as there is no standard way of naming...
Given the definition of Employee as follows. public class Employee extends SRecordInstance implements java.io.Serializable { public static final SRecordMeta...
Hello Richard, I'll have a look your issues in detail next week. I agree that it is proabably not worthwhile recognizing MANAGER_ as a prefix, I think that is...