Re: Query a non navigable path

[Sebastien Cesbron]

The connexion is that my email have one sender and one receiver.
For this example, the database looks like
create table EMAIL
(
  ID          integer not null,
  SENDER_ID   integer not null,
  RECEIVER_ID integer not null,
  primary key (ID),
  foreign key (SENDER_ID)   references USER(ID),
  foreign key (RECEIVER_ID) references USER(ID)
);
create table USER
(
  ID integer not null,
  primary key (ID)
);
Seb

PS : Sorry if there is syntax erros, I can't cut and paste my sql

Jim Moore wrote:
Do you have anything that would connect them?  What does your database
definition look like for those tables?
-----Original Message-----
From: Sebastien Cesbron [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 01, 2003 1:07 PM
To: [EMAIL PROTECTED]
Subject: Query a non navigable path

Hi,

I'am always on the way of integrating ojb in my project. It works very 
well but I am in front of a problem I can't solve.
I have for example this classes :
Class Email
{
private User sender;
private User receiver;
}
Class User
{
// No link to the * emails I sent or received
}

I am using the PB-API an I want to retrieve a liste of all users that 
were receivers of email I sents. How can I do that ?
As queries are based on path expressions and I don't have path from 
receiver I don't know how to do such a query

Thanks in advance for any help

Seb

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]