Hi Dirk, I'm afraid this would not be possible using OJB. OJB is, at it's very lowest level, simply converting the query objects (or OQL) into ordinary SQL Queries.
It is not possible (at least, not as far as I am aware) for SQL queries to span multiple databases/schemas/catalogs/jdbc-connections, and so OJB cannot join the two tables directly. Sorry, Cheers, Charles. > -----Original Message----- > From: Dirk Manske (Service Respond) > [mailto:[EMAIL PROTECTED] > Sent: 09 March 2004 15:52 > To: 'OJB Users List' > Subject: JOIN between tables from different databases? > > > Hi, > > we are using PB API with DB2 7. We have two database schemes > where each > database is served by ist own PBKey broker. Now we need to > join two tables > from each database. Is this possible when using the OJB Query > API?? If so, > can someone provide an example? > > thx, > > Dirk > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > ___________________________________________________________ HPD Software Ltd. - Helping Business Finance Business Email terms and conditions: www.hpdsoftware.com/disclaimer --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
