Re: Cross database query

Sébastien Pérès-Labourdette <[email protected]> Tue, 23 Jun 2020 18:33:47 +0200
Newsgroups	gmane.comp.java.hsqldb.user
Organization	Groupe omerin
Message-ID	<[email protected]>
My fault. Sorry for that dummy one.
Defrag + Backup is much much more optimal !

--
Sébastien

------------------------------------------------------------------------
*De : *Fred Toussi Via Hsqldb-user <[email protected]>
*Envoyé : * Mardi 23 Juin 2020 14:22:16
*À : *Hsqldb User List <[email protected]>
*Cc : *Fred Toussi <[email protected]>
*Objet : *Re: [Hsqldb-user] 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]>
>> <mailto:[email protected]>
>> *Envoyé : * Mardi 9 Juin 2020 11:09:29
>> *À : *Hsqldb User List <[email protected]>
>> <mailto:[email protected]>
>> *Cc : *Fred Toussi <[email protected]>
>> <mailto:[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] <mailto:[email protected]>
>>> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>>>
>>
>> _______________________________________________
>> 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)