strange OJB behaviour

2004-12-26 Thread T. K. Chris 
HI,

I have tried to access a database through a loop.
while the loop is running, I manually modify (in live)
and commit a record in the data base. The modification
is not detected, at the next incrementation within the
running loop.

What could be the problem. It sounds as I am missing
something...

Your help is precious;
Thanks.

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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

sql Join request with QueryBySQL

2004-11-07 Thread T. K. Chris 
Hi, 
Pb. I have 2 tables : CLIENTS, UTILISATEURS mapped by
java classes ClientsVO and UtilisateursVO; there is no
relation defined between the both tables. The
sqlString below is the sql request needed to retrieve
the data.

My problem is that I did not find any example showing
how to trigger raw SQL requests. I need some
references, examples or tutorials of how to do this.
Please could you tell me what is wrong with this. 
String sqlString = SELECT CLIENTS.CL_ID,
CLIENTS.CL_NOM, CLIENTS.CL_PRENOM, CLIENTS.CL_ADRESSE,
CLIENTS.CL_CP, CLIENTS.CL_VILLE, CLIENTS.CL_PAYS,
CLIENTS.CL_TEL
+ FROM UTILISATEURS
+ LEFT OUTER JOIN CLIENTS
+ ON UTILISATEURS.UT_ID=CLIENTS.CL_ID
+ ON UTILISATEURS.UT_ID=CLIENTS.CL_ID
+ WHERE UT_VIS=+sVin;
QueryBySQL queryBySql = new
QueryBySQL(ClientsVO.class, sqlString);
Collection clients =
broker.getCollectionByQuery(queryBySql); 
In general, what is the syntax of triggering raw sql
JOIN request with OJB using independant table (i.e.
without any relationship between tables except common
primary key comumn.) 
Thanks.







Vous manquez d’espace pour stocker vos mails ? 
Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour 
dialoguer instantanément avec vos amis. A télécharger gratuitement sur 
http://fr.messenger.yahoo.com

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