Re: Cross database query

I don't know how this happens. The backup AS FILES simply copies the files.

You can get paid support for this sort of issues.

Fred


On Tue, Jun 23, 2020, at 11:34, Sébastien Pérès-Labourdette wrote:
> 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/
>> 
>> 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
>> 
> 
> _______________________________________________
> 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