Hello Jorge, Thanks for this. It seems that MSSQL (in the way that you are using it) obtains exclusive locks by default. Odd but OK. Regards, Anthony -- ...
Melissa & Anthony Ber...
berglas@...
Mar 3, 2003 4:06 am
320
Hello Eric, Thanks for taking the trouble to respond, and I wish you luck with LiDo. The JDO approach certainly has more OO Buddah nature than SimpleORM. But...
Melissa & Anthony Ber...
berglas@...
Mar 3, 2003 4:06 am
321
Hello Julian, SimpleORM says nothing about obtaining a JDBC connection. I suggest that you write a small method to get the connection and SConnection.attach...
Melissa & Anthony Ber...
berglas@...
Mar 3, 2003 4:11 am
322
Hi, For pools in tomcat, use the following for the new data source implementation based on DBCP. This was a bit more tricky, basically linked to the fact that...
phil@...
Mar 3, 2003 8:45 am
323
Hi Anthony, thanks for your fast response!! I will try to implement your design advice in my code. DynaActionForm seems a good option to implement this...
I am getting crazy about a very simple test over my example test DB: CREATE TABLE WF_TIPOTAREA( ID_TIPOTAREA INTEGER NOT NULL, NOMBRE VARCHAR(40) NULL, ...
I had a bad declaration for meta field in DBEstado... copy-paste matters!!! ... ID_TIPOTAREA=5, ... Optimistic ... DBTipoTarea.ID_TIPOTAREA] ... Existing ... ...
Hi Anthony, seems like SRecordInstance.optimisticFieldMetas() misses to include the PK fields. We loaded the record with SQY_OPTIMISTIC. Then we detached it....
Hello Eric, Any progress on this? I suggest that you keep it simple and just propose what you need now rather than try to solve all problems. Anthony ... -- ...
Melissa Berglas
berglas@...
Mar 9, 2003 11:45 pm
328
Hello Michael, Good points. Corrected routine is ArrayList optimisticFieldMetas() { SRecordMeta meta = getMeta(); ArrayList res = new...
Melissa Berglas
berglas@...
Mar 9, 2003 11:45 pm
329
Hello Frank, Fixed, problem was casting Long to Integer, and then the keys were not equal(). Update below. Anthony public SRecordInstance...
Melissa Berglas
berglas@...
Mar 9, 2003 11:46 pm
330
... Many thanks. I'm liking SimpleORM more and more as I use it. -- Frank Carver frank@... http://www.efsol.com/...
Hi there, I am working in the SRecordInstance classes design, this is the pseudocode for my design: Table_A: ID_A + REF_B (PK) REF_C Table_C: ID_C + REF_B (PK)...
Unfortunatly Its more of a time issue then anything else. I havn't had time to work on it in the last little bit. I hope to have time again soon though, sorry...
Hello, I'm working with an existing database where the design did not use the "equal name asumption", i.e. that FK fields have the same name as the referenced...
This is also my case in one situation... Connecting to existing schemas is quite tricky at times... what is the best strategy ? /Phil ... From:...
phil@...
Mar 11, 2003 8:46 am
336
Have a look at Payroll.java for examples of how to override the name (and other properties) of referenced fields. Anthony ... schemas is ... FieldReferen ... ...
Hello Julian, You can almost do it. You can get direct access to the columns that make up a primary key, see payroll.java for an example. Using this approach...
Melissa Berglas
berglas@...
Mar 11, 2003 11:23 pm
338
Hello Anthony, I prefer to manage myself the relation, in fact is what I did. My relational model is quite complex, I use nearly 30 tables with composed keys,...
Hi, I have a problem deleting records... if I use deleteRecord on a record that has references in its primary keys, and those references have been used (I...
Hello Julian, I cannot reproduce it. Below is my IdentFKeysTest, with an extra payrollUpdate method added to try. Please edit this test case until you can...
Melissa & Anthony Ber...
berglas@...
Mar 16, 2003 11:00 pm
341
OK, I have the simplest testcase that shows the bug... it has only two tables (tableA and tableB). I ommit the code to create the database. Regards, Julian ...
Hello Guenter, Yes, Default Value is missing -- defaults currently just null. But for your DDL issue you can use the SEXTRA_COLUMN | TABLE_DDL property to add...
Melissa & Anthony Ber...
berglas@...
Mar 19, 2003 5:02 am
343
Hi, In SDriver.java, methods deleteSQL & updateSQL calls whereSQL to form the where clause. whereSQL issues "IS NULL" or "SCOLUMN_NAME = ?" depending on a...
Hello Julian, I extended IdentFKeysTest with similar code, bug not reproduced. I have made a few other changes, so may have indirectly fixed it anyway. Wait...
Melissa & Anthony Ber...
berglas@...
Mar 24, 2003 2:21 am
345
Another maintenance release. Minor bugs with generated keys and optimistic locking. Upgrade advised and safe. As always visit ...
Melissa & Anthony Ber...
berglas@...
Mar 24, 2003 2:21 am
346
Hello Gregory, Yep, you did a good job. Those SQL NULL semantics are a real pain and completely wrong. But you missed the next release of the Detective by a...
Melissa & Anthony Ber...
berglas@...
Mar 24, 2003 2:46 am
347
Hi Melissa / Anthony , ... wrote ... ISSUE : hsqldb database inappropriate for testing. At stage 2, a preliminary test case looks like this, in...
Hi Anthony, As requested, ... See attached, includes whereNullTest() in LongTransactionTest. As noted earlier, test is not foolproof against hsql. SDriver and...
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.
