RE: JOIN between tables from different databases?

[Charles Anthony <ch...@hpdsoftware.com>]

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:servicerespond.dirkmanske@nexgo.de]
> 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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 


___________________________________________________________
HPD Software Ltd. - Helping Business Finance Business
Email terms and conditions: www.hpdsoftware.com/disclaimer 



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org