Hello, I'm new to this forum and I started to evaluate sORM. I like the concept and started to experiment (however, I do not like everything, but everybody has...
Yep, like every other ORM (I think) SimpleORM only supports one Primary key. If you are using it for linking, you had better pick the surrogate key. You need...
Anthony & Melissa Ber...
berglas@...
Mar 3, 2004 9:52 am
798
Thanks for the reply, I was afraid that it was have implemented this way. Actually, the surrogates speed it up by around 80%-120%. Our natural keys can be up...
Hello Joseph, Thanks for the code, I'll look at it. The licence is actually less restrictive than GPL, see the licence.txt file. But we do appreciate...
Anthony & Melissa Ber...
berglas@...
Mar 25, 2004 11:00 am
800
I have the following data model: CREATE TABLE CS_ROLES( ROLE_ID NUMERIC(18,0) NOT NULL, NAME VARCHAR(10) NOT NULL, DESCRIPTION VARCHAR(50) NOT...
Hello Bartek, Your fix looks good from my initial read. I have added it to my list of things to do. Please always post these issues to the mailing list so...
Anthony & Melissa Ber...
berglas@...
Mar 28, 2004 6:57 am
802
Hello all, Sylvain in particular, after reading about SimpleORM I would now like to try it out. I am historically a Java person but for my project am now...
Alexander Banthien
alexander@...
Apr 3, 2004 10:14 am
803
Hi Alexander, First let me say that the transition from Java code to .NET code requires you to comment out ~4 places in the code else it will not work. This is...
Hi Sylvain, thanks for the support. Even before your reply I had managed to connect using the jdbc:odbc driver that comes with the .NET framework. (See code ...
Alexander Banthien
alexander@...
Apr 5, 2004 4:29 pm
805
We are using simpleorm in a 3 year/person project. We believe enough in our product that we invested over 100K in this library. Cheap cost was never a deciding...
Sorry, forgot to say the adojdbc bridge assembly is in the "files" section. Just add it to your references and use it like any JDBC drivers. ... enough ... ...
Sorry to keep on bugging you :-) 1) what do you mean by "files section"? where I should look for the adojdbc bridge code? can you point me to a place where I...
Alexander Banthien
alexander@...
Apr 7, 2004 2:24 pm
808
... No problem, I am happy to help. I have fallen deeply in love with this framework for its simplicity, its efficiency and its elegance. My only problem is...
Files section is on the files section of the yahoo group /Phil ... From: "Alexander Banthien" <alexander@...> To: <SimpleORM@yahoogroups.com> Sent:...
Philippe Back (High O...
phil@...
Apr 8, 2004 12:01 pm
810
Hi all, can anyone give me a hint on how to get around this: I am trying to imoplement my ORM-classes in C#. Everything looks quite similar and compiles fine...
C#, .NET ... thats my cue! ;-) this is a problem with .NET. You can not define constants in interfaces. When you want to use properties/constants, prefix them ...
Hi! I have a class 'User' with Multicolunm PK: 1. String 'UserID' 2. Refernce to a 'Company' object. A Simple class with a String-Field 'COMPANY_ID' as PK. ...
Florian Fankhauser
f.fankhauser@...
Apr 22, 2004 10:35 am
813
I have a client/server application where the GUI is running on a thick (Java) client. I would like to create an SRecordInstance object on the client-side based...
Bartek Muszynski
bartek_muszynski@...
Apr 22, 2004 10:42 pm
814
hmm... Rawclause is definitely an option but the only other way I see it is to fetch all users of this compagny and then to fetch all orders of all these...
We are doing some development with SimpleORM ourselves, and are bound to need this kind of 'join' capability. From our point of view, this is the biggest area...
Bartek Muszynski
bartek_muszynski@...
Apr 24, 2004 2:44 am
816
Thanks Sylvain. Simpleorm's query language is sql, so i prefer the rawclause. Florian...
Florian Fankhauser
f.fankhauser@...
Apr 26, 2004 10:48 am
817
I have a record which I want to change its primary key. How do I do this without deleting the record and inserting a new record with the modified primary key?...
The thing is... that's the point about SimpleORM. Do it with a raw clause. Forget about complex languages like JDO. In the end just fall back to SQL for...
I would do a raw update query. <moralizing>You do know this is a definite no no? Sometimes it is usefull for example when you update your database schema. Too...
You don't! Not using any ORM. The primary key defines the very identity of a record, and updating it would cause havoc. If you have a special need to do...
Anthony & Melissa Ber...
berglas@...
Apr 27, 2004 11:22 pm
821
Hi, I have read SimpleORM white paper, and seen that I have to maintain my own collection for child objects by hand. My presentation layer relies on this...
Bonjour Franck, Not sure if I understand you correctly but you want to get all objects that reference another row in a related table? If yes do it like this : ...
Bonjour, ... Quite true. But in fact I really want to get all objects that reference several rows in a related table (several parents and their respective ...
Hi Franck, I won't call myself experienced, but I think I can help: read inline comments ... no problems here ... to generate the "in-list" for the in (....)...
Again I want to make sure since I find this so simple that I might be missing something. Instead of your abstract names let me provide a more concrete scenario...