FWD » Core Development » Database

08/20/2021

04:48 PM Bug #5615: Project builds should copy out p2jpl.jar from FWD

I encountered a related issue while setting up the pg database on Windows. My installation is on a dedicated drive @Z... Ovidiu Maxiniuc

02:36 PM Bug #5615: Project builds should copy out p2jpl.jar from FWD

Vlad had this suggestion:
> Hi Roger.
>
> The goal ant import.db relies on the file p2jpl.jar is located in /us... Roger Borrello

02:36 PM Bug #5615 (New): Project builds should copy out p2jpl.jar from FWD

Roger Borrello

08/18/2021

06:37 PM Feature #5491: custom locale/collation implementations

Roger Borrello wrote:
> Will the custom locale part of the "Database Server Setup":/projects/p2j/wiki/Database_Serve... Ovidiu Maxiniuc

05:34 PM Feature #5491: custom locale/collation implementations

> is this an OS locale customization
It is at the OS level. Greg Shah

03:04 PM Feature #5491: custom locale/collation implementations

Will the custom locale part of the "Database Server Setup":/projects/p2j/wiki/Database_Server_Setup_for_PostgreSQL_on... Roger Borrello

08/10/2021

05:53 PM Feature #4723: make it significantly easier to run database import

Greg Shah wrote:
> Even if some records are dropped, the system should be left in a workable state. In my opinion, ... Eric Faulhaber

05:35 PM Feature #4723: make it significantly easier to run database import

Even if some records are dropped, the system should be left in a workable state. In my opinion, the @p2j_id_generato... Greg Shah

05:35 PM Feature #4723: make it significantly easier to run database import

Yes, I think it is possible to launch @DatabaseDumpChecker@ during import process and passing the current byte mappin... Ovidiu Maxiniuc

04:39 PM Feature #4723: make it significantly easier to run database import

I recently noticed that upon importing test data into a PostgreSQL database, I got errors about bytes that could not ... Eric Faulhaber

08/03/2021

12:08 PM Feature #5491: custom locale/collation implementations

If the import process finds the PSC footer it will be able to read and process it.
The correct offsets are not so im... Ovidiu Maxiniuc

11:48 AM Feature #5491: custom locale/collation implementations

If I am getting @Unable to read PSC footer. Failed magic check.. Heuristic search found a PSC footer candidate. The f... Roger Borrello

07/29/2021

07:38 AM Feature #5491: custom locale/collation implementations

I do not know why are those created. The @locale-gen@ seems a bit buggy to me; or at least the command-line help/manu... Ovidiu Maxiniuc

10:17 PM Feature #5491: custom locale/collation implementations

Ovidiu, I added the following to my @/etc/locale.gen@ file:... Eric Faulhaber

07/28/2021

03:36 PM Feature #5491: custom locale/collation implementations

Also, please apply the needed changes to Hotel GUI and Hotel ChUI. Greg Shah

03:35 PM Feature #5491: custom locale/collation implementations

Please send an email to the entire team to explain the changes needed to move to rev 12732. Greg Shah

03:25 PM Feature #5491: custom locale/collation implementations

Ovidiu Maxiniuc wrote:
> Starting with r12732, the collation provider was renamed to @FwdCollatorProvider@ and the j... Roger Borrello

03:17 PM Feature #5491: custom locale/collation implementations

Starting with r12732, the collation provider was renamed to @FwdCollatorProvider@ and the jar @fwdspi.jar@.
Starting... Ovidiu Maxiniuc

08:08 AM Feature #5491: custom locale/collation implementations

In Java 11, the SPI will load from the classpath. When we work the move to Java 11, this will be part of the work. Greg Shah

07:59 AM Feature #5491: custom locale/collation implementations

@jrunscript@ is deprecated and will be removed in a future JDK. At the same time @lib/ext@ mechanism is already dropp... Ovidiu Maxiniuc

07:51 AM Feature #5491: custom locale/collation implementations

I prefer to avoid @jrunscript@ because it is an additional dependency which then must be configured/maintained. For ... Greg Shah

06:49 AM Feature #5491: custom locale/collation implementations

Here is a solution:... Ovidiu Maxiniuc

07/27/2021

05:15 PM Feature #5491: custom locale/collation implementations

> We need to locate this directory first. Is there are OS level setting for it or we need to manipulate the path of @... Greg Shah

05:08 PM Feature #5491: custom locale/collation implementations

Starting in Java 9, we will be able to load it from the classpath so this will "go away". We will be moving from Jav... Greg Shah

04:28 PM Feature #5491: custom locale/collation implementations

Roger Borrello wrote:
> I would think you should be able to include a colon-separated (or semi-colon separated on Wi... Igor Skornyakov

04:24 PM Feature #5491: custom locale/collation implementations

Roger Borrello wrote:
> I would think you should be able to include a colon-separated (or semi-colon separated on Wi... Ovidiu Maxiniuc

04:07 PM Feature #5491: custom locale/collation implementations

I guess that we need to add the JRE's ext dir into the dir list that is passed so that both the JRE ext dir and our c... Greg Shah

04:05 PM Feature #5491: custom locale/collation implementations

Ovidiu Maxiniuc wrote:
> The @-Djava.locale.providers=SPI,JRE@ seems to be irrelevant I did not notice any change in... Roger Borrello

04:01 PM Feature #5491: custom locale/collation implementations

The @-Djava.locale.providers=SPI,JRE@ seems to be irrelevant I did not notice any change in behaviour regardless of i... Ovidiu Maxiniuc

12:36 PM Support #5183: database collation

I do not think this is a problem. Please follow this steps:
# edit @/etc/locale.gen@ (as root) and uncomment @en_US.... Ovidiu Maxiniuc

11:44 AM Support #5183: database collation

> Isn't this enough?
It is enough for any customer that is able to implement the custom locales. It won't work fo... Greg Shah

10:55 AM Support #5183: database collation

With latest FWD support for locale/collations, if the PG cluster is created like this:... Ovidiu Maxiniuc

06:20 AM Support #5183 (WIP): database collation

Greg Shah

06:18 AM Support #5183: database collation

I would like to have the same 8859-1 analysis done for the other two codepages/collations which we are supporting (88... Greg Shah

06:11 AM Support #5183: database collation

I reviewed the page and it is good for the initial purpose of this task. I've sent the customer the link.
We have... Greg Shah

07/26/2021

07:05 PM Feature #5491: custom locale/collation implementations

In "Loading a Custom TimeZone Provider in Java 8":https://stackoverflow.com/questions/58937553/loading-a-custom-timez... Greg Shah

03:09 PM Feature #5491: custom locale/collation implementations

Greg Shah wrote:
> I agree this would be preferred. On the other hand, I wonder if there is a way to eliminate this... Ovidiu Maxiniuc

02:49 PM Feature #5491: custom locale/collation implementations

> Is this best scripted into @install_spawner.sh@ (even though that name wouldn't be accurate)?
No, this is too c... Greg Shah

02:32 PM Feature #5491: custom locale/collation implementations

I do not think this is a problem: @p2jspi.jar@ will provide @en_US_P2J@ via @P2JCollatorProvider@ and @fwdspi.jar@ wi... Ovidiu Maxiniuc

02:32 PM Feature #5491: custom locale/collation implementations

I'd like a "safe" way to update the @fwdspi.jar@ file. Is this best scripted into @install_spawner.sh@ (even though t... Roger Borrello

02:28 PM Feature #5491: custom locale/collation implementations

Eric Faulhaber wrote:
> Ovidiu Maxiniuc wrote:
> > Is this a good time to rename @p2jspi.jar@ to @fwdspi.jar@?
>
... Constantin Asofiei

02:17 PM Feature #5491: custom locale/collation implementations

We can't just search and replace. We must leave the older docs in place and just explain the difference starting wit... Greg Shah

02:01 PM Feature #5491: custom locale/collation implementations

Ovidiu Maxiniuc wrote:
> Is this a good time to rename @p2jspi.jar@ to @fwdspi.jar@?
I don't have an objection, b... Eric Faulhaber

01:53 PM Feature #5491: custom locale/collation implementations

Is this a good time to rename @p2jspi.jar@ to @fwdspi.jar@? Ovidiu Maxiniuc

04:15 AM Support #5183 (Review): database collation

This issue became primarily about documenting the differences in database collation between the legacy environment an... Eric Faulhaber