Hi Richard, I tried out your SimpleORMGenerate with postgresql, but it has issues. On closer inspection, after looking through the apache commons SQL library,...
Hi Nice to know that someone is trying to use it! I have never used Postgresql so can only make some guesses. Running the program - simplest is to change the...
Hi, this my first try with simpleorm (I use 1.11), and I can't attach() my SConnection. I am in a JBoss 3.2 environment, and the target rdbms is Postgres. So,...
Greetings, I want to create a one-to-many relationship using SimpleORM. For example, I'd like to bridge the following table structure to objects. I know that...
William R. Lorenz
wrl@...
Aug 8, 2003 4:27 pm
541
Hi, I'm not an expert at this, but I did a test with JBoss 3.2.1, session EJBs and Postgres 7.3.3 and it worked. I had the EJB configured for Bean managed...
Tina Tsui
ttsui@...
Aug 8, 2003 8:22 pm
542
Hi I had a similar discussion with Anthony when I first started playing with SimpleORM. I think what you have here is a many to many relationship in that it is...
Hello Franck, You should always provide a stack trace with a bug report. I'm guessing that the crash is in SConnectiobn.attach:- if...
Melissa & Anthony Ber...
berglas@...
Aug 11, 2003 1:13 am
544
I would have to disagree Richard. The way I see it this guy is trying to build a many to many relationship but is using an intersect table (AccountMap) to...
Oops forgot to add primary keys in AccountMap. The class should read like this : public class AccountMap extends SRecordInstance { public static SRecordMeta...
You have a point. Adding the correct index onto AccountMap could change the relationship from many-to-many to one-to-many. ... You have now defined the tables...
Messy? Not really... Would be more efficient in raw SQL but if you are serious about database product independance : SQuery q = AccountMap.meta.newQuery().eq ...
As for SQL, a very simple query does the trick, no need for join code. For that use Document.meta.select(whereClause, orderByClause). the whereClause should...
Dear Dr Anthony Berglas, I just downloaded the zip file for your simple orm. It seems that I found what I was looking for. I am an experienced database...
I just finished making ADemo test pass. I am using firebird with the latest all java JCA driver (jaybird). I had to change the following line of the interbase...
Dr. Berglas, Well I played with your software yesterday a little more. I like it even more now! It is amazing how little (but definitely non-trivial) code you...
Augustin et al: As a companion product to SimpleORM, you may want to consider the GUI Builder, Conga. It is a much less complex GUI builder than Swing and...
As long as we are in the department of shameless plugs... ;-) We also offer a .Net version of simpleorm if you are interested. You have clearly said that you...
Thanks for the offers about third party software, it is interesting to me to know about what's out there since I also advise my customers about existing...
Hi, I am doing a fat swing app (but I want the middle tier also to work in a distributed server environment). I've been looking for an easy to use, but...
Hello Agustin, Thank you for your enthusiastic support. SimpleORM maintains a separate cache for each connection. It then uses database locking or optimistic...
Melissa & Anthony Ber...
berglas@...
Aug 25, 2003 2:34 am
560
Hello Sylva, I did not realize that you had finished something. I'd be curious to have a look! What changes have you made... Regards, Anthony ... -- ...
Melissa & Anthony Ber...
berglas@...
Aug 25, 2003 2:41 am
561
There are ways to unpiggyback the connection, see SConnection. I just get sick of passing a connection object around. I have also seen many bugs caused by...
Melissa & Anthony Ber...
berglas@...
Aug 25, 2003 2:45 am
562
... Thank you for coming up with a useful product. ... This sounds good. In your white paper you specifically mention how careful you are with caching,...
Hi Augustin, ... Maybe http://www.javaworld.com/javaworld/jw-07-2000/jw-0721-hmvc.html serves as a starting point for your architecture. Regards, Michael...
Hello all, I have a similar problem and it is probably due, as Anthony said, to the setAutoCommit method call in the attach method. Previously I did not set...
Hello Sylvain, I am very interested to hear that you managed to get SimpleORM to run under .Net in J#. But can it talk to normal C# programs etc.? I...
Melissa & Anthony Ber...
berglas@...
Sep 1, 2003 7:03 am
566
Hello Marco, Thanks for this. I have yet to look at your code but from your description it looks like there may be problems if two different users (possibly...