Re: Cross database query

HSQLDB supports queries combining tables in multiple schemas in the same database. It does not support queries on multiple databases.

If your databases are not too large, you should be able to automate a data export / import setup to create and update one combined database for querying.

Alternatively, this JDBC tool might be a solution www.unityjdbc.com/

Fred Toussi

On Mon, Jun 8, 2020, at 22:58, Sébastien Pérès-Labourdette wrote:
> Hi there.
> 
> I have an 2.5 hsqldb server hosting 6 database instances sharing quite
> the same db schema.
> How to compose queries mixing joins from / to structures hosted on
> different database from / to structures hosted on the currently
> connected one, on the same server ?
> 
> Cheers
> --
> Sébastien
> 
> 
> 
> 
> 
> 
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> 
> 
> *Attachments:*
>  * signature.asc

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user