RE : RE : How to map optional 1:1 relationship

2003-10-15 Thread Emmanuel Dupont
value has been set. > > Isn't it ? > > > > -Message d'origine- > De : Jakob Braeuchi [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 15 octobre 2003 14:22 > À : OJB Users List > Objet : Re: How to map optional 1:1 relationship > > hi olli, carl,

Re: Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Jakob Braeuchi
euchi [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 4:50 PM To: OJB Users List Subject: Re: Antwort: RE: How to map optional 1:1 relationship hi gerhard, sorry, i posted to wrong code. this is it: protected void associateBatched(Collection owners, Collection chi

Antwort: [Fwd: Re: Antwort: RE: How to map optional 1:1 relationship]

2003-10-15 Thread Gerhard . Grosse
Hi Jakob, Yes, your patch did the trick! No more selects with id = null. Thanks! Gerhard Jakob Braeuchi <[EMAIL PROTECTED]> 15.10.2003 17:56 An: [EMAIL PROTECTED] Kopie: Thema: [Fwd: Re: Antwort: RE: How to map optional 1:1 relationship] - Nac

RE: Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Boyes, Carl
Hi Jakob, I have implemented your code and it works wonderfully! Many thanks, Carl. -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 4:50 PM To: OJB Users List Subject: Re: Antwort: RE: How to map optional 1:1 relationship hi

Re: Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Jakob Braeuchi
17:17 Bitte antworten an "OJB Users List" An: OJB Users List <[EMAIL PROTECTED]> Kopie: Thema: Re: Antwort: RE: How to map optional 1:1 relationship hi carl,gerhard, your right, fkValues may be null and thus a query will be fired. can you confirm this g

Re: Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Jakob Braeuchi
An: OJB Users List <[EMAIL PROTECTED]> Kopie: Thema: Re: Antwort: RE: How to map optional 1:1 relationship hi carl,gerhard, your right, fkValues may be null and thus a query will be fired. can you confirm this gerhard ? jakob Boyes, Carl wrote: Hi Jakob, Gerh

Re: Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Gerhard . Grosse
sNull(fkValues) so #associateBatched should probably do the same. Gerhard Jakob Braeuchi <[EMAIL PROTECTED]> 15.10.2003 17:17 Bitte antworten an "OJB Users List" An: OJB Users List <[EMAIL PROTECTED]> Kopie: Thema: Re: Antwort: RE: How to ma

Re: Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Jakob Braeuchi
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 3:59 PM To: OJB Users List Subject: Re: Antwort: RE: How to map optional 1:1 relationship Hi Jakob, I just checked and you are right. Nevertheless I find a lot of statements like SELECT ... FROM

RE: Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Boyes, Carl
: Antwort: RE: How to map optional 1:1 relationship Hi Jakob, I just checked and you are right. Nevertheless I find a lot of statements like SELECT ... FROM ... WHERE id='' in my P6Spy logs, where id is a not nullable primary key. I was assuming these were generated from resolving refer

Re: Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Gerhard . Grosse
ull are > currently generated also when using non-primitives such as Integer. It > would be nice if this could be avoided. > > Regards, > Gerhard > > > > > > [EMAIL PROTECTED] > 15.10.2003 13:24 > Bitte antworten an "OJB Users List" &

Re: Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Jakob Braeuchi
ards, Gerhard [EMAIL PROTECTED] 15.10.2003 13:24 Bitte antworten an "OJB Users List" An: [EMAIL PROTECTED] Kopie: Thema: RE: How to map optional 1:1 relationship Hello, -Original Message- From: Boyes, Carl [mailto:[EMAIL PROTECTED] I'v

RE : RE : RE : How to map optional 1:1 relationship

2003-10-15 Thread Emmanuel Dupont
IL PROTECTED] Envoyé : mercredi 15 octobre 2003 14:51 À : [EMAIL PROTECTED] Objet : RE: RE : How to map optional 1:1 relationship Hello, > -Original Message- > From: Emmanuel Dupont [mailto:[EMAIL PROTECTED] > > No '' should be done. > > Sample : > > INSERT

Antwort: RE: How to map optional 1:1 relationship

2003-10-15 Thread Gerhard . Grosse
ECTED] 15.10.2003 13:24 Bitte antworten an "OJB Users List" An: [EMAIL PROTECTED] Kopie: Thema: RE: How to map optional 1:1 relationship Hello, > -Original Message- > From: Boyes, Carl [mailto:[EMAIL PROTECTED] > I've currently >

RE : RE : How to map optional 1:1 relationship

2003-10-15 Thread Emmanuel Dupont
i 15 octobre 2003 14:51 À : [EMAIL PROTECTED] Objet : RE: RE : How to map optional 1:1 relationship Hello, > -Original Message- > From: Emmanuel Dupont [mailto:[EMAIL PROTECTED] > > No '' should be done. > > Sample : > > INSERT INTO A (Apk, Bfk) VALUES (

RE: RE : How to map optional 1:1 relationship

2003-10-15 Thread oliver . matz
Hello, > -Original Message- > From: Emmanuel Dupont [mailto:[EMAIL PROTECTED] > > No '' should be done. > > Sample : > > INSERT INTO A (Apk, Bfk) VALUES ('100',''); > > It should be : > > INSERT INTO A (Apk) VALUES ('100'); This problem is addressed by another thread in this list (al

Re: RE : How to map optional 1:1 relationship

2003-10-15 Thread Jakob Braeuchi
voyé : mercredi 15 octobre 2003 14:22 À : OJB Users List Objet : Re: How to map optional 1:1 relationship hi olli, carl, you should try to avoid primitives for fk columns. when you disconnect the reference ojb will not be able to correctly set the fk to null when using primitives ! later when load

RE : How to map optional 1:1 relationship

2003-10-15 Thread Emmanuel Dupont
been set. Isn't it ? -Message d'origine- De : Jakob Braeuchi [mailto:[EMAIL PROTECTED] Envoyé : mercredi 15 octobre 2003 14:22 À : OJB Users List Objet : Re: How to map optional 1:1 relationship hi olli, carl, you should try to avoid primitives for fk columns. when you disconnect

Re: How to map optional 1:1 relationship

2003-10-15 Thread Jakob Braeuchi
hi olli, carl, you should try to avoid primitives for fk columns. when you disconnect the reference ojb will not be able to correctly set the fk to null when using primitives ! later when loading the parent object it may contain a fk to a non materializable proxy. the samples are not a good re

RE: How to map optional 1:1 relationship

2003-10-15 Thread oliver . matz
Hello, > -Original Message- > From: Boyes, Carl [mailto:[EMAIL PROTECTED] > I've currently > mapped it as a 1:1, but the when the foreign key reference is > null an extra sql statement with a where condition of > fkey = '' > is generated. this question has been asked fairly often