Only that I have to support all public attributes. Could you please go through the API and give me a list of things that should be made public? Thanks, Anthony...
Melissa & Anthony Ber...
berglas@...
Nov 3, 2003 5:28 pm
691
Hello Robert, You are using IN in the SQL sense which is fine. But EJBQL uses it to navigate from parents to children which is a mess. For JDO, any class that...
Melissa & Anthony Ber...
berglas@...
Nov 3, 2003 5:28 pm
692
Extra documentation would be most welcome. Perhaps as short articles about specific topics. Let us know how you go with your application. Regards, Anthony ......
Melissa & Anthony Ber...
berglas@...
Nov 3, 2003 5:28 pm
693
Oops. It actually appears to work but I agree that it is nasty. Probably prefer approach #2 as more efficient. Anthony ... -- Spreadsheet Detective - Southern...
Melissa & Anthony Ber...
berglas@...
Nov 3, 2003 5:28 pm
694
Hi All, I just started using SimpleORM library after an extensive search for the best O/R philosophy. Congrats to Anthony for this wonderfull tool. I am trying...
Pierre, Aye! That's the rub! As best as I can figure, the only hope you have is to run each database instance in a separate thread or sequentially access the...
You encapuslate both transactions in an outer transaction. All participants vote. If participant vote = 100% operationally successful, then the outer object...
Hi, Someone said that you cant use multiple database connection. Havent done a lot of simultaneous connection recently but you could just detach the connection...
Hi, Thanks already for the fast responses. Given my inexperience with SimpleORM, is it possible to get some sample code or at least some instructions as to...
Hmmm - interesting concept encapsulating transactions like that. But given that each transaction is based on a seperate SConnection, and that only 1...
Hi Sylvain! ... Do you mean, that you add a subquery as raw clause? If so, is there an other way, since i have to use MySQL 3, which doesn't support...
Florian Fankhauser
f.fankhauser@...
Nov 9, 2003 12:48 pm
701
Hi, Just to clarify a point. Transactions are not a SimpleORM feature. Rather SimpleORM relays your instruction to the database provider. What this entails is...
hi, Working in SQL directly wont work then in MYSQL because : 1) You cant modify the FROM part of the query in SIMPLEORM, 2) You cant do subquery in MYSQL3...
Will take me some time to figure them all out... :) Will likely find more as I continue to program with SimpleORM. Right now, it's the one that I've found...
Thanks! This means to me, MYSQL 3 is not first choice for use with SimpleORM. Florian...
Florian Fankhauser
f.fankhauser@...
Nov 11, 2003 8:49 pm
705
... I'll get some flak for saying this but MySQL3 is not a very good choice of database. It's not even SQL92 compliant. Use MySQL4 which support more features...
You already have it. There are a few classes such as SArray which you have to move some comments. I do not have a solution file made, but that should be...
Melissa & Anthony Ber...
berglas@...
Nov 12, 2003 7:29 pm
707
This is a myth, there is no two phase commit protocol that really works. There is always an unfortunate gap. This is an old problem with the red army on two...
Melissa & Anthony Ber...
berglas@...
Nov 12, 2003 7:29 pm
708
Hello all, I just "discovered" SimpleORM and I'm investigating it's suitability for a number of projects, so forgive me for the newbie questions. Reading...
Luis Neves
lneves@...
Nov 12, 2003 7:47 pm
709
Thanks Anthony for your help and response. What you suggest make sense. My problem is that I am bounded by requirement so I will have to do things and hope for...
As Anthony said the code for the java version and the .net version is the same. The only thing to do is move comments in 4 places and voila you have a .net...
Nothing prevents you from using sql in parallel. Raw "execute" type of sql can be submited through rawUpdateSQL... if you want. Views can be accessed easily...
Anyone ever tried to "cascade delete" in simpleorm? Do you modify your database sql? Do you enforce it manually? Can simpleorm add this constraint when you do...
The cleanest way to do it so far was adding the following to the field properties : SSimpleORMProperties.SEXTRA_COLUMN_DDL.pvalue("ON DELETE CASCADE") 2 things...
This is what happens when you shoot some untested code. This wont work. I have come to the conclusion that you must update SDriver.foreignKeysSQL and add ON...
Hello All, I'm a little wary of ON DELETE CASCADE (and ON UPDATE CASCADE). The first problem is that support from different databases is fairly patchy. I like...
Melissa & Anthony Ber...
berglas@...
Nov 24, 2003 2:00 am
716
Responses below, but please address such questions to the mailing list. ... No, you have to explicitly do a FindOrCreate, which by default gets a FOR UPDATE....
Melissa & Anthony Ber...
berglas@...
Nov 24, 2003 2:00 am
717
Jonathan, ... I'll add the following: 1. Allows for direct access to JDBC connection so you customize freely within the SimpleORM transaction (only caveat...
Tina Tsui
ttsui@...
Nov 24, 2003 5:12 am
718
Your point is valid. Still... Cascade deletes in "software"(i.e. SimpleORM handles it) must be much more inneficient than in "hardware" (i.e. on the database...
Comments below ... Actually I would not think that there is much in it. The big issue is the extra round trip to the server if batching is not used. The rows...
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.
