Re: Cross database query

Sébastien Pérès-Labourdette <[email protected]> Tue, 23 Jun 2020 12:34:21 +0200
Newsgroups	gmane.comp.java.hsqldb.user
Organization	Groupe omerin
Message-ID	<[email protected]>
Thanks Fred for your wise answer.
I'll dig into that.

I have another issue while using

BACKUP DATABASE TO '" + backupPath + "' NOT BLOCKING AS FILES

on some databases.

_Example :_
I have following files on my server (cumulated size is approximately 150M)
-rw-r--r-- 1 root   root    12M Jun 23 12:11 cache-cgp.backup
-rw-r--r-- 1 root   root    64M Jun 23 12:15 cache-cgp.data
-rw-r--r-- 1 root   root     16 Jun 23 12:30 cache-cgp.lck
-rw-r--r-- 1 root   root    76M Jun 23 12:30 cache-cgp.log
-rw-r--r-- 1 root   root    101 Jun 23 11:54 cache-cgp.properties
-rw-r--r-- 1 root   root    45K Jun 23 11:54 cache-cgp.script


Backup database on this database generates a 17G file
-rw-r--r-- 1 root   root    17G Jun 23 11:45 cache-cgp.data
-rw-r--r-- 1 root   root    101 Jun 23 11:40 cache-cgp.properties
-rw-r--r-- 1 root   root    45K Jun 23 11:40 cache-cgp.script

How come ?

------------------------------------------------------------------------
*De : *Fred Toussi Via Hsqldb-user <[email protected]>
*Envoyé : * Mardi 9 Juin 2020 11:09:29
*À : *Hsqldb User List <[email protected]>
*Cc : *Fred Toussi <[email protected]>
*Objet : *Re: [Hsqldb-user] 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/
> <http://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]
>> <mailto:[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

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
signature.asc (application/pgp-signature, 488 B)